SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
E-17
Considerations—EXPLAIN
Column processing Indicates the number of columns to be retrieved and the total number
of columns in the tables or views from which they are retrieved.
DP2 aggr. Indicates that aggregate functions are evaluated by DP2.
End key pred. Specifies the predicates used to position to the last row to scan,
including collations explicitly used in the predicates.
Executor aggr. Indicates that aggregate functions are evaluated by the executor and
shows whether they are derived from the first row returned by the
scan or computed for each group.
Executor pred. Shows predicates evaluated by the executor and describes when
they are evaluated:

On rows retrieved by the scan

On rows after sorting

On null augmented rows

From the HAVING clause
Expected rowcount For an operation other than a sort, shows the number of rows the
optimizer expects to be returned. For a join query, the rowcount is
cumulative for each join operation.
Appears for sort operations only if the purpose of the sort is to group
rows for a GROUP BY clause. In this case, shows the number of
rows expected after the GROUP BY operation finishes.
Hash cost Indicates the relative cost of the hash operation. Lower numbers
indicate more efficient and less costly execution.
Hash key columns Lists hash key columns ordered by selectivity, with the most selective
column first.
Hash rows in the Specifies whether the rows hashed are from the scan from the
previous operation (current table) or from a composite table.
Index pred. Shows the predicates evaluated on the index and indicates whether
evaluation is performed by the file system or the disk process.
Index selectivity Shows the percentage of the index that is scanned for the operation.
Join strategy Shows the type of join used: nested, (sort) merge, key-sequenced
merge, hash, or hybrid hash. For parallel or repartitioned hash joins,
additional lines list the partitions accessed by the ESPs and the
processors for the ESPs.
Lock mode Indicates whether locks are exclusive, shared, or the default. With
the default in effect, the system determines the actual lock mode
used.
MDAM predicate set Indicates the predicate set used for the first step in the query.
next set Indicates the predicate set used for a subsequent step in the query.
Operation n Indicates the type of operation and the order of the operation in the
overall plan.
Table E-1. EXPLAIN Plan Header Lines (page2of5)
Item Action