Re: Oracle Hint Behavior
Date: Wed, 30 Jan 2008 07:27:00 -0800 (PST)
On Jan 30, 9:28 am, "Dereck L. Dietz" <diet..._at_ameritech.net> wrote:
> Oracle 10.2.0.3.0
> Windows 2003 Server
> What is the behavior of hints in Oracle 10g? I knew that prior to 10g
> Oracle would treat them as only "suggestions" but I thought in 10g they
> would be mostly followed.
> We have a query which is doing a full table scan even with hints being used
> to try to get it to use an index. I can see why it would choose a full
> table scan considering the percentage of the table being returned but I'd
> like to be able to explain why the hint is being ignored now.
Even prior to 10g, if a hint was valid, oracle would follow it. I
Jonathan Lewis explained in greater detail on when a hint might not be followed.
Anurag Received on Wed Jan 30 2008 - 09:27:00 CST