Problem Statement


In a Data Warehouse environment, very old data needs to be eliminated periodically for storage purposes. The key challenges in such a scenario include :

  1. Huge volumes of scattered data
  2. Time consuming operation affecting other operations in the system

Solution : Detach Partition



What is Detach ?

Detach, in case of Range Partitioned tables enables a specific range of data to be quickly and easily detached.

Operation


This tutorial demonstrates benefits of detach over delete operation thus highlighting the advantages of range partitioning in providing an easy way to detach a data partition. A graph comparing the time taken for delete vs detach is generated.

Benefits of Detach vs Delete


  1. Reduced time taken for detach as compared to delete owing to data clustered in a specific range
  2. Lesser I/O overhead in case of delete