Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>Hi, folks...
>
>Couple of questions...
>
>First, are there any known issues/advantages of doing tables joins in a JOIN vs WHERE? I had always believed the performance would be similar, but I recently saw the same query coded with a JOIN and then a WHERE...basic query against a large invoice tables and a join against a couple of masters. The JOIN syntax took 15 minutes, and the WHERE took about 11.
>
The best way to check out the performance (assuming your talking about local tables) is with SYS(3054). That way, you can see exactly what VFP is doing, which indexes it's using to do what.
One difference is that in the JOIN clause, VFP will look at the tables on both sides of the expression and, if both have tags, choose which one to use. In WHERE, only the left-hand side is considered.
Tamar
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement