Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Optimizing a View/SQL-Select
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00443643
Message ID:
00444036
Views:
14
>>Change the INNER JOINS to WHERE clauses. For whatever reason, the query engine takes longer to process joins than it takes to process the same results from a where statement.
>>
>>Just a thought.
>
>
>I always use WHERE clauses.
>
>Peter

I already tested that and there wasn't a significant difference.
Previous
Reply
Map
View

Click here to load this message in the networking platform