Click on the action buttons in the action panel to get the time taken for delete and detach operations

Operation



Get Execution Times of Delete And Detach

The time taken for DELETE operation and DETACH of a range in a range partitioned table is computed.

Graph of Delete vs Detach

  1. A graph comparing the execution times for DELETE vs DETACH operations is generated.
  2. If you hover your cursor over the bars in the graph you will see the exact execution time for each run.


Result


The time taken for DETACH operation is much lesser compared to the DELETE operation. Hence this demonstrates the advantage of range partitioning in that data can be very easily detached from the tables