Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
This is a surprise
Message
De
01/03/2000 21:45:47
 
 
À
01/03/2000 18:14:06
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00338270
Message ID:
00340351
Vues:
25
>Now your original slow command was:
>
>SELECT A.* FROM Address A, Cons C ;
>>> WHERE C.CCust = "GREATLA2" ;
>>> AND (C.Addrnum = A.Addrnum OR C.PAddrnum = A.Addrnum)
>>>
>
>You say that C.Addrnum and C.PAddrnum are not indexed in CONS. That being the case, can you also try it reversing them in both sides of the OR... trying
>... AND (A.Addrnum = C.Addrnum OR A.Addrnum = C.PAddrnum) instead?
>

Makes no difference Jim, it's just a simple failure of the optimiser to recogize the potential here.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform