Re: Why are optimizer hints required?

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Wed, 09 Mar 2005 22:31:21 +1100
Message-ID: <422ede86$0$31477$5a62ac22@per-qv1-newsreader-01.iinet.net.au>

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

Received on Wed Mar 09 2005 - 05:31:21 CST