Union Query Into Linked Tables

[RWCMan]

I'v set up a union query which works on a local table as well as a linked table in another Access DB. The number of records in the local is about 500,000 while the linked table contains about 1,100,000 records...the performance is horrible! I'm looking for some good tips on how to speed this thing up and make it more efficient (I must be pushing the limits of Access).

Thanks in advance for any ideas!

 

[PHV]

What is the expected number of rows returned ?
I'd double check the index.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[RWCMan]

Thanks for your response. The expected number of records, depending on the situation for which the query is being run, could range anywhere from 2 to 1,500 records.

 

[lespaul]

Do you have any indexes on these tables?

 

[RWCMan]

Yes, I believe I have indexed all of the fields that should be indexed. Also, I am using this over a rather large network.