HansF schreef:
[snip]
> The point [I think] Frank is trying to make is: an index may have a
> natural size - for a specific %used/%free setting, blocksize and
> transaction pattern. Rebuilding may result in a significant savings in
> size, but if the settings/blocksize/transaction pattern are maintained,
> the index will eventually return to that natural size.
>
> Better to understand what is driving that natural size than blindly
> rebuilding.
>
That's about it, yes.
Which has been discussed so often, I thought a mere 'just wait
and see' answer would be sufficient.
But here I am, writing novels.
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Mon Feb 05 2007 - 13:27:08 CST
