Subject Re[4]: [ib-support] WHERE optimization
Author Daniel Rail

>> Maybe someone with more knowledge of the optimizer can give a better
>> answer(Arno!?).

> Ordering has no effect on the execute. The optimizer consider all predicates
> in the where-clause. It also eliminate duplicates and makes new predicates
> from other predicates when possible. I hope you can somewhat with this
> information ?

Thanks Arno. I knew you would have a better explanation, since you
worked in the optimizer lately. And, by the way, keep up the good
work, it's well appreciated(the same goes for the other FB developers

Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (