Core concept
Static: predicate at compile. Dynamic: at runtime (join with dimension). Depends on engine.
Advertisement
How it works
Non-column-derived filters miss pruning. Cast/UDF on partition column defeats.
Advertisement
Trade-offs + gotchas
Every partitioned table query.