On Wed, 2025-11-26 at 21:59 +0530, atma ram wrote: > The table size is 1.6TB and not GB. My bad. > > The queries using primary key or partition key will be definitely improved.
That's not what I would expect, but if you tested it, ok. > My question is 20 queries that do not use partition key and use only index. > Since this is a critical OLTP system, even if there is a slight chance that > those 20 queries will degrade performance, then we may not go with partition > and find any alternative ways. Hence the question. I am pretty sure that the performance will be (at least slightly) worse. Yours, Laurenz Albe
