Scenarios - If the large table contains thousands of records and the application is accessing 35% of the table w

GeekInterview.com > Interview Questions > Oracle > Scenarios

Go To First | Previous Question | Next Question

Scenarios | Question 13 of 25

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

Total Answers and Comments: 7

Last Update: June 23, 2009

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

May 30, 2005 03:16:52

vishal

RE: If the large table contains thousands of records and the application is accessing 35% of the table w...

FULL TABLE for more than 15 row access.

Is this answer useful? Yes | No

July 05, 2005 05:23:19

Rakesh Gautam

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 .

Is this answer useful? Yes | No

August 25, 2005 13:24:42

J Lehew

RE: If the large table contains thousands of records and the application is accessing 35% of the table w...

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.

Is this answer useful? Yes | No

April 03, 2006 07:10:59

aruna

RE: If the large table contains thousands of records a...

by using TOP operator with Select statement

Is this answer useful? Yes | No

0 1

Overall Rating: -1

April 30, 2006 12:20:33

pandish

Member Since: April 2006 Contribution: 7

RE: If the large table contains thousands of records a...

top N wont help because since when it is more than 15 it does not say which 15 rows?

Is this answer useful? Yes | No

February 18, 2007 18:50:53

Surya Peri

RE: If the large table contains thousands of records a...

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.

Is this answer useful? Yes | No

June 22, 2009 23:35:36

Kedar_Risbud

Member Since: June 2009 Contribution: 1

RE: 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

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.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank