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