Spec-Zone .ru
спецификации, руководства, описания, API

8.13.1. Range Optimization

8.13.1.1. The Range Access Method for Single-Part Indexes
8.13.1.2. The Range Access Method for Multiple-Part Indexes
8.13.1.3. Equality Range Optimization of Many-Valued Comparisons

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.