Database performance tuning is important for every application to improve the application speed. Your approach to database performance tuning depends on the issues you are trying to resolve. Here are 10 best practices to help improve database speed and efficiency.
10 database performance tuning best practices
Making database performance tuning a routine practice:
1. Keep statistics up to date
2. Don’t use leading wildcards
3. Avoid SELECT *
4. Use constraints
5. Look at the actual execution plan, not the estimated plan
6. Adjust queries by making one small change at a time
7. Adjust indexes to reduce I/O
8. Analyze query plans
9. Compare optimized and original SQL
10. Automate SQL optimization
Reference: https://blog.quest.com/10-database-performance-tuning-best-practices/
Comments