ALTER TRIGGER (Re-create a trigger SQL object)
Function
ALTER TRIGGER re-creates a trigger SQL object.
Privileges
Format
ALTER TRIGGER [authorization-identifier.]trigger-identifier |
Operands
This indicates that a trigger is to be re-created. Either CHANGE or ALTER can be specified without a change in meaning.
In SQL compile-option, ISOLATION, OPTIMIZE LEVEL, ADD OPTIMIZE, and SUBSTR LENGTH can each be specified only once.
OPTIMIZE LEVEL "identifier"[, "identifier"]...
OPTIMIZE LEVEL unsigned-integer[, unsigned-integer]...
Table 3-8 SQL optimization option specification values (ALTER TRIGGER)
No. | Optimization method | Specification value | |
---|---|---|---|
Identifier | Unsigned integer | ||
1 | Forced nest-loop-join | "FORCE_NEST_JOIN" | 4 |
2 | Making multiple SQL objects | "SELECT_APSL" | 10 |
3 | Increasing the target floatable servers (back-end servers for fetching data)#1, #2 | "FLTS_INC_DATA_BES" | 16 |
4 | Prioritized nest-loop-join | "PRIOR_NEST_JOIN" | 32 |
5 | Increasing the number of floatable server candidates#2 | "FLTS_MAX_NUMBER" | 64 |
6 | Priority of OR multiple index use | "PRIOR_OR_INDEXES" | 128 |
7 | Group processing, ORDER BY processing, and DISTINCT set function processing at the local back-end server#2 | "SORT_DATA_BES" | 256 |
8 | Suppressing the use of AND multiple indexes | "DETER_AND_INDEXES" | 512 |
9 | Rapid grouping processing | "RAPID_GROUPING" | 1024 |
10 | Limiting the target floatable servers (back-end servers for fetching data)#1, #2 | "FLTS_ONLY_DATA_BES" | 2048 |
11 | Separating data collecting servers#1, #2 | "FLTS_SEPARATE_COLLECT_SVR" | 2064 |
12 | Suppressing index use (forced table scan) | "FORCE_TABLE_SCAN" | 4096 |
13 | Forcing use of multiple indexes | "FORCE_PLURAL_INDEXES" | 32768 |
14 | Suppressing creation of update-SQL work tables | "DETER_WORK_TABLE_FOR_UPDATE" | 131072 |
15 | Derivation of rapid search conditions | "DERIVATIVE_COND" | 262144 |
16 | Applying key conditions including scalar operations | "APPLY_ENHANCED_KEY_COND" | 524288 |
17 | Facility for batch acquisition from functions provided by plug-ins | "PICKUP_MULTIPLE_ROWS_PLUGIN" | 1048576 |
18 | Facility for moving search conditions into derived table | "MOVE_UP_DERIVED_COND" | 2097152 |
ADD OPTIMIZE LEVEL "identifier"[, "identifier"]...
ADD OPTIMIZE LEVEL unsigned-integer[, unsigned-integer]...
Table 3-9 SQL extension optimizing option specification values (ALTER TRIGGER)
No. | Optimization method | Specification value | |
---|---|---|---|
Identifier | Unsigned integer | ||
1 | Application of optimizing mode 2 based on cost | "COST_BASE_2" | 1 |
2 | Hash join, subquery hash execution | "APPLY_HASH_JOIN" | 2 |
3 | Facility for applying join conditions including value expression | "APPLY_JOIN_COND_FOR_VALUE_EXP" | 32 |
Common rules
Notes
Example
ALTER TRIGGER TRIG1
CHANGE ROUTINE OBJECT