Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Help to Speed up SQL
Message
De
09/03/2002 12:16:43
 
 
À
09/03/2002 12:08:01
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00629818
Message ID:
00630598
Vues:
30
I've verified that there is an index on t1.Field2
t1.Field2 = .f. had no effect (maybe a little slower)

I discovered something else about this query. See my response to Hilmar for new info.

>I think Hilmar had a good suggestion when he said to use a WHERE clause. I wonder if the WHERE clause you've used is "optimal" (for Rushmore). Maybe ...WHERE t1.Field2 = .F. ... would make a difference????
>
Bill Morris
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform