A tabela SYSQUERYOPTS contém parâmetros de otimização para as consultas que estão na tabela SYSQUERY.
O esquema é SYSIBM.
The SYSQUERYOPTS table contains optimization parameters for the queries that are in the SYSQUERY table.
The schema is SYSIBM.
| Column name |
Data type |
Description |
Use |
| QUERYID |
BIGINT
NOT NULL
ON DELETE
CASCADE |
Unique identifier for the query. This column corresponds to the QUERYID column in the SYSIBM.SYSQUERY table. |
G |
| COPYID |
SMALLINT
NOT NULL |
The version of the plan hints for the query in this row.
- 0
- Current version of the plan hints.
- 1
- Previous version of the plan hints used by PLAN STABILITY
- 2
- Original version of the plan hints used by PLAN STABILITY
|
G |
| REOPT |
CHAR(1)
NOT NULL |
The value of the REOPT bind option that is in effect for the plan:
- 1
- REOPT(ONCE)
- A
- REOPT(AUTO)
- N
- REOPT(NONE)
- Y
- REOPT(ALWAYS)
- blank
- REOPT is not specified
|
G |
| STARJOIN |
CHAR(1)
NOT NULL |
Whether star join is enabled:
- Y
- Star join is enabled
- N
- Star join is disabled
- blank
- Star join is not specified
|
G |
| MAX_PAR_DEGREE |
INTEGER
NOT NULL |
The maximum parallel degree.
This column will contain a value between 0 and 254.
If the value of the column is -1, the maximum parallel degree is not specified. |
G |
| DEF_CURR_DEGREE |
CHAR(3)
NOT NULL |
Whether query parallelism is enabled:
- ONE
- Query parallelism is disabled
- ANY
- Query parallelism is enabled
- blank
- Query parallelism is disabled
|
G |
| SJTABLES |
INTEGER
NOT NULL |
The number of tables specified in a query to qualify for star join processing.
If this column contains -1, star join processing is not specified. |
G |
| — |
VARCHAR(128)
NOT NULL |
Internal use only. |
I |
| GROUP_MEMBER |
VARCHAR(24)
NOT NULL |
The group member name to which the parameters are to be applied.
This column contains blank if the group member name is not specified. |
G |
| IBMREQD |
CHAR(1)
NOT NULL |
A value of Y indicates that the row came from the basic machine-readable material (MRM) tape.
For all other values, see Release dependency indicators.
The value in this field is not a reliable indicator of release dependencies. |
G |
