fix/optimizer: enable multi-index OR scans more widely and fix bad CTE query plans #13598

Job	Run time
tpc-h-criterion	22m 23s
tpc-h	20m 20s
clickbench	9m 0s
vfs-bench-compile	14m 15s
bench (write_perf_benchmark, --features bench)	10m 57s
bench (json_benchmark, --features bench)	11m 11s
bench (fts_benchmark, --features bench)	6m 27s
bench (parser_benchmark)	2m 38s
bench (benchmark, --features bench)	13m 6s
bench (sql_functions, --features bench)	3m 9s
bench (mvcc_benchmark, --features bench)	4m 43s
bench (hash_spill_benchmark, --features bench)	7m 46s
bench-report	4m 9s
	2h 10m 4s

Provide feedback