Hi,

In our application, we have lots of problem with response time in queries.
For example, a query on 2 tables :

SELECT d0301700.Lot_Nbr, d0301000.Part_Nbr, d0301000.Part_Name ;
FROM d0301700 ;
INNER JOIN d0301000 ON d0301000.Id_PartStd = d0301700.Id_PartStd ;
WHERE d0301700.Id_Locat = 1 ;
INTO CURSOR curTemp

D0301000 => 1613 records
Part_Nbr is C(20)
Part_Name is C(80)
Index on DELETED()
Index on Id_PartStd
35 other indexes

D0301700 => 136108 records
Table Size 402MB (130 fields = 3158C)
Lot_Nbr is C(20)
Index on DELETED()
Index on Id_PartStd
Index on Id_Locat
2 other indexes

Result => 107987 records in 64 seconds !!!

Rushmore optimization (SYS(3054)) is full for the two tables.

I think that it can take less time than 64 seconds but I don't know how to reach better performance.

Can anybody help me ?

Thanks

Marc