Defraging all indexs in a table

[jeffmoore64]

Hi,
How do I defrag all of the indexs in a table? If I leave the index part of the dbcc indexdefrag statment off I get an error.
TIA

 

[ptheriault]

What version of SQL are you using. If this is 2005 your should not use DBCC INDEXDEFRAG use Alter Index. Also going forward it will not be supported. You are better off performing an ALTER INDEX (2005) DBCC DBREINDEX (2000)

Anyway,
Your syntax should look like this.

DBCC INDEXDEFRAG (0, 'table_name')

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[jeffmoore64]

THanks!!!