Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Which query is faster?
Message
 
À
13/01/2001 09:39:42
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00463375
Message ID:
00463376
Vues:
13
>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform