Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
*Select (...) Union (...)* in VFP5.0
Message
From
08/01/1997 17:10:16
 
 
To
08/01/1997 15:58:10
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00016687
Message ID:
00016792
Views:
32
>>>it seems that some of the queries that were rushmore optimizable are not anymore...
>>
>>I`m using combined *Select(...)Union(...)* for selection of unique values from two same type fields. If such kind of queries are not optimizable anymore and works so slowly, is there other fast way to do it ?

use ANSI JOIN syntax and the FORCE clause to tell vfp the order to do the joins

Arnon
Previous
Reply
Map
View

Click here to load this message in the networking platform