Originally posted by adewri
No need to rebuild, the holes will get used when further inserts occur.
Not always. But holes are normally(?) not so important, the depth of the B-tree is more likely the reason to want to rebuild.
Rest in peace and let the indexes rest too.
Good advice - in most cases. (I bet there are more effective things that could be done to improve performance.)
(War story - index rebuild caused the biggest db trash ever I made - 7.3.4 with parallel option used a random number generator on them!)
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
Reply With Quote