Improve subquery planning #14600

Job	Run time
python lint check	37s
rustfmt check	9s
clang format	48s
sanity checks	12s
rust build & test	23m 45s
clang tidy & clangd diagnostics check	14m 49s
shell test	13m 34s
generate binary dataset	1m 14s
clang build & test	9m 35s
code coverage	32m 18s
gcc build & test	11m 27s
apple clang build & test	12m 34s
msvc build & test	15m 23s
webassembly build & test	28m 27s
clang build & test with page_size_log2=16	6m 33s
clang build & test with page_size_log2=18	6m 56s
linux extension test	17m 6s
gcc build & test with asan	27m 14s
gcc build & test in-mem only with various vector size	4m 20s
benchmark / benchmark	15m 18s
macos extension test	1m 51s
windows extension test	0s
report benchmark result	7s
	4h 4m 17s

Provide feedback