I am working on a very large request in a legacy application. This is a large insert query that spans 4 tables with over a million records. I know, I would prefer this on a SQL server, but there is no infrastructure for this client :-)
This request has been working for over a year. However, the source tables continue to grow, and last week he threw a terrible error "out of system resources." Bummer ...
I think you can optimize this query. When working in MySQL, I would use the explain command to find out where the optimization might happen. Is there an equivalent to this in Access? I can't seem to find him ...
Yours faithfully,
Floor
source
share