Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
RUSHMORE Question...
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 ?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement