Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Which SQL will execute faster?
Message
From
01/01/2007 05:47:52
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
01181138
Message ID:
01181176
Views:
8
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform