The following two statistics are shown:
Stmt Totals —The total number of rows updated in the database as a result of internal activity generated by the SQL statement. This value is a total for all observed executions of the SQL statement.
Per Exec Avg —The number of rows updated in the database as a result of internal activity generated by the SQL statement. This value is the average per observed execution of the statement.
Internal update activity can result from these events:
A SET NULL row update enforcing a referential constraint defined with the ON DELETE SET NULL rule
A trigger being fired.
If this statement causes a large number of internal updates, you might re-evaluate the design of the table referenced in the statement to determine whether the referential constraints defined for the table are necessary.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
