Simon Riggs wrote:
>
> My thinking was if you load a 1000 rows and they all have the same key
> in your summary table then you'll be doing 1000 updates on a single row.
>
This is true because the statement level triggers are still rudimentary,
with no OLD and NEW support. A single AFTER statement trigger execution
could maintain the summary table with much less effort.
Regards,
Andreas