5 ms·
That is not true A where clause still searches the entire column, unless it is conditioned on the partition column.
by wodenokoto 8y ago
That is not true
A where clause still searches the entire column, unless it is conditioned on the partition column.
- m0zg 8y agoNot if you filter on clustered columns, like you should if you care about performance.
- wodenokoto 8y agoTrue, 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"