The result identifies that the partitions have been overprovisioned. It would be prudent to repartition from three to two so that your queries can benefit from the performance gained by the clustered columnstore and compressed segments. The equation should also

Continue ReadingTune Shuffle Partitions – Troubleshoot Data Storage Processing-4