Oleg Bartunov wrote:
> I just noticed a little optimizer problem - in second query there is
> unused 'tycho t2' table alias which gets backend buried.
It's not an "unused table alias", it is specifying the cartesian product
of `tycho' with itself. I don't see how this is an optimizer problem:
it's a perfectly legitimate query, albeit one that is unlikely to
execute very quickly.
-Neil