Re: Hints in Practice

From: Bob Jones <email_at_me.not>
Date: Sun, 27 Aug 2006 23:10:41 GMT
Message-ID: <RDpIg.20868$gY6.14368@newssvr11.news.prodigy.com>

"hpuxrac" <johnbhurley_at_sbcglobal.net> wrote in message news:1156702585.746264.68470_at_b28g2000cwb.googlegroups.com...
>
> Bob Jones wrote:
>>
>> That is correct. Oracle is about the only database I know uses explicit
>> hints. That is not really a vote of confidence in their optimizer.
>>
>> I would do anything to avoid using those hints. They are not portable and
>> do
>> not conform to any standard. It is almost always possible to build good
>> performing queries without hints.
>
> "Almost always possible" ... don't the 2 words on either side of always
> make your statement meaningless.
>

Are you trying to waste some more of my time?

> Dial back into this debate when you understand what you are talking
> about.
>

You should. Received on Sun Aug 27 2006 - 18:10:41 CDT