SQL Server Database Indexing Questions

1

What data should I index in a SQL database?
When advice is given to only index on selective data in a SQL database, would you therefore index on a four digit integer (ID number) or a patient’s name, for example? Would this make sense logistically?

Answer Question   |  December 2, 2008  4:31 PM
SQL Server database, SQL Server Database Indexing
2,585 pts.

1