How to archive old data скачать в хорошем качестве

How to archive old data

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 - https://livesql.oracle.com/apex/lives... How to Delete Millions of Rows Fast with SQL - https://blogs.oracle.com/sql/post/how...