Re: Oracle Hint Behavior

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Sat, 2 Feb 2008 02:59:34 -0800 (PST)
Message-ID: <0e423cd5-dba5-4ab5-a4fa-67d244008d08@i12g2000prf.googlegroups.com>


> Even prior to 10g, if a hint was valid, oracle would follow it. I
> believe
> Jonathan Lewis explained in greater detail on when a hint might not be
> followed.
> example:http://jonathanlewis.wordpress.com/2006/11/11/what-is-a-hint/

Even more - don't know sure for all cases, but at least for a few cases hints are followed even if your db parameters are opposite. See more my blog entry
Hints "stronger" than db parameters? at
http://gplivna.blogspot.com/2007/10/hints-stronger-than-db-parameters.html

Gints Plivna
http://www.gplivna.eu Received on Sat Feb 02 2008 - 04:59:34 CST

Original text of this message