Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Rushmore optimization and SELECT DISTINCT
Message
De
09/12/1997 16:49:21
 
 
À
09/12/1997 16:32:38
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00064798
Message ID:
00064803
Vues:
41
>I have a SQL query that includes SELECT DISTINCT that is not using Rushmore. I have UNIQUE index tags that could be used to speed up the query.
>
>Are all SELECT DISTINCT queries not able to use Rushmore?
>
>I can always use my index tag and use COPY TO but it seems that this should not be necessary.

IMHO, Rushmore is about 'Where' expressions, i.e. field list is rushmore-irrelevant. I think, the first internal step is collect all records by joint criteria (here Rushmore used), and then Fox looks at field list.
Edward Pikman
Independent Consultant
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform