MySQL 5.4 Reference Manual :: 7 Optimization :: 7.2 Optimizing SELECT and Other Statements :: 7.2.5 Range Optimization
Section Navigation [Toggle]
- 7.2 Optimizing SELECT and Other Statements
- 7.2.1 Optimizing Queries with EXPLAIN
- 7.2.2 Estimating Query Performance
- 7.2.3 Speed of SELECT Queries
- 7.2.4 WHERE Clause Optimization
- 7.2.5 Range Optimization
- 7.2.6 Index Merge Optimization
- 7.2.7 Condition Pushdown Optimization
- 7.2.8 Index Condition Pushdown Optimization
- 7.2.9 IS NULL Optimization
- 7.2.10 LEFT JOIN and RIGHT JOIN Optimization
- 7.2.11 Nested-Loop Join Algorithms
- 7.2.12 Nested Join Optimization
- 7.2.13 Outer Join Simplification
- 7.2.14 ORDER BY Optimization
- 7.2.15 GROUP BY Optimization
- 7.2.16 DISTINCT Optimization
- 7.2.17 Optimizing IN/=ANY Subqueries
- 7.2.18 LIMIT Optimization
- 7.2.19 Using optimizer_switch to Control the Optimizer
- 7.2.20 How to Avoid Table Scans
- 7.2.21 INFORMATION_SCHEMA Optimization
- 7.2.22 Speed of INSERT Statements
- 7.2.23 Speed of UPDATE Statements
- 7.2.24 Speed of DELETE Statements
- 7.2.25 Other Optimization Tips
[+/-]
The range access method uses
a single index to retrieve a subset of table rows that are
contained within one or several index value intervals. It can be
used for a single-part or multiple-part index. The following
sections give a detailed description of how intervals are
extracted from the WHERE clause.
User Comments
Add your own comment.