EXPLAIN_OPERATOR table
The EXPLAIN_OPERATOR table contains all the operators needed to satisfy the query statement by the query compiler.
Column Name | Data Type | Nullable? | Key? | Description |
---|---|---|---|---|
EXPLAIN_REQUESTER | VARCHAR(128) | No | PK | Authorization ID of initiator of this Explain request. |
EXPLAIN_TIME | TIMESTAMP | No | PK | Time of initiation for Explain request. |
SOURCE_NAME | VARCHAR(128) | No | PK | Name of the package running when the dynamic statement was explained or name of the source file when the static SQL was explained. |
SOURCE_SCHEMA | VARCHAR(128) | No | PK | Schema, or qualifier, of source of Explain request. |
SOURCE_VERSION | VARCHAR(64) | No | PK | Version of the source of the Explain request. |
EXPLAIN_LEVEL | CHAR(1) | No | PK | Level of Explain information for which this row is relevant. |
STMTNO | INTEGER | No | PK | Statement number within package to which this explain information is related. |
SECTNO | INTEGER | No | PK | Section number within package to which this explain information is related. |
OPERATOR_ID | INTEGER | No | PK | Unique ID for this operator within this query. |
OPERATOR_TYPE | CHAR(6) | No | No | Descriptive label for the type of operator. |
TOTAL_COST | DOUBLE | No | No | Estimated cumulative total cost (in timerons) of executing the chosen access plan up to and including this operator. |
IO_COST | DOUBLE | No | No | Estimated cumulative I/O cost (in data page I/Os) of executing the chosen access plan up to and including this operator. |
CPU_COST | DOUBLE | No | No | Estimated cumulative CPU cost (in instructions) of executing the chosen access plan up to and including this operator. |
FIRST_ROW_COST | DOUBLE | No | No | Estimated cumulative cost (in timerons) of fetching the first row for the access plan up to and including this operator. This value includes any initial overhead required. |
RE_TOTAL_COST | DOUBLE | No | No | Estimated cumulative cost (in timerons) of fetching the next row for the chosen access plan up to and including this operator. |
RE_IO_COST | DOUBLE | No | No | Estimated cumulative I/O cost (in data page I/Os) of fetching the next row for the chosen access plan up to and including this operator. |
RE_CPU_COST | DOUBLE | No | No | Estimated cumulative CPU cost (in instructions) of fetching the next row for the chosen access plan up to and including this operator. |
COMM_COST | DOUBLE | No | No | Estimated cumulative communication cost (in TCP/IP frames) of network traffic flowing across a single network adapter when executing the chosen access plan up to and including this operator. (See notes 1 and 2.) |
FIRST_COMM_COST | DOUBLE | No | No | Estimated cumulative communications cost (in TCP/IP frames) of network traffic flowing across a single network adapter when fetching the first row for the chosen access plan up to and including this operator. This value includes any initial overhead required. (See notes 1 and 2.) |
BUFFERS | DOUBLE | No | No | Estimated buffer requirements for this operator and its inputs. |
REMOTE_TOTAL_COST | DOUBLE | No | No | Estimated cumulative total cost (in timerons) of performing operation(s) on remote database(s). |
REMOTE_COMM_COST | DOUBLE | No | No | Estimated cumulative communication cost of executing the chosen remote access plan up to and including this operator. |
Note:
- If there is more than one network adapter involved, the cumulative communication cost for the adapter with the highest value is returned.
- This value only includes the costs of network traffic between physical machines. It does not include the virtual communication costs between node partitions on the same physical machine in a partitioned database environment.
Value | Description |
---|---|
CMPEXP | Represent the projection of columns and expression from a subselect in the optimized version of an SQL statement |
DELETE | Delete |
EISCAN | Extended Index Scan |
FETCH | Fetch |
FILTER | Filter rows |
GENROW | Generate Row |
GRPBY | Group By |
HSJOIN | Hash Join |
INSERT | Insert |
IXAND | Dynamic Bitmap Index ANDing |
IXSCAN | Relational index scan |
MSJOIN | Merge Scan Join |
NLJOIN | Nested loop Join |
REBAL | Rebalance rows between SMP subagents |
RETURN | Result |
RIDSCN | Row Identifier (RID) Scan |
RPD | Remote PushDown |
SHIP | Ship query to remote system |
SORT | Sort |
TBFUNC | In-stream table function operator |
TBSCAN | Table Scan |
TEMP | Temporary Table Construction |
TQ | Table Queue |
UNION | Union |
UNIQUE | Duplicate Elimination |
UPDATE | Update |
XISCAN | Index scan over XML data |
XSCAN | XML document navigation scan |
XANDOR | Index ANDing and ORing over XML data |
ZZJOIN | Zigzag join |