oracle can ignore hints

  • From: <ryan.gaffuri@xxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 4 Mar 2004 13:44:02 -0500

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:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at //
FAQ is at //

Other related posts: