too many left joins

G

Gary B

I have found that when i ran a Query using 12 Left Joins, everything went
fine, when I added two more left joins to the same query, there was a
lengthy hesitation in returning the results, does anyone know why?
 
C

Chaim

Sort of sparse on the details, isn't it? Care to provide any more
information- table sizes, linked/local tables, SQL?
 
G

Gary B

Sort of sparse on the details, isn't it? Care to provide any more
information- table sizes, linked/local tables, SQL?
Click to expand...


Table sizes are not big. Only returning 6-7 fields.
It is even slow with completely empty tables! No data in the tables with
nothing to return
ALL Local Tables.
All in SQL
 
J

John Vinson

Table sizes are not big. Only returning 6-7 fields.
It is even slow with completely empty tables! No data in the tables with
nothing to return
ALL Local Tables.
All in SQL
Click to expand...

Are there appropriate indexes on the join fields?

If the data is stored in SQL/Server, you may want to consider creating
Views or Stored Procedures in SQL and linking to these with Access,
rather than trying to construct a very complex query in Access.

John W. Vinson[MVP]
 
Top