Subject | Re: [firebird-support] Slow query because an index is not picked up during sort |
---|---|
Author | Alec Swan |
Post date | 2012-06-06T18:22:54Z |
SET thanks, it makes sense. So, Firebird is unable to pick the right plan
for >= because it doesn't have histograms, right?
for >= because it doesn't have histograms, right?
On Tue, Jun 5, 2012 at 9:55 AM, Ann Harrison <aharrison@...>wrote:
> **
>
>
> >
> >
> > >
> > I am assuming you meant to use LEFT not INNER JOIN, right?
> >
>
> Right - and right that I got SAP and SAS confused (again). Typing,
> talking, and trying to get the dog to stop emptying the trash should not be
> done simultaneously.
>
>
> Ann
>
> [Non-text portions of this message have been removed]
>
>
>
[Non-text portions of this message have been removed]