Query Speed

[cocoonfx]

I have a number of queries which build two or three Union queries which looks at 35,000 records, and when you open the Union queries or run reports it takes forever for them to open.

I have indexed all the tables which have the common fields to see if this speeds it up the queries, but there still slow. The table they look at are in two different tables which are linked into a front end where the queries are!

Is there any suggestions?

 

[KenHigg]

I some of the worst cases, I have snap-shot'd the tables over to a local machine and sometimes they run quicker when they aren't on the network...

 

[cocoonfx]

Thank You

Hummm i don't think i can do this as it has to be on a network..