> On May 23, 2023, at 10:30 PM, Phani Prathyush Somayajula <phani.somayajula@xxxxxxxxxxxxxxxxx> wrote: > > Didn't quite get the question, Scott I asked, what's wrong with partitioning by placedon, with a primary key of (betid, placedon). You responded that the client has some queries which group by brandid. How does adding placedon to the primary key interfere with that? At no point have you explained how adding placedon to the primary key is a problem. I expect it is not actually a problem. It seems that you should just do what the error suggested, add placedon to the primary key.