When extracting whole tables or large recordsets (say, at least 80% of the table), it is better to use Full Table Scan than use index. Full scan is more efficient in this case because it no longer need to search through the index for each record. It doesn’t need to because the whole table is going to be extracted anyways.
[Read more...]

Incoming search terms:

• sql server force table scan
• FORCE TABLE SCAN
• sql server force full table scan
• table scan in sql server
• sql server full table scan
• sql scan table
• sql server table scan force
• sql sybase forcing many indexes
• sql server select force table scan
• sql server full table scans