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

  • Interview Candidate
  • 9
  • 5648

Showing Answers 1 - 9 of 9 Answers

vishal

  • May 30th, 2005
 

FULL TABLE for more than 15% row access.

  Was this answer useful?  Yes

Rakesh Gautam

  • Jul 5th, 2005
 

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 . 

  Was this answer useful?  Yes

J Lehew

  • Aug 25th, 2005
 

Even if there is an index, if the query access more than 15% it does a full table scan regardless of what indexes are on the table.

  Was this answer useful?  Yes

aruna

  • Apr 3rd, 2006
 

by using TOP operator with Select statement

  Was this answer useful?  Yes

Surya Peri

  • Feb 18th, 2007
 

Hi,
15% of 100 million rows is still a lot of rows and would take lot of time if there is a full table scan.

  Was this answer useful?  Yes

Kedar_Risbud

  • Jun 22nd, 2009
 

Usually, whenever MORE THAN 2 to 4 % of rows in a table are going to be returned by  a query, a full table scan is preferred over an indexed scan. So in this case, as 35% of rows of the table are accessed by the application, a full table scan will be used.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions