In SQL Server 2008, DMV
sys.dm_db_index_physical_stats, what does
compressed_page_count mean in comparison with
page_count. I have a table with the following info:
Object_id Index_type_desc avg_frag_in_percent page_count compressed_page_count avg_page_space_used_in_percent avg_record_size_in_bytes 5464654 CLUSTERED INDEX 0 140992 1410 99.24 111.2 4465464 NONCLUSTERED INDEX 0 52532 526 99.69 32.2
Does it mean, that the table has 140992 pages, but after compression it is brought down to 1410 pages or something else?
[BOL says:]MSDN compressed_page_count: The number of compressed pages.