SQLUSA
 

Microsoft SQL Server 2000

Best Practices

 

How to check indexes on a table?

 

Use the system stored procedure:

exec sp_helpindex TableX

You can also see the indexes in Enterprise Manager table designer.

 

Best in the World in SQL Server Training
 
SQLUSA.com Home Page