| Subject | Re: [firebird-support] Firebird optmizer cop-out |
|---|---|
| Author | Dimitry Sibiryakov |
| Post date | 2018-12-05T11:44:32Z |
05.12.2018 12:37, Rudi Feijó rudi.feijo@... [firebird-support] wrote:
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".
--
WBR, SD.
> Could anyone explain me further how the user can go about to effectivelyJoin order can be forced by using outer join.
> pick or influence the optimizers decision?
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".
--
WBR, SD.