:: DEVELOPER ZONE
MySQL Reference Manual :: 7.2.5 Range Optimization
Search the MySQL manual:
- 7.2 Optimizing SELECT Statements and Other Queries
- 7.2.1 EXPLAIN Syntax (Get Information About a SELECT)
- 7.2.2 Estimating Query Performance
- 7.2.3 Speed of SELECT Queries
- 7.2.4 How MySQL Optimizes WHERE Clauses
- 7.2.5 Range Optimization
- 7.2.6 Index Merge Optimization
- 7.2.7 How MySQL Optimizes IS NULL
- 7.2.8 How MySQL Optimizes DISTINCT
- 7.2.9 How MySQL Optimizes LEFT JOIN and RIGHT JOIN
- 7.2.10 How MySQL Optimizes ORDER BY
- 7.2.11 How MySQL Optimizes GROUP BY
- 7.2.12 How MySQL Optimizes LIMIT
- 7.2.13 How to Avoid Table Scans
- 7.2.14 Speed of INSERT Statements
- 7.2.15 Speed of UPDATE Statements
- 7.2.16 Speed of DELETE Statements
- 7.2.17 Other Optimization Tips
Additional languages
Additional formats
The range access method uses a single index to retrieve a subset
of table records that are contained within one or several index value
intervals. It can be used for a single-part or multiple-part index.
A detailed description of how intervals are extracted from the
WHERE clause is given in the following sections.
© 1995-2005 MySQL AB. All rights reserved.
User Comments
Add your own comment.