Oracle Scenarios Question: Download Questions 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?
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