The ADVISE_WORKLOAD table represents the statement that makes up the workload. For more details on workload refer to Administration Guide: Performance.
For the definition of this table, see ADVISE_WORKLOAD Table Definition.
Table 141. ADVISE_WORKLOAD Table
| Column Name | Data Type | Nullable? | Key? | Description |
|---|---|---|---|---|
| WORKLOAD_NAME | CHAR(128) | No | No | Name of the collection of SQL statements (workload) that this statments belongs to. |
| STATEMENT_NO | INTEGER | No | No | Statement number within the workload to which this explain information is related. |
| STATEMENT_TEXT | CLOB(1M) | No | No | Content of the SQL statement. |
| STATEMENT_TAG | VARCHAR(256) | No | No | Identifier tag for each explained SQL statement. |
| FREQUENCY | INTEGER | No | No | The number of times this statement appears within the workload. |
| IMPORTANCE | DOUBLE | No | No | Importance of the statement. |
| COST_BEFORE | DOUBLE | Yes | No | The cost (in timerons) of the query if the recommended indexes are not created. |
| COST_AFTER | DOUBLE | Yes | No | The cost (in timerons) of the query if the recommended indexes are created. |