ADVISE_WORKLOAD table
The ADVISE_WORKLOAD table represents the statement that makes up the workload.
| Column Name | Data Type | Nullable? | Key? | Description |
|---|---|---|---|---|
| WORKLOAD_NAME | CHAR(128) | No | No | Name of the collection of SQL statements (workload) to which this statement belongs. |
| 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. |
| WEIGHT | DOUBLE | No | No | Priority of the statement. |
| COST_BEFORE | DOUBLE | Yes | No | The cost of the query (in timerons) if the recommendations are not created. |
| COST_AFTER | DOUBLE | Yes | No | The cost of the query (in timerons) if the recommendations are created. COST_AFTER reflects all recommendations except those that pertain to clustered indexes and multidimensional clustering (MDC). |
| COMPILABLE | CHAR(17) | Yes | No | Indicates any query compile errors that occurred while trying to prepare the statement. If this column is NULL or does not start with SQLCA, the SQL query could be compiled by db2advis. If a compile error is found by db2advis or the Design Advisor, the COMPILABLE column value consists of an 8 byte long SQLCA.sqlcaid field, followed by a colon (:) and an 8 byte long SQLCA.sqlstate field, which is the return code for the SQL statement. |