Hey Folks, Is it currently possible to have Calcite optimize-away unnecessary joins? The case I'm thinking of is where (hopefully the formatting holds up!):
...you have a bushy tree as follows:
---------------------
| |
| |
|--------| |---------|
T1 T2 T2 T3
...which could be rewritten as a left-deep tree to avoid scanning T2 again:
|-------------------|
| |
|----------| |
T1 T2 T3
If so, does any have an example of how to do this please?
Many thanks,
Chris
