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."


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: