General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
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