...I will have a log table which, once a day or so, is copied to a file (for movement to a data warehouse), and the log table emptied.
Is there a better way to handle this kind of thing that I'm missing?
Anyone care to comment about whether a table partition might be better here? Could an insert rule on a table partition automatically create the inherited table, if needed, and insert there?
Thanks,
Reece
-- Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0 |
