Improve DB queries performance
- Use indexes
- Look into query execution plan
- avoid N+1 query problem
Query Execution Plan
- This helps understand how the query is executing internally
- In SSMS, We can enable to include actual execution plan and see the query internally in GUI
- Estimated and actual execution plans are different. Actual is more useful