"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
news:1072827131.694131_at_yasure...
> > So why can't Oracle let us change things (that's a knuckle-wrap for
> > the hints-through-source mechanism)?
>
> Personally I'd like to see "hints" turned into "commands". I think I
> should be able to not just hint but demand. Oracle seems to disagree.
What do you mean by this? If you mean that Oracle can ignore valid hints
then I believe that you are incorrect (and I need someone to explain to me
how stored outlines work). If you mean that Oracle should not evaluate the
hint for validity but just try to follow it, well actually I can't believe
you mean that. My observation is that I cannot get Oracle to ignore
correctly formed and valid hints, though I can easily enough fail to
specify sufficient hints to force a specific access path. It seems to me
that hints *are* commands (albeit they are checked for validity first).
--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Wed Dec 31 2003 - 05:11:14 CST
