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: Wed, 23 Aug 2006 21:34:34 -0700
Message-ID: <1156394074.43746@bubbleator.drizzle.com>


Bob Jones wrote:
> "Frank van Bortel" <frank.van.bortel_at_gmail.com> wrote in message
> news:eci4dg$ijv$1_at_news6.zwoll1.ov.home.nl...

>> Bob Jones schreef:
>> [snip]
>>> The use of hints is discouraged. If you go to one of those DB2 classes, 
>>> they will tell you the same.
>>>
>>> I am not sure about SQL Server. Will they encourage the use of hints? I 
>>> doubt.
>> Neither does Oracle. Use hints as a last resort, that's the
>> general consensus...
>>

>
> Hmmm, I wonder why there are so many use of hints only in Oracle
> applications.

Not in the ones I write or manage. That is certainly not my experience.

-- 
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 Wed Aug 23 2006 - 23:34:34 CDT

Original text of this message

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