> On May 23, 2023, at 2:46 AM, Phani Prathyush Somayajula <phani.somayajula@xxxxxxxxxxxxxxxxx> wrote: > > What's wrong with partitioning by placedon, with a primary key of (betid, placedon)? - this is because the business need to run group by queries based on these brands. For now, there are 4 brands and in future it could go up to 7. How does a primary key of (betid, placedon) instead of betid interfere with that?