DBCC SHOWCONTIG - the output

• off2pdx

  SSC Rookie

  Points: 27

  More actions

  February 12, 2004 at 10:42 pm

  #107055

  These are new SQL2k db - created by a conversion from Progress databases.

  When running DBCC SHOWCONTIG WITH TABLERESULTS today, I was surprised to see that NO index names show in the output.  There are over 400 user tables, and probably twice that many indexes.  Execution plans show that indexes are being used.

  At the very least, I would expect to see index names for the system tables.

  Any ideas what this is all about?  How much should I panic?

• mccork

  SSC-Insane

  Points: 22288

  More actions

  February 13, 2004 at 12:55 am

  #493947

  Try:

    dbcc showcontig with tableresults, all_indexes

  
  Cheers,
  - Mark