(mysql.info.gz) Range optimization
Info Catalog
(mysql.info.gz) Where optimizations
(mysql.info.gz) Query Speed
(mysql.info.gz) Index Merge optimization
7.2.5 Range Optimization
------------------------
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.
Menu
* Range access single-part Range Access Method for Single-Part Indexes
* Range access multi-part Range Access Method for Multiple-Part Indexes
Info Catalog
(mysql.info.gz) Where optimizations
(mysql.info.gz) Query Speed
(mysql.info.gz) Index Merge optimization
automatically generated byinfo2html