Re: Oracle Hint Behavior

From: Anurag Varma <>
Date: Wed, 30 Jan 2008 07:27:00 -0800 (PST)
Message-ID: <>

On Jan 30, 9:28 am, "Dereck L. Dietz" <> wrote:
> Oracle
> 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.
> Thanks.

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.


Anurag Received on Wed Jan 30 2008 - 09:27:00 CST

Original text of this message