Russ, your slow query

[Ruslan Zasukhin]

On 6/2/06 4:20 PM, "Russ Tyndall" <fitzbew at nc.rr.com> wrote:

Hi Russ,

I have locate source of problem.

We have no yet optimization for case when
    joins present
    WHERE have at least 2 conditions from one table
        and at least one condition from other join table

In this case Valentina go todo SCAN instead of indexed searches.

I will add this optimization. May be today.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]