In a Data Warehouse environment, very old data needs to be eliminated periodically for storage purposes. The key challenges in such a scenario include :
Detach, in case of Range Partitioned tables enables a specific range of data to be quickly and easily detached.
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.