Qingqing Zhou

This is what we have now for join filter. We first merge (l, r) then do the filtering as the filter.Exec() API only takes one row as input. ```c# Row...

The reason we need foreign table scan is to accelerate debug queries against big data set. Currently we have to load the whole data set into memory, collect stats, then...

- MEMO - better visualizer - branch and bound pruning - aggregation/ctes: by generate multiple memo - parallel ~~make it queryable with SQL/DataSet interface~~ - CE - complicated filter selectivity...

## features - window function ```sql -- end query 43 in stream 0 using template query43.tpl -- start query 44 in stream 0 using template query44.tpl select asceding.rnk, i1.i_product_name best_performing,...

accouting subquery's cost into total cost

2

``` PhysicOrder (inccost=24.1, cost=0.1, rows=1) (actual rows=0) Output: supplier.s_name[0],supplier.s_address[1] Order by: supplier.s_name[0] -> PhysicHashJoin (inccost=24, cost=13, rows=1) (actual rows=0) Output: supplier.s_name[1],supplier.s_address[2] Filter: supplier.s_nationkey[3]=nation.n_nationkey[0] -> PhysicScanTable nation (inccost=1, cost=1, rows=1) (actual...

so we don't duplicate code and can leverage hash join for performance when possible

date math not very right

5

I used the c# built in class for it but not in the right way see DateTime class (AddMonths() etc).

[Algebrizer/Rewriter] make OptimizeOption.remove_from_ default to true

1

This flag controls the behavior to remove redundant FROM (select * from (select * from a) b) after we fixed bugs with it, for example (aggregation from aggregation).

see details ef0e02712b2d78a11dac751666249d5412c56d78