>Using sys(3054), optimize on, most queries I try, even the simplest, show "None" for optimization level (occasionally I get a "Partial"). I hadn't noticed this problem until a large table query was very slow; the same queries under 2.6 work very quickly. Apparently pre-built indexes are not being picked up in vfp5...
>
Okay, I've made it up to mostly "partial" Rushmore by simplifying the indexes to one field...still haven't been able to get a "full", though...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.