zzwwhh

Could ORCA deal with sub-query coalescing?

4

``` create table t1(k1 int, c1 int); insert into t1 values (1,10),(2,20),(3,30); create table t2(k2 int, c2 int); insert into t2 values (1,10),(2,20),(3,30); ``` ```sql select * from t1 where...

orca: join pruning

4

## Feature Request **Is your feature request related to a problem? Please describe:** The idea of join pruning is to remove joins if they are not needed by the query....

```SQL postgres=# CREATE TABLE t1(a INT, b INT); CREATE TABLE postgres=# CREATE TABLE t2(c INT, d INT);; CREATE TABLE postgres=# SELECT * FROM t1 left JOIN t2 ON t2.c