Please enable JavaScript.
Coggle requires JavaScript to display documents.
Query optimization - Coggle Diagram
Query optimization
EXPLAIN Output Columns
-
select_type
The type of SELECT, which can be any of those shown in the table from the next slide
-
-
-
-
-
-
ref
which columns or constants are compared to the index named in the key column to select rows from the table.
-
-
-
-
Query cost
Response Time
-
Queue Time - is the portion of
response time during which the server isn’t really executing the query
-
-
-