Oracle Scenarios Question:
Download Job Interview Questions and Answers PDF
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?
![Oracle Scenarios Interview Answer Oracle Scenarios Interview Question](https://globalguideline.com/public/images/interview/6.png)
Answer:
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
Measure both ways and decide
Download Oracle Scenarios Interview Questions And Answers
PDF