20.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 typeFormula (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