What is column elimination and row group elimination in columnstore indexes?

Column elimination skips unnecessary columns, row group elimination skips irrelevant data blocks.

Columnstore indexes store data in compressed column segments called row groups. SQL Server can skip entire row groups using segment metadata (min/max values). It can also read only required columns, drastically reducing IO for analytics workloads.