Re: Index management

VC wrote:

> Me too, me too !.

Don't forget, I really want to find out as well, because it doesn't help *at all* to have widely-read authors using language in an indeterminate and imprecise way.

But whatever it turns out to be, don't lose site of the bigger picture: whatever ratio Mike uses to suggest a rebuild, the rebuild can never, ever alter the clustering factor of the index.

So one hopes from logical necessity that the clustering factor is not an element of the ratio he uses to suggest a rebuild.

Because you would then be prompted to rebuild by something which doesn't change after the rebuild; which therefore promts you to rebuild; which therefore prompts you to rebuild; which therefore prompts you to rebuild; which therefore prompts you ...

You get the idea.

Regards
HJR Received on Sat May 08 2004 - 21:55:32 CDT