Index FAQ

The following section contains several frequently asked questions and answers about indexes.

Q1: How can I view the index selectivity (density) of an indexed column?
A1: The index selectivity can be viewed by using the Transact SQL Statement DBCC SHOW_STATISTICS. DBCC SHOW_STATISTICS displays the average key length of an index, the index density, and the distribution steps.
Q2:What are composite indexes?
A2: Composite indexes are indexes created with two or more columns. (The maximum number of columns for an index is 16.) SQL Server 2000 keeps distribution page and histogram statistics on the columns that make up the index. Try not to get carried away by creating composite indexes with a large number of columns. (I try to keep them under ...

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.