(mysql.info) range-optimization

Info Catalog

(mysql.info) where-optimizations

(mysql.info) query-speed

(mysql.info) index-merge-optimization

 
 7.2.5 Range Optimization
 ------------------------
 

Menu

 
* range-access-single-part     The Range Access Method for Single-Part Indexes
* range-access-multi-part      The Range Access Method for Multiple-Part Indexes
 
 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.
 

Info Catalog

(mysql.info) where-optimizations

(mysql.info) query-speed

(mysql.info) index-merge-optimization