Quick steps: Querying and updating index statistics

Learn to query and update index statistics in this book excerpt from MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation.

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

  1. Open the Query Analyzer from the Start menu.

  2. To see the statistics for the titleind index in the Titles table, use the following:
    USE pubs
    GO
    DBCC SHOW_STATISTICS (titles, titleind)
    

  3. 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
This Content Component encountered an error

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close