Spec-Zone.ru › MySQL 5.7

8.2 Optimizing SQL Statements

  • 8.2.1 Optimizing SELECT Statements
  • 8.2.2 Optimizing Subqueries, Derived Tables, and View References
  • 8.2.3 Optimizing INFORMATION_SCHEMA Queries
  • 8.2.4 Optimizing Data Change Statements
  • 8.2.5 Optimizing Database Privileges
  • 8.2.6 Other Optimization Tips

The core logic of a database application is performed through SQL statements, whether issued directly through an interpreter or submitted behind the scenes through an API. The tuning guidelines in this section help to speed up all kinds of MySQL applications. The guidelines cover SQL operations that read and write data, the behind-the-scenes overhead for SQL operations in general, and operations used in specific scenarios such as database monitoring.

© 2025 Oracle
Licensed under the GPLv2 License.
https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/statement-optimization.html

Spec-Zone.ru

Настройки Оффлайн Что нового Помощь О нас
Spec-Zone .ru
спецификации, руководства, описания, API