If you are using Oracle and your database is a VLDB (Very Large Database) then I would suggest using the PARTITION command when creating the tables. Partition on the key date and then you can drop a range of dates with very little impact on the database. Deleting a large number of rows in a large database can kill your server or cluster performance. See partition.htm for more info.

Richard

There are three types of people in this world, those that can count and those that cannot. Anon