Nonstop Database, HiRDB Version 9 Installation and Design Guide
![[Contents]](FIGURE/CONTENT.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
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 x a + 567 x b + 162 + 324 x b x g |
| Output results file |
- Collecting optimizing information by retrieval (-c lvl1 specified):
202 + 131 x e
- Collecting optimizing information by retrieval (-c lvl2 specified):
370 + 561 x d + 196 x d
- Registering optimizing information using the parameter file that contains optimized information:
370 + 235 x c + 387 x f + 196 x g |
- a: Number of specified indexes
- b: Number of specified columns
- c: Number of indexes defined in table
- d: Number of intervals (total of number of sectors for all indexes)
- e: Number of tables
- f: Number of columns in table
- g: Number of sectors (total of number of sectors specified in all column definitions)
All Rights Reserved. Copyright (C) 2012, Hitachi, Ltd.