16.1.1 Collecting optimization information by retrieval

Determination of the optimum access path based on the database's current status is called cost-based optimization.

This enables HiRDB to use the most efficient access path and enables users to create UAPs without having to take SQL optimization into account. For details about optimization information, see Using optimization information in the HiRDB Version 9 System Operation Guide.

You should execute the optimizing information collection utility only when its execution conditions have been fully satisfied. For details about the execution conditions, see 16.1 Overview.

The figure below provides an overview of the optimizing information collection utility (pdgetcst) (collecting optimization information by retrieval).

Figure 16-1 Overview of the optimizing information collection utility (pdgetcst)

[Figure]