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.

Dig Deeper on SQL Server Database Modeling and Design

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close