August 10, 2011 at 12:24 pm
After a long time i had done rebuilding indexes in maintenance plan . after that i observed datafile size increases. Why it happens after that process. what should i need to do next time when i rebuild?
August 10, 2011 at 1:00 pm
When you rebuild the server makes a 2nd copy of the index (if clustered, then the whole table). Then there's a little more overhead.
August 10, 2011 at 1:08 pm
this time it makes one copy
next time if i do it makes other copy (3rd copy)
can u clarify?
August 10, 2011 at 1:13 pm
It makes a copy while sorting.
Once done it deletes the old one and swap the new one in.
You should see the datafile bigger, but with more free space (used you lowered the fill factor as well in the rebuild)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply