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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle position on hints

RE: Oracle position on hints

From: Grabowy, Chris <cgrabowy_at_fcg.com>
Date: Sat, 08 Mar 2003 18:58:42 -0800
Message-ID: <F001.005640FB.20030308185842@fatcity.com>


Congratulations Connor!!! This is a great day in your life, although some guys would not agree...

And thanks for sharing your knowledge about Oracle.

-----Original Message-----
Sent: Saturday, March 08, 2003 8:54 PM
To: Multiple recipients of list ORACLE-L

Just to add my meaningless diatribe to the discussion, I think that there are "good" hints and "bad" hints.

For example, first_rows(n) is a good hint, in that you are giving the optimizer more information as to what your motivations are for this query, without stifling it into a choice that may not be appropriate down the track.

Hints such as index(tab,idx) are "bad" hints, because you are more exposed to grief. If the index is renamed, then its no longer a hint. If the data distribution changes, or the index is rebuilt in reverse or compressed, then it may no longer be a good option, etc.

In terms of the vendor speak of "hints imply weak optimizer" I think thats nonsense. Having worked with DB2 in the past, nothing used to be more irritating then coming up with bizarre convolutions on an otherwise simple SQL to ensure that certain indexes were or were not chosen.

Cheers
Connor

PS - Its probably a little sad that I'm chit-chatting on hints on the morning of my wedding day, but hey, you gotta pass the time somehow whilst the other half is getting the hair and makeup done :-)


Connor McDonald
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"



Do You Yahoo!?
Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: hamcdc_at_yahoo.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).  You may also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Grabowy, Chris
  INET: cgrabowy_at_fcg.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Sat Mar 08 2003 - 20:58:42 CST

Original text of this message

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