Carlos H. Cantu wrote:

> One thing that I always see when FB optimizer comes into the talk is
> that nobody *exactly* know how the optimizer works. I would sugest to
> FF pay someone to study and write a very good documentation about it,
> or even rewrite it entirely to make it smarter.

Several people understand quite completely how it handles inner joins
and there, it doesn't do a bad job. The FB2 changes will improve that
further. What's needed, I think, is a better understanding of the outer
join rules and appropriate work on that area. And of course, a better
access access algorithm for 'in'. But not a throw out the whole mess
and start over, at least not until we've got a better idea what's wrong.

Regards,


Ann