It should be most selective(more distinct values) because this reduces the number of database pages that must be read by the database engine while traversing the index, in order to satisfy the query.
Keep in mind that SQL Server's index has an entry for each of the row in underlying table, no matter they are unique or duplicate.
No comments:
Post a Comment