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 '10 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.
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.
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 '10 at 12:37 PM
Seen: 969 times
Last Updated: Feb 01 '10 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 update multiple tables with a single query ?
Can flashback of database be implemented more than once after resetlogs?
What are various types of joins ?
Oracle and Informix together?
Is there any way to export a dropped table?
How Oracle 10g decides the # of processes to drop a partition table ?
DUAL table structure in Oracle ?