Re: Why are optimizer hints required?

Jonathan Lewis apparently said,on my timestamp of 9/03/2005 10:11 PM:

> in describing EXACTLY what you want the optimizer
> to do - otherwise it may find a way to obey the hints
> and still do something appalling.

Yup, very much my experience as well.
:)

> (Question: why does the spell-checker suggest
> "unhinged" for "unhinted"
> is this Microsoft trying to tell me something about
> the Oracle optimizer).

I get the same with Thunderbird. Heck, it doesn't even like its *own* name! Guess spell-checkers can't take a hint, eh?

-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
wizofoz2k_at_yahoo.com.au.nospam