17.1.1 Function

HiRDB optimizes each SQL statement entered by the user in order to determine the optimum database access method (access path). The access path display utility (pdvwopt) displays the access path information obtained by this SQL optimization processing; the displayed information can be used for tuning purposes.

The figure below provides an overview of the access path display utility (pdvwopt).

Figure 17-1 Overview of the access path display utility (pdvwopt)

[Figure]