[wodenokoto]

That is not true

A where clause still searches the entire column, unless it is conditioned on the partition column.

[m0zg]

Not if you filter on clustered columns, like you should if you care about performance.

[wodenokoto]

True, but now we have moved pretty far from just saying "use a where clause".

"Partition your table and create clustered columns and filter on those"