Nonstop Database, HiRDB Version 9 Installation and Design Guide

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

19.1.8 File sizes required for the execution of the access path display utility (pdvwopt)

The following table shows the formulas for determining the file sizes required for the execution of the access path display utility (pdvwopt):

File type Formula (bytes)
Access path information file [Figure]

a: Number of retrieval SQLs

bi: Number of queries in SQL

cij: Number of tables in query

dij: Number of join processes in query

eijk: Number of table storage RDAREAs

fijk: Number of table index definitions