Technique
SQL query optimisation
Making queries faster by reading execution plans (EXPLAIN), choosing indexes and rewriting queries.
Learn firstDatabase indexes
SQL query optimisation
What should you learn before SQL query optimisation?
- Database indexesMost query tuning comes down to whether a good index exists and is used.
Practise SQL query optimisation
- Intermediate SQL and MySQL Interview Questions3 questions on SQL query optimisation
- Advanced SQL and MySQL Interview Questions3 questions on SQL query optimisation
- SQL Interview Questions for Freshers1 question on SQL query optimisation