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.