Answers

Question and Answer:

  Home  Oracle Scenarios

⟩ Explain If the large table contains thousands of records and the application is accessing 35% of the table which method to use index searching or full table scan?

A full table scan could be quicker,since it will fetch multiple blocks in one fetch, compared to index->table, index->table for each row.

Measure both ways and decide

 192 views

More Questions for you: