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.
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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.