Subject Firebird optmizer cop-out
Author Rudi Feijó
From the docs about the optmizer, there is a small section :


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?


Rudi Feijó

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

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

* <>
* <>

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