Complex Queries: Cycle times

A

AZ Analog

Good day!
I'm trying to figure out how to cut the cycle time of running a query. Here
is why I THINK I can cut the cycle time, but I'm not sure. I'm just
wondering if anyone has encountered this situation before, and if you think
it is possible:

I'm running Query B off of Query A results. Query A is run from a set of
linked tables. The data for Query A only changes on a daily basis, whereas
Query B's main purpose is to provide a report based upon a single variable.
This process is run 37 times on a particular day, through the use of a macro.
This process currently takes 29 minutes to complete. Here is where I think
a lot of time is wasted:

Since Query B runs off of Query A, every time Query B is run, Query A is
re-run? So, two queries must process before providing a result. Since the
data for Query A only changes on a daily basis, would it speed things up to
export Query A as a table and then run Query B from that specific table?

Thanks for your time and your help!
 
M

MGFoster

Yes, especially if you then indexed some columns in the new table that
will be used in Query B's criteria (WHERE clause).
 
A

AZ Analog

Thank you MGFoster!

MGFoster said:
Yes, especially if you then indexed some columns in the new table that
will be used in Query B's criteria (WHERE clause).
Click to expand...
 
Top