Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL optimization
Message
From
22/08/2001 01:06:23
Chung Iu
Globsys
Hong Kong, Hong Kong
 
 
To
21/08/2001 06:48:01
Chung Iu
Globsys
Hong Kong, Hong Kong
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: SQL optimization
Miscellaneous
Thread ID:
00546622
Message ID:
00547105
Views:
14
Oops.
I typed something wrong

>>SQL 2 used temp index and SQL1 used key2 as index.

should be:

SQL 2 used key2 as index and SQL 1 used temp index

thus SQL 2 faster than SQL 1
Sorry.
Previous
Reply
Map
View

Click here to load this message in the networking platform