too many left joins

  • Thread starter Thread starter Gary B
  • Start date Start date
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?
 
Sort of sparse on the details, isn't it? Care to provide any more
information- table sizes, linked/local tables, SQL?
 
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
 
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]
 
Back
Top