Eshika (1/11/2012)
In Tables 1&3 there are over 2000 records,tables 2 & 4 there are over 20 million records.The trigger should be fired on an update, there are no recursive triggers on the tables. I will post the execution plan soon.
I tried to update after disabling the trigger and it was fast. I suspect the size of the tables involved is causing the issue.
Please let me know your thoughts,Thank you for all your responses.
You have the trigger defined for update, insert, delete. Should it only be for update based on what you just said?
Based on the exec plan, your trigger code can likely be optimized so that it will run faster.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events