Hi Everybody,

I am trying to speed up a query that I use because it takes around 33 seconds to pull out 8 records from a table that has 24,504 records. Below is the query that I am using:
SELECT table1.*;
FROM (tmp_name) table1 ;
inner JOIN (Alias_Name) table2 ON table1.partno = table2.partno .AND.
table1.Suppid = table2.Suppid;
INTO CURSOR tmp_cursor

The structure of table1 is Date D, Suppid C(10), Partno C(17), e_0199 C(10), q_0199 I, etc.
The structure of table2 is Primekey I, Suppid C(10), Partno C(17), etc.
I have an index on partno, suppid and partno + suppid on the table1 table.

Please note that table1 is in a FoxPro 2.x data structure and table2 is a free table created on the run.

Thanks,
Joseph Schaff