Scalable Database Server, HiRDB Version 8 Installation and Design Guide

[Contents][Index][Back][Next]

20.1.7 File sizes required for the execution of the optimizing information collection utility (pdgetcst)

The following table shows the formulas for determining the file sizes required for the execution of the optimizing information collection utility (pdgetcst):

File type Formula (bytes)
Parameter file that contains optimized information 162 + 405 [Figure] a + 567 [Figure] b
Output results file

Collecting optimizing information by retrieval (-c lvl1 specified):
202 + 131 [Figure] e

Collecting optimizing information by retrieval (-c lvl2 specified):
370 + 561 [Figure] d + 196 [Figure] d

Registering optimizing information using the parameter file that contains optimized information:
370 + 235 [Figure] c + 387 [Figure] f

a: Number of specified indexes

b: Number of specified columns

c: Number of indexes defined in table

d: Number of intervals

e: Number of tables

f: Number of columns in table