Partition Pruning

Problem

When querying a partitioned table with WHERE date = '2022-01-01', the database optimizer ignores all other table partitions on disk. Write a query that outputs benefit with the value: "Partition pruning allows the query engine to scan only the physical directories matching the partition key, eliminating unnecessary disk reads."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution