Subject Re: [firebird-support] correlated subquery optimize problem under FB 2
Author Alexandre Benson Smith
Hi Thomas !

I had not followed the entire thread.

But a quick suggestion:
Move the OUTER JOIN's to the end, put all INNER JOIN's first

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br