Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-09-19 : 15:56:40
|
Wouter writes "Hi,
I have 2 Access tables from 2 different databases.
I imported one of the tables into the other Access DB.
Using ASP & ADO I can now make a query :
"SELECT * from Table 1 WHERE etc
UNION
SELECT * FROM Table 2 WHERE etc"
There are only about 500 records in each table and the query takes 15 seconds to execute !
Individually, each query takes about 0.02 seconds.
With a UNION it takes 15 seconds !
What can I do ?
Thanks so much in advance....
Wouter"
|
|
|
|
|
|
Big speed problem with a UNION SQL query