title: Clustered Columnstore Index Fragmentation - Index Properties and dm_db_column_store_row_group_physical_stats differences
body: <p>We are using Clustered Column store Indexes in multiple tables. To determine Fragmentation,</p>
  
  <ol>
  <li>When I use sys.dm_db_column_store_row_group_physical_stats I see 0% fragmentation, </li>
  <li>When I query sys.dm_db_index_physical_stats I see 90.10% fragmentation also Index properties show Page fullness as 62.5% and Total fragmentation as 90.10%.</li>
  </ol>
  
  <p><a href="https://i.stack.imgur.com/k4Ec2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/k4Ec2.png" alt="Column Store Index Properties"></a></p>
  
  <p>Which fragmentation should be taken as actual fragmentation for my table.
  And can I remove the fragmentation by rebuild index or rebuild of partitions for column store will work. </p>
  
  <p>Pls suggest.</p>