Re: Oracle Hint Behavior

From: Gints Plivna <>
Date: Sat, 2 Feb 2008 02:59:34 -0800 (PST)
Message-ID: <>

> 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:

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

Gints Plivna Received on Sat Feb 02 2008 - 04:59:34 CST

Original text of this message