When your desk does not have 6 billion rows, you have two major choices. Possibly lessen the number of partitions or consider using a heap desk as an alternative.Phase quality might be calculated by the number of rows inside a compressed Row Group. Begin to see the Triggers of bad columnstore index excellent in the Desk indexes write-up for action-