Subject Re: [firebird-support] Firebird optmizer cop-out
Author Dimitry Sibiryakov
05.12.2018 12:37, Rudi Feijó rudi.feijo@... [firebird-support] wrote:
> Could anyone explain me further how the user can go about to effectively
> pick or influence the optimizers decision?

Join order can be forced by using outer join.
Using of indexes can be disabled by changing of simple field usage to an expression.
Preferences between ORDER and SORT plans (more commonly between "first row" and "all
rows" strategies) can be changed by using FIRST/ROWS.
Index statistics recalculation can be done in "a right moment".