Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Hints in Practice

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US