Improve subquery planning #14563

Job	Run time
rustfmt check	15s
python lint check	30s
sanity checks	10s
clang format	47s
clang tidy & clangd diagnostics check	4m 45s
shell test	13m 37s
rust build & test	14m 15s
generate binary dataset	1m 19s
code coverage	25m 47s
gcc build & test	4m 25s
msvc build & test	15m 30s
webassembly build & test	9m 17s
clang build & test	7m 19s
apple clang build & test	3m 44s
macos extension test	0s
gcc build & test in-mem only with various vector size	0s
gcc build & test with asan	0s
benchmark	0s
linux extension test	0s
clang build & test with page_size_log2=${{ matrix.page_size_log2 }}	0s
report benchmark result	0s
windows extension test	0s
	1h 41m 40s

Provide feedback