Well it seems like we both believe contradictory things. Could you give us
an example?
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
news:1072890351.363963_at_yasure...
> Niall Litchfield wrote:
>
> > "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).
>
> I believe Oracle often ignores valid hints. I have tried to
> intentionally put together classroom demos with hints and been
> repeatedly frustrated by the hint being ignored.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Wed Dec 31 2003 - 14:39:07 CST
