Descriptions:
- Documentation: https://dev.mysql.com/doc/refman/8.2/en/introduction.html
1. General information
8. Optimization
- 8.1 Optimization overview
- 8.2 Optimizing SQL statements
- 8.2.1 Optimizing SELECT Statements
- 8.2.2 Optimizing Subqueries, Derived Tables, View References, and Common Table Expressions
- 8.2.3 Optimizing INFORMATION_SCHEMA Queries
- 8.2.4 Optimizing Performance Schema Queries
- 8.2.5 Optimizing Data Change Statements
- 8.2.6 Optimizing Database Privileges
- 8.2.7 Other Optimization Tips
12. Functions and operators
- Operators
- Aggregated functions