Oracle Hint Behavior
From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Wed, 30 Jan 2008 09:28:45 -0500
Message-ID: <BO%nj.9627$EZ3.8946@nlpi070.nbdc.sbc.com>
Date: Wed, 30 Jan 2008 09:28:45 -0500
Message-ID: <BO%nj.9627$EZ3.8946@nlpi070.nbdc.sbc.com>
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.
Thanks. Received on Wed Jan 30 2008 - 08:28:45 CST