Performance Tips for SQL SELECT Statements
Check Indexes
Limit Size of Your Working Data Set
Only Select Fields You Need
Remove Unnecessary Tables
Remove OUTER JOINS
Remove Calculated Fields in JOIN and WHERE Clauses
Limit Size of Your Working Data Set
Only Select Fields You Need
Remove Unnecessary Tables
Remove OUTER JOINS
Remove Calculated Fields in JOIN and WHERE Clauses
No comments:
Post a Comment