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.
To optimize the system based on cost and to improve the precision of optimization, you must execute the optimizing information collection utility as needed before you compile a UAP or execute dynamic SQL statements.
You should collect optimization information by search after performing the following operations:
Figure 16-1 provides an overview of the optimizing information collection utility (pdgetcst).
Figure 16-1 Overview of the optimizing information collection utility (pdgetcst)