5.4 How to evaluate the search conditions when indexes are used

There are two ways to evaluate the search conditions when indexes are used:

• Evaluation method when B-tree indexes are used

• Evaluation method when range indexes are used

This section explains how to evaluate the search condition specified in the WHERE clause, the WHERE search condition of the update SQL statement, or the ON search condition when indexes are used.

Organization of this section

• 5.4.1 Evaluation method when B-tree indexes are used

• 5.4.2 Evaluation method when range indexes are used

To Page Top