Subject Re: So confused
Author Adam
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

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