>>>it seems that some of the queries that were rushmore optimizable are not anymore...
>>
>>I`m using combined *Select(...)Union(...)* for selection of unique values from two same type fields. If such kind of queries are not optimizable anymore and works so slowly, is there other fast way to do it ?

use ANSI JOIN syntax and the FORCE clause to tell vfp the order to do the joins

Arnon