Thanks for the question, RUTHENDAR.
Asked: January 07, 2017 - 9:40 am UTC
Last updated: January 08, 2017 - 11:48 am UTC
Version: 11.2.0.2.0
Viewed 1000+ times
You Asked
A Select query is using Full table Scan. The execution time takes much long. How to force the query to use index scan option.
and Connor said...
You can use a hint for that, eg
select /*+ INDEX(t (index_col)) */ ...
from my_table t
but before you do that - you should be looking at *why* the optimizer has decided to do that. Better to research that first, eg out of date or incorrect stats, insufficient or incorrect histograms etc.
Is this answer out of date? If it is, please let us know via a Comment