I have a question concerning RUSHMORE and SELECT-SQL.

Suppose I have 2 tables, Customer and Orders, and both table have an index on cust_id and deleted(). In the table customer, cust_id is a
primary index. In the table orders, cust_id is a regular index.

If I do a select-sql of both tables, will RUSHMORE optimize this query.

SELECT * ;
FROM CUSTOMER A, ORDERS B ;
WHERE A.CUST_ID = B.CUST_ID ;
INTO CURSOR QTEMP


The reason I ask this question is because the SYS(3054,1) function displays NONE when using more than one table in a query...

Will RUSHMORE use the primary index of the customer table or do I need
to create a regular index on cust_id also ?