The Query Optimizer
Optimizing MySQL and PHP
2024-11-26
23
How MySQL thinks:
•
Eliminate rows
•
Use indexes
•
Avoid table scans
•
Consider different join orders
•
Avoid hitting the disk
•
Avoid using the data if the index knows enough
