Page History
...
Holds information on statements in the Statement Workshop.
| Column Name | Column Description |
|---|---|
SQSC_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQSC_CABINET | Name of the cabinet in which the statement is stored. |
SQSC_FOLDER | Name of the folder within the cabinet. |
SQSC_STATEMENT_ID | Unique identifier (string) assigned to the statement. |
SQSC_WORKSHOP_HV | Unique identifier (number) assigned to statements inserted in the statement workshop workspace. Statements loaded into the PMDB have the value 0. |
PW_SQEO_EXPLN_OPER
Holds information on batch access plans.
| Column Name | Column Description |
|---|---|
SQEO_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQEO_DATABASE_NAME | Name of the database to which the statement belongs. |
SQEO_PARSING_USER | One of the SQL Server users who executed this statement. If this statement is not part of a stored procedure, this is the user used as the parsing user when explaining this batch. |
SQEO_BATCH_HV | Unique identifier (number) assigned to the batch. |
SQEO_WORKSHOP_HV | Unique identifier (number) assigned to statements inserted in the statement workshop workspace. Statements loaded into the PMDB have the value 0. |
SQEO_EXPLAIN_TIME | Date and time the batch was explained and its access plan was changed. |
SQEO_STATEMENT_ID_IN_ |
...
BATCH | A statement number in the first batch sampled running the statement. |
SQEO_OPERATOR_ID | Sequence order of this operation in the access plan for a statement. |
SQEO_OPERATOR_TYPE | Physical operation in the access plan. |
SQEO_OPTIONS | Logical operation in the access plan. |
SQEO_EXECUTION_ORDER | Sequence order of this operation in the whole access plan. |
SQEO_TREE_LEVEL | Tree level of this operation in the access plan. |
SQEO_ARGUMENTS_LIST | Not in use. |
SQEO_REMOTE_STATEMENT_HV | Unique identifier (number) for the remote query used in this operation. |
SQEO_OBJ_DATABASE_NAME | Database name of the object accessed in this operation. |
SQEO_OBJ_OWNER_NAME | Owner of the object accessed in this operation. |
SQEO_OBJ_NAME | Name of the object accessed in this operation. |
SQEO_INDEX_NAME | Name of the index accessed in this operation. Otherwise NULL. |
SQEO_TOTAL_SUBTREE_COST | Estimated cost of this operation and its descendants. |
SQEO_CONTRIBUTION_RATIO | Contribution value of the object in this operation to the statement. |
SQEO_ESTIMATE_COST | Estimated cost of this operation. |
SQEO_ESTIMATE_IO_COST | Estimated I/O cost of this operation. |
SQEO_ESTIMATE_CPU_COST | Estimated CPU cost of this operation. |
SQEO_ESTIMATE_ROWS | Estimated number of rows returned by this operation. |
SQEO_WARNINGS | Warnings in this operation. |
SQEO_PARALLEL_IND | Indicates if the operation is performed in parallel. |
SQEO_ESTIMATE_EXECUTION | Estimated number of times this operation is performed. |
SQEO_LAST_EXPLAIN_IND | Indicates that this operation belongs to the last explain of the batch. |
SQEO_AVG_ROW_SIZE | Average row size this operation handles. |