Re: Removing INNER JOINs

* Atri Sharma (atri.jiit@gmail.com) wrote:
> Agreed, but in some cases, we could possibly make some assumptions (if
> there is no index, if a large fraction of table will be returned in scan,
> FunctionScan).

All neat ideas but how about we get something which works in the way
being asked for before we start trying to optimize it..?  Maybe I'm
missing something, but getting all of this infrastructure into place and
making sure things aren't done to the plan tree which shouldn't be (or
done to all of them if necessary..) is enough that we should get that
bit done first and then worry if there are ways we can further improve
things..
THanks,
    Stephen