MDEV-33502 Slowdown when running nested statement with many partitions

Optimization for tables with a lot of partitions