>OH. MY. GOD.
>
>I was crafting an SQL statement joining three tables, and accepting parameters to limit the results returned from each. Table 1 has 10K records. Table 2 has 100K records. Table 3 has 1 million records. I ran the first test, counting seconds until I got results. One. Two. Three. Four. Five. Six. Seven. Eight. Nine. Ten. Eleven.
>
>Not that bad considering the scope, I thought.
>
>Then I changed the Where condition to filter Table 3 instead of Table 2, and ran the test again. Wuh-- *blink* Results in less than one second. I LOVE VFP.
>
>Chris.

Both sound plenty fast to me, Chris.

I just want to say that you would have got the same 'flash' response if you had run the same statement again, because the first brings all necessary records into storage and the second can simply use them all again.

cheers