>>Hello Rudy,
>>
>> Here, VFP is optimizing queries using RushMore and not creating temporary table. You just include NOFILTER clause which disables the Rushmore and try.
>>
>>Bye
>>Jayesh
>>
>Using NOFILTER shuts off Rushmore? I've never heard that one.
>
Steve,
NOFILTER does NOT disable Rushmore at all. It simply prevents the result set of records from being the opriginal table used again with a filter set on it and forces the creation of an actual cursor with the records.
NOFILTER may cause a query to take longer, but that is not because Rushmore is not being used. Rushmore will optimize a NOFILTER query as much as it can.