Re: Index rebuilding

Of course, you're absolutely right which is why I see rebuilding as a work around while I try and figure out why re-analysing doesn't solve the issue. Where I'm "lost" is what steps to take to isolate the issue. Cheers

Steve

Karsten Weikop wrote:

>Hi Steve
>
>Please read the execellent paper from Richard Foote (which can be
>downloaded from Miracle's site):
>
>http://www.miracleas.dk/images/upload/Docs/Richard%20Foote.pdf
>
>Conclusion form this paper: Never Rebuild, but find the course to the
>problem.
>
>In order to help you, we need some tracefile (perhaps also a 10056
>event) in order to help you).
>
>/karsten
>

--
http://www.freelists.org/webpage/oracle-l