General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
Previous
Next
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