About this document

SQL Commands for Subpartition Management by Efraín Repizo Sánchez is a document available to read on EtoBox.

This document contains SQL queries to compress partitions and rebuild indexes for a table (DWF_TRAFD_TA_PREP) and its partitions (like DWF_TRAFD_TA_PREP_PA1610%) in the SIEM_PA_D_FTRAFDTAPRE_RECI tablespace. The queries will: 1) Generate ALTER TABLE statements to move partitions to compress them 2) Rebuild indexes on the partitions and place them in the SIEM_PA_I_FTRAFDTAPRE_RECI tablespace 3) Execute the ALTER statements to compress partitions and rebuild indexes

Author

Efraín Repizo Sánchez

Language

EN