From the docs about the optmizer, there is a small section :



Cop-Out

The user can pick or influence the optimizer’s decision. The Firebird
optimizer actually uses all three


Could anyone explain me further how the user can go about to effectively
pick or influence the optimizers decision?
By “pick” I assume it is to use an explicit manual PLAN statement, but what
about “influence”? I know some rdbs like oracle have a HINT statement, but I
haven’t found anything similar in firebird.
And also, can user action “permanently” influence the optimizer in positive
ways in future queries?



Atenciosamente,

Rudi Feijó


Multidados Informática Ltda.
* (11) 2579-8789

* <mailto:ariane.cutlac@...> rudi.feijo@...

* <http://www.multidadosti.com.br/> www.multidadosti.com.br
* <http://www.whatsappmailing.com.br> www.whatsappmailing.com.br







[Non-text portions of this message have been removed]