Improve RIGHT/FULL JOIN performance by up to 2x in specific scenarios
Official CH changelog text
Improve the performance of RIGHT/FULL JOIN by up to 2 times in certain scenarios, especially when joining a small left table with a large right table. #49585 (lgbo).