SQL optimization option facility | Identifier | Unsigned integer | S | P |
---|
Forced nest-loop-join | "FORCE_NEST_JOIN" | 4 | Y | Y |
Making multiple SQL objects | "SELECT_APSL" | 10 | Y | Y |
Increasing the target floatable servers (back-end servers for fetching data) | "FLTS_INC_DATA_BES" | 16 | N | Y |
Prioritized nest-loop-join | "PRIOR_NEST_JOIN" | 32 | Y | Y |
Increasing the number of floatable server candidates | "FLTS_MAX_NUMBER" | 64 | N | Y |
Priority of OR multiple index use | "PRIOR_OR_INDEXES" | 128 | Y | Y |
Group processing, ORDER BY processing, and DISTINCT set function processing at the local back-end server | "SORT_DATA_BES" | 256 | N | Y |
Suppressing use of AND multiple indexes | "DETER_AND_INDEXES" | 512 | Y | Y |
Rapid grouping facility | "RAPID_GROUPING" | 1024 | Y | Y |
Limiting the target floatable servers (back-end servers for fetching data) | "FLTS_ONLY_DATA_BES" | 2048 | N | Y |
Separating data collecting servers | "FLTS_SEPARATE_COLLECT_SVR" | 2064 | N | Y |
Suppressing index use (forced table scan) | "FORCE_TABLE_SCAN" | 4096 | Y | Y |
Forcing use of multiple indexes | "FORCE_PLURAL_INDEXES" | 32768 | Y | Y |
Suppressing creation of update-SQL work tables | "DETER_WORK_TABLE_FOR_UPDATE" | 131072 | Y | Y |
Deriving search acceleration condition | "DERIVATIVE_COND" | 262144 | Y | Y |
Applying key condition that includes scalar operation | "APPLY_ENHANCED_KEY_COND" | 524288 | Y | Y |
Facility for batch acquisition from functions provided by plug-ins | "PICKUP_MULTIPLE_ROWS_PLUGIN" | 1048576 | Y | Y |