Please enable JavaScript.
Coggle requires JavaScript to display documents.
Query Optimization - Coggle Diagram
Query Optimization
Query Execution Basics
High performance
Examining Query Execution
Sending instructions
Checking the request cache
Analysis
Execute API calls
Send result
Optimizing Specific Types of Queries
Optimizing COUNT() Queries
Special function
Counting lines
Ignoring columns
Optimizing JOIN Queries
Concatenating tables
Additional overhead costs
Optimizing Subqueries
Connecting where possible
Optimizing GROUP BY and DISTINCT
Same optimization
Temporary table
File system
Optimizing LIMIT and OFFSET
High offset value
Limiting the number of lines
Covering index offset
Optimizing UNION
Removing duplicate lines
Definitions of uniqueness
Placement in a temporary table
Query Optimization Using EXPLAIN
Execution plan displays
Speeding up queries
Returning strings of information
Reading lines
Same indexes
Slow Query Basics
Optimize Data Access
Working with too much data
Parsing a large number of lines
Are You Asking the Database for Data You Don't Need
Getting More Rows Than Needed
Getting all columns from a multi-table join
Is MySQL Examining Too Much Data
Response time
Queue time
Service time