April 20, 2012 at 5:20 am
Good Day. When the online-indexing feature is enabled , do we still have to run re-indexing jobs or will the database system rebuild the indexes himself when needed ?
April 20, 2012 at 6:00 am
Online index rebuilds is not a feature that you enable, it's just an option on an ALTER INDEX statement
ALTER INDEX ... REBUILD WITH ONLINE = ON rebuilds the index online, leaving the option off does the rebuild offline. That's it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 20, 2012 at 6:07 am
Gila Monster,
thank you for the feedback.But I would like to know if you still have to run the normal index rebuild but you add the online= on parameter in the rebuild statement ?
April 20, 2012 at 6:15 am
Of course you have to. How else would the indexes get rebuilt?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 20, 2012 at 10:35 am
Note that ONLINE indexing is only available in Enterprise, Developer and Evaluation Editions of SQL Server 2005 and above.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 20, 2012 at 2:25 pm
And it can be slow and require additional space when compared to offline.
April 21, 2012 at 3:18 am
Chuck Hottle (4/20/2012)
And it can be slow and require additional space when compared to offline.
The advantage of course is that the table\indexes are still available during the rebuild operation.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply