Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Rushmore optimization and SELECT DISTINCT
Message
De
09/12/1997 23:32:50
 
 
À
09/12/1997 16:49:21
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00064798
Message ID:
00064892
Vues:
38
>
>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.

OK,
but I my opinion Rushmore SHOULD be about using existing indexes to achieve the fastest query performance possible.

To ignore UNIQUE index tags is a waste and to be able to beat the performance of SQL by an order of magnitude
with old style xbase code is crazy.
__________________________________________________
Mesa Vista Software (david@mesa-vista.com)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform