I am having a table which contains 80k to one l lakh records. While running explain plan query its not using indexes. And it seems, its doing full table scan.
I am not sure why oracle is not using indexes? Am I missing anything here?
Thank you, Regards,
BI DWH BALA