20.2.12 Memory size required for the execution of the access path display utility (pdvwopt)

The following table shows the formulas for determining the memory size required for the execution of the access path display utility (pdvwopt).

ConditionFormula for determining
memory size (KB)
HiRDB/Single Servera
[Figure] bi[Figure] 0.7 + 200
i = 1
HiRDB/Parallel ServerFES
a: Number of queries in SQL
bi: Number of tables in query