Re: How to delete many rows quickly?

A keyboard was whacked upside leongjack_at_my-deja.com's head and out came:

>Hi,
> I use oracle 8.0.5 for solaris to process the logs, there are
>several millions of logs per day, I can load the logs into database
>quickly( with the sql loader ), but when I want to delete the outdate
>logs from the database, I meet trouble. Though I make the rollback
>segment large enough to store the rollback infomation, the speed still
>too slow to bear. How can I remove the rows quickly.

My own personal solution would be to create a set of tables, one for each day of the logs (say your logs were outdated after a week, then you'd have mon_log, tue_log, wed_log,...). The tablespace that contained the old monolithic log could be used. Make sure the logs are written to the appropriate daily log table and, after a week, truncate the table with the outdated logs.

Gary
--
Gary O'Keefe
gary_at_onegoodidea.com

You know the score - my current employer has nothing to do with what I post Received on Mon Aug 30 1999 - 09:22:29 CDT