Hi Tom,
We have a transaction table storing millions of records. We are planning to create a after-insert trigger on this table which would make an insert to another table for every transaction.
The new table will hold a flag value mentioning if the transaction is in scope for checker process. The reason why we are not adding a new column in the existing table is because it is vendor table and it replicated to our system, so we keep it is its as-is state.
Would there be performance issues since the table is very huge?