knowledge sharing initiative from http://linux-oracle-dba.blogspot.com/
What is index hint and what hint is not
Index hint is suggestion to optimizer not a command to it. If u provide hint it doesn’t h=mean that it will definitely get used . this decision is taken care by Optimizer itself.
Select /*+FULL(table_name) */ col1 ,col2
Using Index hints:
1 ) using CHOOSE… Continue
Posted on December 11, 2009 at 2:57am