Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Which query is faster?
Message
 
To
13/01/2001 09:39:42
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00463375
Message ID:
00463376
Views:
14
>Hi,
> I am developing multiuser application. I have a query which need to join 3 tables through network. Could I know, which way of SQL coding is faster?
>
>1. Join 3 tables in ONE SQL Statement
>
>2. Firstly, join 1st and 2nd table and then join the 2nd with the 3rd table.
>
>
>Thank you


I think the first one, but you can easily test this.
The SQL downloads a part of the (index) data while working, and at the second method you download the same data twice.
Previous
Reply
Map
View

Click here to load this message in the networking platform