I have Oracle 10g Standard edition and a table that should accomodate 3 mil records per month. Because partitioning option is not supported in Oracle Standard, the table is not partitioned. I need to do maintenance on this table. Every time I delete(not truncate) a month's worth of data, the insert becomes very slow(. I'm in the testing phase, so I truncate the table with drop storage option and everything works fine afterwards. I'm just worried that as soon as the database will be in production, I won't have the option of truncating. How can I tune the table maintenance in order to have fast inserts?
Thank you