Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Partial vs Full Optimization
Message
De
06/02/2001 23:50:23
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Partial vs Full Optimization
Divers
Thread ID:
00473308
Message ID:
00473308
Vues:
59
What determines if a simple query (no joins) is fully or partially optimized?

For example: I have a table RATES in MyDatabase
OPEN DATA MyDatabase
ALTER TABLE rates ADD PRIMARY KEY r_pk
SELECT * FROM rates WHERE r_pk = 5
shows the following
Using index tag R_pk to rushmore optimize table rates
Rushmore optimization level for table rates: partial
Why wouldn't this simple query be fully optimized??

Thanks to all.........Rich
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform