dynamobi/dynamobi — Issue #233: [LDB-88] Optimize non-simple join queries
Author: dynamobi-build
Created: 2011-12-30 02:23:32+00:00
State: open
Labels: LDB, Optimizer

[reporter="zfong", created="Thu, 27 Apr 2006 13:32:26 -0500 (GMT-05:00)"]
Currently, join optimization only optimizes simple queries. I.e., queries without outer joins, subqueries, and/or aggregates/group bys.

To make this work, Broadbase code for calculating stats and costs on relnodes like aggregation and projection need to be ported over as well. The initial implementation focused on porting over only those relnodes that were required for simple joins.