Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Which SQL will execute faster?
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
01181138
Message ID:
01181234
Views:
7
>>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?

I never had a reason to use RIGHT OUTER JOIN but it may be affected too.

>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.

Unfortunately, no. Trail and error.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform