February 19, 2013 at 6:44 am
what is index online and index offline ?
February 19, 2013 at 6:50 am
you mean index rebuild online / index rebuild offline?
February 19, 2013 at 6:59 am
Or creating them online/offline?
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
February 19, 2013 at 7:00 am
yes
February 19, 2013 at 7:01 am
yes to which? rebuilds or creates?
February 19, 2013 at 7:22 am
what is index rebuild offline and index rebuild online
February 19, 2013 at 7:28 am
Rebuild online is where the index is available for use while the rebuild is happening.
Rebuild offline is where the index is not available for use while the rebuild is happening.
Not all indexes can be rebuilt online.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply