Please enable JavaScript.
Coggle requires JavaScript to display documents.
Query Optimization - Coggle Diagram
Query Optimization
Optimizing Specific Types of Queries
Optimizing COUNT() Queries
Optimizing JOIN Queries
Optimizing Subqueries
Optimizing GROUP BY and DISTINCT
Optimizing LIMIT and OFFSET
Optimizing UNION
Slow Query Basics
Optimize Data Access
The most basic reason a query doesn’t perform well is because it’s working with too much data
Response time
Response time is the sum of two things: service time and queue time
Service time
Service time is how long it takes the server to actually process the query
Queue time
Queue time is the portion of response time during which the server isn’t really executing the query
Query Optimization Using EXPLAIN
The EXPLAIN statement is used to obtain a query execution plan
Query Execution Basics