Please enable JavaScript.
Coggle requires JavaScript to display documents.
Query Optimization - Coggle Diagram
Query Optimization
Optimizing Specific Types of Queries
Optimizing JOIN Queries
Optimizing GROUP BY and DISTINCT
Optimizing COUNT() Queries
counts values and rows
counts number of rows
Optimizing Subqueries
Optimizing UNION
Slow Query Basics
subtasks optimize
useless subtasks
quantity of subtasks
a lot of time for subtasks
Data You Don't Need
Fetching more rows
Fetching from a multitable join
Fetching all columns
Fetching repeatedly
Optimize Data Access
sift data
accessing too many rows
server analyze
Examining Too Much Data
number of rows examined
number of rows returned
response time
Queue time
Service time
Query Execution Basics
steps of MySQL working
learning MySQL optimize
Query Optimization Using EXPLAIN
EXPLAIN statement
works with
information for each table
see indexes needed