| Subject | Re: [firebird-support] Firebird optmizer cop-out |
|---|---|
| Author | Dimitry Sibiryakov |
| Post date | 2018-12-05T20:25:49Z |
05.12.2018 19:25, Rudi Feijó rudi.feijo@... [firebird-support] wrote:
Optimizer is using database statistics, including index statistics and you must order
their recalculation manually sometimes, there is no automatic housekeeping.
--
WBR, SD.
> One last question, does the optimizer actively learns and auto-improves from queries if weNo. No AI inside.
> set the PLAN manually?
Optimizer is using database statistics, including index statistics and you must order
their recalculation manually sometimes, there is no automatic housekeeping.
--
WBR, SD.