Subject | Re: [firebird-support] LEFT JOIN and NULLs (performance problems) (reposted) |
---|---|
Author | Dmitry Yemanov |
Post date | 2005-08-15T12:37:39Z |
"tdtappe" <tappe@...> wrote:
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
>Sorry for ignoring your previous post :-)
> Sorry for reposting this.
> But isn't there anybody who can tell something about it?Confirmed. AFAIK, this is no longer a problem in FB2 (as an equality
> For instance confirm it!?
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