HCC partition--search for # of rows or % of partition that has been uncompressed
Hello-We have have just implemented HCC, at the partition level on a few tables. Since the users have indicated they only update/insert into the most current partitions and rarely on the older partitions, I'd like to monitor the HCC partitions to see if any data is updated, thus uncompressing those rows.
These updates occur via a batch job and is not a direct path load so I know they won't be compressed. I do not want to look row by row but rather get a percentage or row count that was uncompressed within each partition. Is there a way or some script to do this?
0