First checks:
- Check the statistics to make sure that they are the latest
- No missing indexes
- Distinct
- Group by, Order by
- Sub Queries in WHERE Clause
- Nested Views
- Reduce the number of joins
- Reduce number of tables joined in single query
- Reduce the data sorting in the query
No comments:
Post a Comment