For example, to change the mode of the unique index unq_ssn on
the cust_subset table to filtering, enter the following statement:
SET INDEXES unq_ssn FILTERING;
You can also use the object-list format to change the
mode for a list of constraints, indexes, or triggers that are defined
on the same table. Assume that four triggers are defined on the cust_subset table: insert_trig, update_trig, delete_trig,
and execute_trig. Also assume that all four triggers are enabled.
To disable all triggers except execute_trig, enter this statement:
SET TRIGGERS insert_trig, update_trig, delete_trig DISABLED;
If my_trig is a disabled INSTEAD OF trigger on
a view, the following statement enables that trigger:
SET TRIGGERS my_trig ENABLED;
In
cluster environments, the SET TRIGGERS statement is not supported
on updatable secondary servers. More generally, session-level index,
trigger, and constraint modes that the SET Database Object Mode statement
specifies are not redirected for UPDATE operations on table objects
in databases of secondary servers.
Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.