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
Query execution types
Sending statement to the server
Checking by server
Parsing, preprocessing, optimizing data by server
Sending the result by server
Reason query needs more performace efficency (mistakes)
Fetching more rows than needed.
Fetching all columns from a multitable join
Fetching all columns(is about those that are not used)
Fetching the same data repeatedly(rather than caching data by server)
Query performance cost
Response time
Service time
Queue time
Number of rows affected
Number of rows returned