Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is the only difference between

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


DBCC DBREINDEX([dbname], 90) 

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

share|improve this question
up vote 7 down vote accepted

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:

Happy indexing!

share|improve this answer
I assumed as much, but just wanted to make sure. – swasheck Jan 23 '12 at 20:54

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

share|improve this answer
Thank you for your help. I assumed this was the case. – swasheck Jan 23 '12 at 20:54

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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