Salut Ricardo!

Try using sys(3054,11). Note the 11 as the second param and not 1. 11 also shows the optimization for the join condition. 1 shows only the optimizations for WHERE conditions.

Although you have your condition in the WHERE clause, the condition is in fact a join condition. Your SELECT could have been (equivalent):

SELECT * ;
FROM CUSTOMER A INNER JOIN ORDERS B ;
ON A.CUST_ID = B.CUST_ID ;
INTO CURSOR QTEMP

Only sys(3054,11) shows the optimizations for this kind of conditions.

Vlad