Question:
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:
Index is more useful in this situation since it retrive rows faster than fts. fts read all blocks and since table contain thousands or rows . Source: CoolInterview.com
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 Source: CoolInterview.com
Answered by: Ian Carney | Date: 3/29/2010
| Contact Ian Carney
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|