Using Hints in oracle pl/sql
Posted on 2011-04-28
so currently / i am working on tuning of oracle pl/sql using hints .
In many of my pl/sql statements full table scan is happening
For avoiding the full table scan i tried to use index hint on particular table but stil it is using full table scan.I was unable to understand how the index hint works.a;lso can you pls provide some inputs for getting into the use of hints which will be helpful in optimising the performance of pl/sql query