March 3, 2008 at 3:12 pm
Is there any body knowing Re-build indexing is good using DBCC DBREINDEX or we can use drop index first and then re-create again, can you please define the difference between Re-build the index using DBCC DBREINDEX and Drop the index and then Create again specially for the performance vice, which could be the better for re-build the index for all the databases
Thanks
Dipak
March 3, 2008 at 3:19 pm
DBCC REINDEX is going to be removed from future versions of SQL server. You should use the alter index statement.
more info.
March 3, 2008 at 3:23 pm
Rebuilding does drop and create indexes. Rebuilding indexes can be a performance hog, make sure to rebuild indexes at a time where you low traffic or a maintenance window is preferred.
March 3, 2008 at 3:28 pm
ya that is right but i have two syntax for Re-build the index
1) Re-building the index using Alter Index command
or
2) Drop the index and Create Index again
which one is better for the performance or both are same thing?
Thanks
Dipak
March 3, 2008 at 3:38 pm
They are the same thing, but I would use the alter index rebuild. This allows for online rebuilds and takes less steps.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply