Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Speed difference
Message
From
04/03/2004 16:39:47
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Speed difference
Miscellaneous
Thread ID:
00883280
Message ID:
00883280
Views:
44
Hi All,

Is one slower than the other?
Select * from Table Where Field1="1" And (Field2="2" or Field2="3")
Select * from Table Where (Field1="1" And Field2="2") or ;
                          (Field1="1" And Field2="3")
I'm creating a simple query builder type form and the later will be easier to load from a table. Just wanted to know if I should expect a speed difference.

Aloha,

James
Next
Reply
Map
View

Click here to load this message in the networking platform