Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to speed up SQL statment
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00785250
Message ID:
00792100
Views:
17
Hi!

Try using the needed Tables for the Select in front of the SELECT
Like this:

if !USED("TABLE")
USE table alias TABLE in 0 nodata shared again
endif
SELECT * from TABLE where ....
Marvin Blase (tA-logistic Software GmbH)
You'll never notice the good things if you haven't seen the bad.
Previous
Reply
Map
View

Click here to load this message in the networking platform