maintaining fragmented tables

• Manny Cruz

  SSC Veteran

  Points: 252

  More actions

  September 22, 2010 at 9:25 am

  #97589

  Hello

  I am not very familiar with the inner workings of SQL.

  I ran showcontig on our production DB and found

  the following tables have high Logical scan values - my reading seems to indicate some maint is required.

  I'd like to do indexdefrag or reindex on all 6 tables:

  sysobjects,sysindexes,syscolumns,syspermissions,sysdepends,

  syscomments.

  none of these have many pages - under 500

  What is the preferred method and what does the command syntax look like to get this done?

  thx all

• JeremyE

  SSCoach

  Points: 16212

  More actions

  September 23, 2010 at 2:53 pm

  #1226616

  DBCC DBREINDEX and DBCC INDEXDEFRAG cannot be used on system tables.

  http://msdn.microsoft.com/en-us/library/aa258828(SQL.80).aspx

  http://msdn.microsoft.com/en-us/library/aa258286(SQL.80).aspx