General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only