user650888 wrote:A predicate is a condition in a query. Your predicates are the various filters you have in the WHERE clause of your query.
1. What do you mean by "predicate"
2. There are 5 distinct values for PV for 63666500 recordsIt seems odd that you'd be partitioning on a key that has only 5 values...
3. No the values for pv are not evenly distributed, pv has values (0,1,2,3,4), Value 3 is the one that has maximum number of records, followed by 2, 0 and 1 has only one record each, andAnd it seems even odder that you would partition on a key that has only 5 values where the data distribution is highly skewed. If 4 isn't even in the table, then you're down to 4 partitions with data. 2 of your partitions have only 1 row of data so you're now down, effectively to 2 partitions. And if 3 has substantially more rows than 2, what possible benefit would you get from partitioning in the first place?
I do not think 4 will even be there in the table