I am trying to get the space used by a columnstore table using INFORMATION_SCHEMA.COLUMNAR_SEGMENTS table. However I am not sure if the reported usage includes redundancy as well. The query I am using is below,
DATABASE_NAME AS DB,
TABLE_NAME AS TABLE_NAME ,
“” AS TOTAL_MEMORY_MB ,
SUM(UNCOMPRESSED_SIZE)/(10241024) AS DISK_UNCOMP_MB ,
SUM(COMPRESSED_SIZE)/(10241024) AS DISK_COMP_MB
WHERE TABLE_NAME = “table_name”
Could somebody please help me understand the space usage reported by this table? Does it include redundancy as well? If we don’t aggregate, it gives the result for individual partitions. However, I am not sure if it includes the redundant partition as well.