v.24.7Performance Improvement

Optimized Query Performance with Buffered ORDER BY and High Selectivity Conditions

Optimized queries with ORDER BY primary key and WHERE that have a condition with high selectivity by using buffering. It is controlled by setting read_in_order_use_buffering (enabled by default) and can increase memory usage of query. #64607 (Anton Popov).