Predicate Pushdown and Columnstore Indexes

Predicate pushdown in SQL Server is a query plan optimisation that pushes predicates down the query tree, so that filtering occurs earlier within query execution than implied by the logical query execution ordering.

So with an inner join query for example, a predicate that appears in the WHERE clause and that logically […] “Predicate Pushdown and Columnstore Indexes”