too many left joins

[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?

 

[Guest]

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

 

[Gary B]

Sort of sparse on the details, isn't it? Care to provide any more

information- table sizes, linked/local tables, SQL?

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

 

[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

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]