Yeah, sorry, that was a typo; the "FROM Vers" should actually be "FROM
EVers". We had also tried moving the criteria to the join and it
didn't make any difference. Btw, this is 1.0.3 and not 1.5.

Also, adding the joins one at a time doesn't really help. As soon as
you add Enames it is Natural.

Finally, the ENames table has around 400k rows in it. :(

R.

--- In firebird-support@yahoogroups.com, "Adam" <s3057043@y...> wrote:
> Hi Robert,
>
> Where are you getting the Evers from? There is no table or alias
> named that in your listed query. Can I assume it is a typo in your
> query, and the "from" table should actually have an alias called
> EVers?
>
> If that is the case the first thing I would do is to move the first
> where condition to the join. I have never worked this out, and I am
> sure there is an explanation that would explode my brain at this
> time, but FB 1.5 often performs better when some of the where
> conditions are moved to the join. This is not a good thing, and is
> hopefully improved in FB 2, but I am a believer in making what we
> have work.
>
> Also, how many records are in the Enames table? If it is only a few,
> the optimiser may choose to start at that point, but I often find it
> helpful to introduce one join at a time and watch the plan change,
> then if anything strange starts occuring I know why.
>
> Hope that helps
> Adam