The EXPLAIN_ARGUMENT table represents the unique characteristics for each
individual operator, if there are any.
Table 87. EXPLAIN_ARGUMENT Table
| Column Name | Data Type | Nullable? | Key? | Description |
|---|---|---|---|---|
| EXPLAIN_REQUESTER | CHAR(8) | No | FK | Authorization ID of initiator of this Explain request. |
| EXPLAIN_TIME | TIMESTAMP | No | FK | Time of initiation for Explain request. |
| SOURCE_NAME | CHAR(8) | No | FK | Name of the package running when the dynamic statement was explained or name of the source file when static SQL was explained. |
| SOURCE_SCHEMA | CHAR(8) | No | FK | Schema, or qualifier, of source of Explain request. |
| EXPLAIN_LEVEL | CHAR(1) | No | FK | Level of Explain information for which this row is relevant. |
| STMTNO | SMALLINT | No | FK | Statement number within package to which this explain information is related. |
| SECTNO | SMALLINT | No | FK | Section number within package to which this explain information is related. |
| OPERATOR_ID | SMALLINT | No | No | Unique ID for this operator within this query. |
| ARGUMENT_TYPE | CHAR(8) | No | No | The type of argument for this operator. |
| ARGUMENT_VALUE | VARCHAR(30) | No | No | The value of the argument for this operator. |
Table 88. ARGUMENT_TYPE and ARGUMENT_VALUE Column Values
| ARGUMENT_TYPE Value | Possible ARGUMENT_VALUE Values | Description |
|---|---|---|
| AGGMODE |
COMPLETE PARTIAL INTERMEDIATE FINAL | Partial aggregation indicators. |
| CSETEMP |
TRUE FALSE | Temporary Table over Common Subexpression Flag. |
| DIRECT |
TRUE | Direct fetch indicator. |
| DUPLWARN |
TRUE FALSE | Duplicates Warning flag. |
| EARLYOUT |
TRUE FALSE | Early out indicator. |
| FETCHMAX |
IGNORE INTEGER | Override value for MAXPAGES argument on FETCH operator. |
| GROUPBYC |
TRUE FALSE | Whether Group By columns were provided. |
| GROUPBYN | Integer | Number of comparison columns. |
| GROUPBYR | Each row of this type will contain:
| Group By requirement. |
| INNERCOL | Each row of this type will contain:
| Inner order columns. |
| ISCANMAX |
IGNORE INTEGER | Override value for MAXPAGES argument on ISCAN operator. |
| JN_INPUT |
INNER OUTER | Indicates if operator is the operator feeding the inner or outer of a join. |
| LISTENER |
TRUE FALSE | Listener Table Queue indicator. |
| MAXPAGES |
ALL NONE INTEGER | Maximum pages expected for Prefetch. |
| NUMROWS |
INTEGER | Number of rows expected to be sorted. |
| ONEFETCH |
TRUE FALSE | One Fetch indicator. |
| OUTERCOL | Each row of this type will contain:
| Outer order columns. |
| OUTERJN |
LEFT RIGHT | Outer join indicator. |
| PARTCOLS | Name of Column | Partitioning columns for operator. |
| PREFETCH |
LIST NONE SEQUENTIAL | Type of Prefetch Eligible. |
| ROWLOCK |
EXCLUSIVE NONE REUSE SHARE SHORT (INSTANT) SHARE UPDATE | Row Lock Intent. |
| ROWWIDTH | INTEGER | Width of row to be sorted. *** |
| SCANDIR |
FORWARD REVERSE | Scan Direction. |
| SHARED | TRUE | Intra-partition parallelism, shared TEMP indicator. |
| SCANGRAN | INTEGER | Intra-partition parallelism, granularity of the intra-partition parallel scan, expressed in SCANUNITs. |
| SCANTYPE | LOCAL PARALLEL | intra-partition parallelism, Index or Table scan. |
| SCANUNIT |
ROW PAGE | Intra-partition parallelism, scan granularity unit. |
| SLOWMAT |
TRUE FALSE | Slow Materialization flag. |
| SORTKEY | Each row of this type will contain:
| Sort key columns. |
| TABLOCK |
EXCLUSIVE INTENT EXCLUSIVE INTENT NONE INTENT SHARE REUSE SHARE SHARE INTENT EXCLUSIVE SUPER EXCLUSIVE UPDATE | Table Lock Intent. |
| TQDEGREE | INTEGER | intra-partition parallelism, number of subagents accessing Table Queue. |
| TQMERGE |
TRUE FALSE | Merging (sorted) Table Queue indicator. |
| TQREAD |
READ AHEAD STEPPING SUBQUERY STEPPING | Table Queue reading property. |
| TQSEND |
BROADCAST DIRECTED SCATTER SUBQUERY DIRECTED | Table Queue send property. |
| TQTYPE | LOCAL | intra-partition parallelism, Table Queue. |
| UNIQUE |
TRUE FALSE | Uniqueness indicator. |
| UNIQKEY | Each row of this type will contain:
| Unique key columns. |