Why might the optimizer use a table scan when an index is available?

  • Interview Candidate
  • 1
  • 4612

Showing Answers 1 - 1 of 1 Answers

kalyanvadlamudi2kn

  • Jan 12th, 2014
 

if the stats are not collected on the table the index info is not available in the data dictionary, ,In such case the optimizer would pick up the full table scan instead of using the indexes. In order to always use the indexes we can give the hint to oracle to always use the index.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions