Subject Re: [firebird-support] LEFT JOIN and NULLs (performance problems) (reposted)
Author Dmitry Yemanov
"tdtappe" <tappe@...> wrote:
>
> Sorry for reposting this.

Sorry for ignoring your previous post :-)

> But isn't there anybody who can tell something about it?
> For instance confirm it!?

Confirmed. AFAIK, this is no longer a problem in FB2 (as an equality
operator doesn't scan for null keys there), but no scan at all is always
better than even a trivial (almost no-op) scan. The issue will be
investigated by the devs, thanks.


Dmitry