Thanks for the clarification. I wasn't sure whether it was restarting Fox or cold boot that was required. Guess I picked the wrong one but I'll remember it better now. ;-)

I will be moving to W2K in a month or 2 and will check out the info available under the process tab.


>"If you're testing your SQL with and without indexes to find the right combination, be sure to close out of FoxPro between tests to eliminate the caching."
>
>The OS will also be doing plenty of caching, both the Workstation and the Server (if one is involved). The bad news is that a categorical picture can only be obtained by cold boots all round between each test!
>
>If you are using NT4 / Win2K you should also consider using PerfMon.Exe or the Task Manager - with the Process Tab selected, select Select Columns from the View menu, and enable both Page Faults and PF Delta. If you see large values in the PF Delta during the first run, but none or few during subsequent runs, then your queries are faster the second time round due to caching.