Trying to optimize / speed up a delete query in Access.
Posted on 2012-08-24
I'm working on some append/delete queries that are moving sets of information from one table and putting it into an archive. The information it moves depends on the criteria from another query. I managed to get the append query set up and it runs really quick. Now I just need to delete the specifed data from my live table.
Here is my current delete query that runs WAY TOO slow;
DELETE tblFAICharacteristicNums.*, tblFAICharacteristicNums.JobNum
WHERE (((tblFAICharacteristicNums.JobNum) In (Select jpJobNum FROM [qryMoveCrit])));
Let me know if you have any ideas as to how I can speed this up.
Thank in advance!