The software refreshes data to subscribers. Various sources can generate a change. These changes are identified by a set of id's. These id's are first inserted into t1, queried against and then deleted again. My example is quite simple but in practice t2 is a view touching several tables.

There is a huge amount of transactions. Re-compile times would become a problem when t1 has a normal statistic that can be automatically updated.