Note in-line
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated Sept 2nd
"Christian Antognini" <christian.antognini_at_trivadis.com> wrote in message
news:414b112d_at_post.usenet.com...
>
> I already had similar problems. Since outlines are hints and, like any
> hints, sometimes the CBO decide not using them, it happens that an outline
> simply doesn't work :-(
>
You've got the argument the wrong way round.
Since outlines are hints, we can infer that a complete
and legal set of hints cannot be ignored by the optimiser.
> How did you modify the outline? If you used the Outline Editor, did you
get
> the "correct" plan when you tried to validate the changes?
>
Excellent question - and the other important question is:
"How did the OP decide that Oracle was using the
outline ?"
Received on Sun Sep 19 2004 - 00:41:45 CDT
