Sample Header Ad - 728x90

Testing the estimated query plan of a portion of a trigger that uses inserted/deleted

1 vote
1 answer
309 views
I'm performance tuning a SQL Server trigger that has several statements using the "inserted" and "deleted" tables. How can I break out those individual queries from the trigger for testing in order to see their estimated execution plans? The "inserted" and "deleted" tables have no context outside of a trigger. I want to make sure that it mimics the behavior of the trigger as closely as possible. The trigger I'm testing is INSTEAD OF DELETE. I was hoping not to actually delete the record so that I could easily test the before and after without deleting the row.
Asked by skeletank (301 rep)
Nov 16, 2022, 03:52 PM
Last activity: May 16, 2025, 09:04 AM