>Hi,
>
>I am looking to see if we're using the right code to extract some data. Tables are networked, can be from 500Mo to 1,5Go (10 millions to 35 millions records), index keys can be from 25 to 35 bytes long and each tables has 2 or 3 indexes.

If you're in VFP 8, you might test INSERT INTO ... (SELECT...) to see whether it's faster.

Tamar