Viewing 3 posts - 1 through 3 (of 3 total)
If you are having performance problems, you should investigate the performance issues.
BBlamingthe triggers may not help at all, you could be wasting your time on it (PM's don't like...
May 24, 2011 at 12:09 am
#1328843
Perhaps you can override the designers intentions, and provide a total payments column, calculated with triggers.
I'd expect a performance improvement if you drop the SUM calculation.
May 23, 2011 at 8:34 am
#1328483
How about a trace? I believe if you trace 'Statement Complete' you eventually may be able to see all trigger activity (by Object name/type).
Tracing to that level however, may cause...
May 23, 2011 at 8:18 am
#1328472