Tencent Cloud Developer
Nov 18, 2022 · Databases
How CDW PG Optimizer Finds Optimal Join Order for Multi-Table Queries
CDW PG’s optimizer determines the most efficient join order for multi‑table OLAP queries by combining bottom‑up dynamic programming for smaller joins with a genetic algorithm for larger ones, while jointly selecting scan paths, join algorithms, and data‑distribution strategies to minimize execution cost.
CDW PGDistributed DatabaseJoin Optimization
0 likes · 9 min read