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
Feb 01, 2010 at 12:37 PM
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?
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Feb 01, 2010 at 12:37 PM
Seen: 1302 times
Last Updated: Feb 01, 2010 at 12:37 PM
What is the maximum no.of columns a table can have ?
Relationship among database, tablespace and data file ?
How to add one more field to the below existing table ?
Oracle Full backup and restore any time (snapshot) ?
How Oracle 10g decides the # of processes to drop a partition table ?
DUAL table structure in Oracle ?
What are the various types of database triggers ?
Is it possible to do flashback after truncate?
How to Migrate of 10TB database from 9i to 10g + 10 standby sites ?
Manage max table storage space in case of excess data (size in GB)