• There is a DML trigger defined on the table.

    Can you please let me know if this in actually cause delete/insert for updarte? I couldnt see this behaviour.

    GulliMeel

    Finding top n Worst Performing queries[/url]
    Improve the performance of Merge Join(special case)
    How to Post Performance Problem -Gail Shaw[/url]