Increasing the number of partitions from 25 to 760 has a modest effect on performance for this workload. The greatest gain is for queries that analyze a small number of days of transactions.
Increasing the number of partitions from 25 to 760 has a modest effect on performance for this workload. The greatest gain is for queries that analyze a small number of days of transactions.