9

Is the only difference between

ALTER INDEX [index_name] on [object_name] REBUILD with (ONLINE=OFF, FILLFACTOR=90)

and

DBCC DBREINDEX([dbname], 90) 

just that the DBCC command will reindex all of the indexes on all of the tables in the database?

2 Answers 2

9

The DBCC command is a consistency checker utility inside of SQL Server whereas ALTER is a DDL SQL command. The DBCC REINDEX command was deprecated in a previous version so it is not as robust as the new ALTER INDEX command is today. There is more functionality in the ALTER INDEX than the DBCC REINDEX commands:

http://msdn.microsoft.com/en-us/library/ms188388.aspx

Happy indexing!

1
  • I assumed as much, but just wanted to make sure.
    – swasheck
    Jan 23, 2012 at 20:54
2

The first is current usage, the second was deprecated in SQL 2005.

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.