Re: Hints in Practice

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 25 Aug 2006 15:05:33 -0700
Message-ID: <1156543532.226512@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.

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

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Fri Aug 25 2006 - 17:05:33 CDT