Use the Ordered Notification only if you need to preserve the order in which the operations occur; otherwise, use Insert Notifications, Update Notifications, and Delete Notifications because they have better performance.

Ordered Notifications ensure that the operations process in the correct order when they occur sequentially in one transaction; however, order preservation is not guaranteed if the operations occur in concurrent transactions. For example, see the following diagrams. Examples A and B will process operations in the correct order. Example C is not guaranteed to process operations in the correct order.