Russ, your slow query

[Ruslan Zasukhin]

Hi Russ,

The first thing I have discover - you have join on state fields


select *
from locations, statetable
where locations.state = statetable.state


But in table locations it is not indexed.
This cause non-indexed searches.

This is not main show stopper.

I see another non-indexed scan of table, which take 70% of time.
I will check it now and let you know


-- 
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]