Writing Queries – Partition Pruning¶
Let us understand how to write queries by leveraging partitioing.
Make sure to include a condition on partitioned column.
Equal condition will yield better results.
Queries with condition on partition key will result in partition pruning. The data from the other partitions will be fully ignored.
As partition pruning will result in lesser I/O, the overall performance of such queries will improve drastically.