Slow Query

[turtle]

I have a query that is based on 6 different queries. Each of these
queries takes about 6 seconds to run. When i create a new query using
data from each of these 6 queries the query takes over a minute. They
are all linked to a master Job table which is only a couple hundred
records.

Is it normal for a query to take longer than all the sub queries
combined?

I figure i have a design issue but am unsure where. The Job field is
indexed. The queries are written in Access but the data comes from a
backend SQL server.

thanks for your help,

KO

 

[pietlinden]

I have a query that is based on 6 different queries.  Each of these
queries takes about 6 seconds to run.  When i create a new query using
data from each of these 6 queries the query takes over a minute.  They
are all linked to a master Job table which is only a couple hundred
records.

Is it normal for a query to take longer than all the sub queries
combined?

I figure i have a design issue but am unsure where.  The Job field is
indexed.  The queries are written in Access but the data comes from a
backend SQL server.

thanks for your help,

KO

I would have someone write a view/stored procedure on the back end
that delivers just the data you need. If you can do that, it would be
your fastest option because everything is run on the server.