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

Download Oracle Scenarios Interview Questions And Answers PDF

Previous QuestionNext Question
How to append data in a file from one server to another server?We are regularly changing the package body part. How will we create or what will we do before creating that package?