Hi Team,
The application team is accessing a foreign table in batches of 200 rows,
but the problem they are facing is that the query is taking different times
for the same set of rows.
The foreign table is only 1 shard with a partition of 21, and the partition
we are using is a hash partition.
What can I do at the database side to debug this or any configuration
parameter related to this wired behavior?
Have a Good day !!!
Regards
Rohit Sachdeva