Subject Re: [firebird-support] How to optimize this query using Firebird?
Author Alexandre Benson Smith
partsi wrote:
> A support question to DB experts.

... snip...

> How could I assist the optimizer to choose the most effective data
> condition to be evaluated first? How do I make my query OR DB layout
> optimum for these searches? Should I move from my normalized DB
> structure to a more denormalized form in which the data values are
> directly stored for object versions in the same table?
> Any comments appreciated!
> Timo Partanen

First question....

What's the plan for your query ?

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil