SQL Server Performance

nonclustered index

Discussion in 'Performance Tuning for DBAs' started by aijaz90, Feb 4, 2003.

  1. aijaz90 New Member

    Using system tables I would like to determine what user tables on our machine are nonclustered indexed.

    'DBCC Showcontig' gives 'Index ID' values of '0' and '1', 'Index ID = 1' corresponding to clustered index. However, 'Index ID = 0' may be associated with nonclustered indexed table, or to a table with no index at all (as per Enterprise Manager). So, I am looking for additional information that may be stored in some system table to distinguish between nonclustered indexed tables and tables with no index at all.

    aijaz90
  2. satya Moderator

Share This Page