We currently use triggers with static if..then..else statements to determine
which partition the data goes into. Would there be a performance impact if
we were to use dynamic sql to achieve the same ?. The issue with static
triggers is the maintenance overhead of having to redefine the triggers
periodically. The dynamic sql is simple and involves building a sql string
with just a to_char(date_Field) to determine which partition the data goes
into and the trigger will never have to be re-defined.
Thank you
Sriram