Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to speed up SQL statment
Message
From
06/05/2003 10:26:45
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
06/05/2003 10:15:29
Yh Yau
Ingenuity Microsystems Sdn Bhd
Kuala Lumpur, Malaysia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00785250
Message ID:
00785382
Views:
32
>What's the set exact status when run within the form and in the command window?
>I've noticed that when set exact is on, a query will run slower.
>Yau

Do you think this will affect joins by character fields, or all kinds of joins?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform