[Firebird-devel] full outer join vs left union left

[<ip...@ic...>]

I attach archive with firebirs2 database and 2 sql files.

In bad.sql I write sql with full outer join.
In good.sql I write sql with left joins and unions.

All that sqls retrieves same data, but outer joins gets much more time
to execute.

Maybe you can change something in your optmizer in order to reduce
execution time of outer join sqls?

Paul Ishenin.