The following excerpt, courtesy of Que Certification, is from Chapter 10 of the book MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation by Thomas Moore and Ed Tittel. Click for the complete book excerpt series or purchase the book.
STEP BY STEP - 10.6
Querying and updating index statistics
- Open the Query Analyzer from the Start menu.
- To see the statistics for the titleind index in the Titles
table, use the following:
USE pubs GO DBCC SHOW_STATISTICS (titles, titleind)
- To update its statistics, run the following:
UPDATE STATISTICS titles titleind
Click for the complete book excerpt series.
This was first published in January 2006