Optimizer Improvements

Firebird Documentation Index → Firebird 3.0.6 Release Notes → Changes in the Firebird Engine → Optimizer Improvements

Firebird Home

Optimizer Improvements

Dmitry Yemanov

See Tracker item CORE-4528.

Hash/merge joins for non-field (DBKEY or derived expression) equalities are now allowed.
See Tracker item CORE-1482.

The optimizer now considers the ORDER BY optimization when making its decision about join order.

Firebird Documentation Index → Firebird 3.0.6 Release Notes → Changes in the Firebird Engine → Optimizer Improvements