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

Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question

GeekInterview.com > Interview Questions > Oracle > Scenarios

Go To First | Previous Question | Next Question

Scenarios | Question 13 of 25

Print

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

Last Update: February 19, 2007

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

#1

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

#2

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

#3

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

#4

aruna

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

by using TOP operator with Select statement

Is this answer useful? Yes | No

April 30, 2006 12:20:33

#5

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

#6

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

Sponsored Links

Real time Oracle Interview Questions Related

—

Sponsored Links

About Us | Privacy Policy | Terms and Conditions | Contact | Site Map | Add Question | Propose Category | RSS Feeds | Articles Sitemap | Site Updates | Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved