⟩ 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