Problems? Is your data what you think it is? | |
PerlMonks |
Re: Database Clean up?by richardX (Pilgrim) |
on Aug 29, 2002 at 23:03 UTC ( [id://193944]=note: print w/replies, xml ) | Need Help?? |
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
In Section
Perl Monks Discussion
|
|