Assuming in my report cursor (for eg sales data), I have codes for the following :-
1) Salesman Code
2) Product Code
3) Customer Code
4) Location Code
5) Dept Code
6) Month
7) Sales Invoice Number
8) Sales Invoice Amount

In getting to my final cursor, assuming SQL is used, I would have to join the cursor with 5 master files. Assuming the sales records number a quarter of a million invoices, then joining 5 tables could take a long time....
Haven't tried that yet but my customer's database contains 400k records just for product codes alone.

Would this be faster using store procedures or query to VFP and index and set relation?
Yau