>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 ?
There is an article about Rushmore on my website that may help you.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer