Large Union Queries

  • Thread starter Thread starter Nathan
  • Start date Start date
N

Nathan

Hi,

I have a large union query that adds together a number of
different tables and appends them to a one table. Most
of the queries have a group by in them to summarize the
data by month. What I was wondering it is more efficient
to place a where clause limiting the dates, or in each
component of the union?

Mark
 
Probably more efficient to have a where clause limiting the result by date range
within each component of the UNION query.

BUT, how big are your tables going to be and how much time will you really save?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Large Union Queries and Appending the data 1
Date Limit in Crosstab from Union query 2
Union Query to list duplicates 2
Union Query and Field Alias 7
append with union query? 6
Union query 5
Union Query 2
SUM in a UNION query 2

Back
Top