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 |
|
swenri
Yak Posting Veteran
72 Posts |
 Posted - 2008-09-10 : 10:57:29
|
| I've a query in MS-Access which has 6 tables joined with inner joins, I need to select the OrderId, Segment ID, ServiceName and Actual Drop Off time. There are more than 10000000 records in those tables.I'm selecting the records for last 3 months. The query has been running for the last 4 hours. The tables involved are all ODBC tables linked with Oracle. Please help me to find if there is any faster way to do this. This is really urgent. Thank you all in advance, |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-09-10 : 11:04:14
|
You could use pass-through queries.Even so, it takes time for Access to process 10,000,000 records.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
mmischke
Starting Member
2 Posts |
Posted - 2008-09-10 : 12:27:52
|
| Other than stopping the query there aren't many options. 10m records through multiple linked tables will take quite some time. This time can be longer depending on the complexity of the query itself. |
|
|
|
|
|
|
query taking long time to run