Columnar NoPI table- calculate deleted rows partition perm space
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
Re: Columnar NoPI table- calculate deleted rows partition perm space
One way to find out the information about deleted rows is collecting summary stats on the CP table. (DelRowCount * AvgRowSize) shall give pretty good information about the perm space of the deleted rows. "COLLECT SUMMARY STATS" doesn't read the rows, only the table header. So it's fast.
collect summary stats on t100k_cp_b;
*** Update completed. One row changed. *** Total elapsed time was 1 second.
BTEQ -- Enter your SQL request or BTEQ command:
show summary stats values on t100k_cp_b;
*** Text of DDL statement returned. *** Total elapsed time was 1 second.