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
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: 1141 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 ?
Can we restore a dropped table after a new table with the same name has been created?
What is the difference between restoring and recovering?
Exported Constant Definition
How does one backup a database using the export utility?
How to import tables to different tablespace ?
Error securing Database Control!?!
What tuning indicators can we use?