Re: Index rebuilding

SOMETHING must have changed. Without re-analyzing the optimizer is not aware of any - real or perceived - deterioration of the index. Show me the plan and all stats for both cases.

At 07:57 AM 11/12/2004, Niall Litchfield wrote:

>Now it so happens that a noted author gave these bullet points in a
>presentation at UKOUG which might help us here.
>
>Ways to modify access paths
>
>Change the statement
> Use hint
> Use Stored Outline
> Change statistics
> Create or drop a database object
> Change initialization parameters
>
>I've indented these slightly differently from the original
>presentation, since I regard using a hint and using a stored outline
>as ways of changing the statement.

A hint technically changes the statement (it gets a new hash value) while using a stored outline does not (it retains its hash value, which is the point other wise outlines won't work).
With "Change the statement" I mean totally rewriting the sql so that it is semantically identical (returns the same result) but is syntactically different.

Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com

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