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 conditions specified in the WHERE clause or the ON 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