Writing Queries – Partition Pruning

Let us understand how to write queries by leveraging partitioning.

  • 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.