Join tables question

  • Thread starter Thread starter Samuel
  • Start date Start date
S

Samuel

Hi

I wonder whether there is a difference between joining tables using the
Inner Join Clause or the Where clause to join tables in terms of speed etc.

Thank you,
Samuel
 
As far as I know, using the join is faster in Access.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Samuel said:
I wonder whether there is a difference between joining tables using the
Inner Join Clause or the Where clause to join tables in terms of speed etc.
Click to expand...


Hard to tell. The query optimizer reorganizes the query's
execution so either way may end up as the other or something
else. IMO, the Join is the clearer way to specify the
relationship and I kind of think it provides the optimizer a
better clue.

The most important performance factor is having an index on
the linking fields.
 
Back
Top