Subject Re: [firebird-support] Firebird optmizer cop-out
Author Dimitry Sibiryakov
05.12.2018 19:25, Rudi Feijó rudi.feijo@... [firebird-support] wrote:
> One last question, does the optimizer actively learns and auto-improves from queries if we
> set the PLAN manually?

No. No AI inside.
Optimizer is using database statistics, including index statistics and you must order
their recalculation manually sometimes, there is no automatic housekeeping.