Optimizing complex and ugly written MySQL queries is one of the most unwanted tasks for any DBA. While we can load-off these queries to slaves to avoid many problems, sometimes you still see these queries in reports or in the slow query logs consuming a lot of resources.
In this webinar, we will explain some techniques to help minimize this situation while making the task of query optimization more bearable:
- Force index as a first approach
- Using sub-selects in order to force a temporary table
- Rewrite the query as the optimizer is executing
- Reorder the join with STRAIGHT_JOIN