Qingqing Zhou

projection/filter push down is not cost based

1

Consider this query: select a, super_expensive_fn(b) from A group by a Currently we just push super_expensive_fn() down to table scan of A, which is silly for this case. So projection...

// TBD: DeParameter() can remove some references of colRefedBySubq_ and it is best // to find out if *all* references are removed, then we can safely remove this column //...

FromSubQuery is different from other subquery types because it is connected in the main planning tree with LogicFromQuery node - this means main tree's optimization can cover it. We have...