---
title: MySQL Query Optimization
---

Search

Search

![percona-logo](https://learn.percona.com/hs-fs/hubfs/percona-logo.png?width=280&height=58&name=percona-logo.png)

 

Search

Search

## MySQL Query Optimization

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

### Registration Form

- PERCONA
- [Performance Blog](https://www.percona.com/blog/)
- [Forums](https://www.percona.com/forums/)
- [Online Tools](https://tools.percona.com/)
- [Percona Live](https://www.percona.com/live/conferences)
- [Support Portal](https://www.percona.com/services/support/contact)
- Contact

- [Services](https://www.percona.com/services)
- [Support](https://www.percona.com/services/support)
- [Managed Services](https://www.percona.com/services/managed-services)
- [Consulting](https://www.percona.com/services/consulting)
- [Training](https://www.percona.com/training)

- [Software](https://www.percona.com/software)
- [MySQL Software](https://www.percona.com/software/mysql-database)
- [MongoDB Software](https://www.percona.com/software/mongo-database)
- [PostgreSQL Distribution](https://www.percona.com/software/postgresql-distribution)
- [Percona Monitoring & Management](https://www.percona.com/software/database-tools/percona-monitoring-and-management)
- [Open Source Database Tools](https://www.percona.com/software/mysql-tools)

- [Resources](https://www.percona.com/resources)
- [Datasheets](https://www.percona.com/resources/datasheets)
- [Solution Briefs](https://www.percona.com/resources/solution-brief)
- [White Papers](https://www.percona.com/resources/white-papers)
- [Webinars](https://www.percona.com/resources/webinars)
- [Case Studies](https://www.percona.com/about-percona/case-studies)

**[CONTACT US](https://www.percona.com/about-percona/contact)**  
[(888) 316-9775 (USA)](tel:(888)%20316-9775)  
[(208) 473-2904 (USA)](tel:(208)%20473-2904)  
[+44 203 608 6727 (UK)](tel:+44%20203%20608%206727)  
[0-800-051-8984 (UK)](tel:0-800-051-8984)  
[0-800-724-4569 (GER)](tel:0-800-724-4569)

- [Community](https://www.percona.com/community)
- [Forums](https://www.percona.com/forums/)
- [Database Performance Blog](https://www.percona.com/blog/)
- [YouTube](https://www.youtube.com/channel/UCLJ0Ok4HeUBrRYF4irturVA)
- [GitHub](https://github.com/percona)

- [Conferences](https://www.percona.com/live/conferences)
- [Percona Live](https://www.percona.com/live/conferences)
- [Other Events](https://www.percona.com/community/events)

- [About](https://www.percona.com/about-percona)
- [Team](https://www.percona.com/about-percona/team)
- [Careers](https://www.percona.com/about-percona/careers)
- [Contact](https://www.percona.com/about-percona/contact)

[Twitter](https://twitter.com/percona) [Facebook](https://www.facebook.com/Percona?fref=ts) [LinkedIn](https://www.linkedin.com/company/percona) [Launch](https://launchpad.net/percona-project)

![](https://learn.percona.com/hubfs/layout/sm-logo.png)

MySQL and InnoDB are trademarks of Oracle Corp. Proudly running Percona Server. Copyright © 2006-2026 Percona LLC.

[Copyright, Trademark, and Privacy Policy](https://www.percona.com/about-percona/policies)

![](https://px.ads.linkedin.com/collect/?pid=95128&fmt=gif)