As applications mature there is often a need to archive old data. This could be to reduce storage costs, improve query performance or meet regulatory requirements.
But adding archival routines is a daunting task. The processes to remove old data can be complex to write and take a long time to run. So often this work is deferred, leading to colossal tables that are increasingly hard to manage.
Join this session to learn strategies to quickly and easily wipe the oldest rows in tables.
Highlights include:
01:30 - What is archiving?
05:25 - Why archive?
14:50 - Using DDL to make DELETE faster
15:50 - "Delete" methods performance comparison
19:20 - How to add partitioning to a table
24:40 - Using partition exchange to move data to archive tables
34:50 - Handling child rows when archiving data
38:00 - Reference partitioning
42:20 - What is In-Database Archiving
47:40 - Demo of adding partitioning to tables and using partition exchange to archive data
Further reading:
Get the scripts for this session - livesql.oracle.com/apex/lives...
How to Delete Millions of Rows Fast with SQL - blogs.oracle.com/sql/post/how...
29 июл 2024