Re: Index management

"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message news:409DF7C2.C34_at_yahoo.com...

> There IS a ratio...Its
>
> effort to rebuild / benefit of rebuild < 1
>
> Of course, you can't precisely define the benefit until you've done it..
>
> :-)

I prefer a subtraction

benefit of rebuild - cost of rebuild > 0

Of course this suffers from the problem you identify twice, you can't measure the benefit until you have performed the action, but you probably can't measure the cost until you have performed the action either, not often I agree with Rumsfeld but that unknowns quote seems appropriate here. I know that I should be measuring the benefits and the costs, but i'm not sure what either of them are.

cheers

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
http://www.niall.litchfield.dial.pipex.com/