Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
This is a surprise
Message
From
28/02/2000 00:25:29
Paul Vlad Tatavu
X, Ontario, Canada
 
 
To
27/02/2000 22:45:20
John Koziol
Ultimate Software
Miami, Florida, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: This is a surprise
Miscellaneous
Thread ID:
00338270
Message ID:
00338286
Views:
20
Only that Davis said that the SELECT with UNION is faster.

Vlad

>I don't think UNIONS are fully optimizable, Dave. That might explain it. Try both SQLs with SET OPTIMIZE OFF and see what the differences are.
Previous
Reply
Map
View

Click here to load this message in the networking platform