>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 ?
Rushmore will not use your primary keys because they contain FOR clauses. If you want Rushmore optimization, you must use indexes without FOR clauses whose index expressions EXACTLY match the expression being compared.