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
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br