(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