| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: oracle can ignore hints
Don't know how reproducible... the table is horrendously skewed with regards to histograms and the query is a 7 table join...
I can get full details from the lady doing the analysis if you like. It isn't pretty.
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
@>-->-->--
"Few people really enjoy the simple pleasure of flying a kite"
Adam Wells age 11
"Imagination is the highest kite one can fly."
Lauren Bacall
-----Original Message-----
From: Bobak, Mark [mailto:Mark.Bobak_at_il.proquest.com]
Sent: Thursday, March 04, 2004 3:03 PM
To: oracle-l_at_freelists.org
Subject: RE: oracle can ignore hints
Wow, that's a surprise. I've never run into a case where a properly specified hint was not used. I have always been of the view that a hint was a directive, and that if it was well-formed, it would not be ignored.
April, do you have a reproducible test case of the situation you described?
-Mark
-----Original Message-----
From: April Wells [mailto:AWells_at_csedge.com]
Sent: Thursday, March 04, 2004 2:45 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: oracle can ignore hints
Yep, they are 'friendly suggestions' that the CBO can simply choose to ignore if it thinks it knows better than you.
We have one query that we have hinted, we have computed statistics, we have built histograms, we have jumped through hoops... the only way to force it to use an index is to Never analyze that index and to hope, then, that the CBO makes the right assumptions.
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
@>-->-->--
"Few people really enjoy the simple pleasure of flying a kite"
Adam Wells age 11
"Imagination is the highest kite one can fly."
Lauren Bacall
-----Original Message-----
From: ryan.gaffuri_at_cox.net [ mailto:ryan.gaffuri_at_cox.net
<mailto:ryan.gaffuri_at_cox.net> ]
Sent: Thursday, March 04, 2004 12:44 PM
To: oracle-l_at_freelists.org
Subject: oracle can ignore hints
We had a discussion on here regarding hints. some of you stated that Oracle cannot ignore a proper hint. I have a TAR open and asked about this. Here is the response.
"A hint simply adds weight to a cost estimation, it can still be overridden by the CBO if the values aren't seen as useful."
-- Archives are at http://www.freelists.org/archives/oracle-l/ <http://www.freelists.org/archives/oracle-l/> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html <http://www.freelists.org/help/fom-serve/cache/1.html> ----------------------------------------------------------------- The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Mar 04 2004 - 17:22:13 CST
 |
 |