Edward -

>>It's strange that you get so different results, especially for 4K table. BTW, what is the best time for real case? Do you restart VFP after each query making bench tests?<<

The best time on the table with 4,000 records is about 3 minutes. Yes, we do start over each time by exiting VFP6. Wouldn't be much of a test, otherwise, I suppose. If we don't start over, though, it takes just as long. I think this is due to the fact that Rushmore optimization is not occurring anyways.

- George [Odd, huh?]