Troubleshooting: Determining the indexes on a table in SQL

Issue

When troubleshooting problems in SQL Server 2005, you may need to examine the indexes on a table.

Details

An index provides fast access to data in the rows of a table, based on key values.

Solution

Note: Ensure that you are logged in using the AgfaService account; you cannot log into SQL Management Studio using the Administrator account.

To determine what indexes are on a table

1. In the SQL Server Management Studio, open a new query window.

2. Type sp_helpindex <table_name>

   where <table_name> is the name of the table you want to find indexes on.

3. Click Execute.

   The index list and their properties are displayed. Ignore the entries starting with _WA as they are temporary indexes created by the server. The server discards them.