Manage Learn to apply best practices and optimize your operations.

Quick steps: Viewing index information using sp_helpindex

Get a routine to view index information 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.4

Viewing index information using sp_helpindex

  1. Open the Query Analyzer by selecting Query Analyzer from the Start menu.

  2. To see the index-specific information about the indexes on the previously created table, IndexPractice, execute the following:
    EXEC sp_helpindex IndexPractice
    

  3. Alternatively, you can query the sysindexes table to find more information about the index you created in Step by Step 10.3. To do so, execute the following:
    Use Pubs
    Select * from sysindexes
    where name = 'age_index'
    

Click for the complete book excerpt series.

This was last published in January 2006

Dig Deeper on SQL Server Database Modeling and Design

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close