Please enable JavaScript.
Coggle requires JavaScript to display documents.
Query Optimization - Coggle Diagram
Query Optimization
Optimizing Specific Types of Queries
COUNT() Queries
JOIN Queries
Subqueries
GROUP BY and DISTINCT
LIMIT and OFFSET
UNION
Query Execution Steps
Sending sms to the server
Checks the query cache
Parsing, preprocessing, optimizing
Executing the plan
Sending the result to the client
Mistakes
Fetching more rows than needed.
Fetching all columns from a multitable join
Fetching all columns
Fetching the same data repeatedly
Query cost metrics
Response time
Service time
Queue time
Number of rows examined
Numbers of rows returned