answersLogoWhite

0


Best Answer

Generally, if a select is accessing half of a table it will do a table scan. With thousands of records that should not slow it down much. If you were talking millions of records that might be a different story.

User Avatar

Wiki User

15y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: If a large table contains thousands of records and the application is accessing half of the table which method do you use index searching or full table scan?
Write your answer...
Submit
Still have questions?
magnify glass
imp