Re: Hints in Practice

From: Bob Jones <email_at_me.not>
Date: Sat, 26 Aug 2006 01:29:42 GMT
Message-ID: <auNHg.3184$yO7.3000@newssvr14.news.prodigy.com>

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1156543532.226512_at_bubbleator.drizzle.com...
> Bob Jones wrote:

>> "DA Morgan" <damorgan_at_psoug.org> wrote in message 
>> news:1156535110.265937_at_bubbleator.drizzle.com...
>>> Bob Jones wrote:
>>>
>>>> No, I was saying the exact opposite. I said hints in the SQL should be 
>>>> avoided at all cost. Read my posts.
>>> And reasonable people object to absolutist statements.
>>>
>>
>> That is quite an absolutist statement.
>>
>>> If it made my SQL statements run better I'd use duct tape.
>>
>> Yep, hints are like duct tapes for the optimizer.
>

> That's right ... just another tool to be used when it is appropriate.

>

> Couldn't agree more.

>

Yep, it is always appropriate if you live in the "Oracle only" world.

> If you want the last word take it because this thread is dead from
> my perspective.
> --

Yep, as dead as your argument. Received on Fri Aug 25 2006 - 20:29:42 CDT