x

If the large table contains thousands of records and the application is accessing 35% of the table which method to use ?

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 ? Thank you

more ▼

asked Feb 01 '10 at 12:37 PM in Default

OraLearner gravatar image

OraLearner
1.3k 69 85 88

I think we need more information for a definitive answer. Are you asking what should be done or what will be done. For the former we need to know how many columns there are, how big they are, how much data they contain, how many are being selected, and probably a few other things. For the latter we also need to know what version of Oracle, whether object and system statistics have been gathered, and even then it would still just be an educated guess. Do you have a query doing a full table scan when you think it shouldn't? Can you show the query and provide some information on the tables?
Mar 30 '10 at 05:17 PM Leigh Riffel
(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x375
x235
x82

asked: Feb 01 '10 at 12:37 PM

Seen: 969 times

Last Updated: Feb 01 '10 at 12:37 PM