Optimizer clauses are not legal in trigger statements Explanation: You have specified one of the optimizer clauses in a data manipulation statement within a trigger. The optimizer clause is not supported in triggers, and is ignored. User Action: You can remove the clause or choose to ignore this message.