Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Which SQL will execute faster?
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
01181138
Message ID:
01181176
Vues:
9
>The difference only important with LEFT OUTER JOIN because conditions in ON clause are evaluated before joining tables and WHERE conditions are evaluated after. It can produce different results.

Only LEFT outer join? Not RIGHT?
Is there a document explaining the general order in which SQL SELECT clauses are processed? I understand that the optimizer makes many decisions but there should be some sceleton to the command.

All the best in the new year.
A moment of silence is our cosmic reset button.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform