General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only