About database indexes

“Indexes are most beneficial when they are declared on columns that have many distinct values.” The more unique values that are in the column the faster the query will run. Even though you indexed the column it does not guarantee that SQL server will use the index. If the column does not contain enough unique values, then the sql server query optimizer will resort to a table scan and not use the index.