Suggested Index Strategies
Index selection is based on the design of the tables and the queries that are executed against the tables. Before you create indexes, make sure that the indexed columns are part of a query or are being placed on the table for other reasons, such as preventing duplicate data. The following sections suggest some indexing strategies.
What to Index
The following list shows criteria you can use to help determine which columns will make good indexes:
Columns used in table joins
Columns used in range queries
Columns used in order by queries
Columns used in group by queries
Columns used in aggregate functions
What Not to Index
The following list shows cases in which columns or indexes should not be used or should be used sparingly: ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.