Please enable JavaScript.
Coggle requires JavaScript to display documents.
Query Optimization (Query Optimization Using EXPLAIN (The EXPLAIN…
Query Optimization
-
-
Slow Query Basics
Queries are tasks, but they are composed of subtasks, and those subtasks consume time
To optimize a query, you must optimize its subtasks by eliminating them, making them happen fewer times, or making them happen more quickly
Optimize Data Access
- Find out whether your application is retrieving more data than you need. That usually means it’s accessing too many rows, but it might also be accessing too many columns.
- Find out whether the MySQL server is analyzing more rows than it needs.
-
-
-