Hi Abhishek,

I am assuming the mail target of this partition is to fetch the query fast.

So use those values which are frequently used in your Where clause.

You can use Date column or Year column also for this.