MySQL 8 Administrator???s Guide

Optimizing SQL statements

SQL statements are used to perform the core logic of any database application. It does not matter whether the statements are issued directly through an interpreter or submitted behind the scenes by an API. This section outlines guidelines to improve the performance of SQL operations that read and write data in the database.

SELECT statements perform all of the lookup operations in the database. Considering the frequency of SELECT statements, it becomes important to tune these statements at the top priority. The tuning techniques must be applied to constructs like CREATE TABLE...AS SELECT, INSERT INTO...SELECT, and WHERE clauses in DELETE statements.

The following are the main considerations for optimizing queries: ...