| |
GeekInterview.com > Interview Questions > Oracle > Scenarios
| Print | |
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
|
| July 07, 2005 05:23:19 |
#2 |
| Rakesh Gautam |
Member Since: Visitor Total Comments: N/A |
RE: If the large table contains thousands of records and the application is accessing 35% of the table w
|
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 .
|
| |
Back To Question | |
