Updating a Column‑Partitioned Table
Consider the following information before updating data in a column‑partitioned table.
a Selects the rows to be updated.
b Transforms columns to rows.
c Deletes the old row without recovering the space and marks its delete bit in the delete column partition.
Note: Both LOB space and index space is recovered.
d Reinserts the updated rows, transforming them from rows to columns and appending the column values to their corresponding combined partitions.
Teradata Database recovers the space from the column‑partitioned table when it deletes all of the rows at the end of a transaction or when it deletes the entire row partition that contains the deleted rows at the end of a transaction.