8.13.1. Range Optimization The Range Access Method for Single-Part Indexes The Range Access Method for Multiple-Part Indexes 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.

Spec-Zone.ru - all specs in one place