I am writing an Access application that uses SQL Server as the back end database.
I run the following query which takes over 1 minute and 30 seconds to execute.
Any suggestions to speed it up?
dbo.tblFlINT has a data structure as follows with 18,000 records:
[Account Number] nvarchar(10)
[Address 1] nvarchar(35)
dbo.tblIntlAccountFallExcl has a data structure with just 1 field as follows with only about 20 records:
SELECT Distinct [Account Number] FROM dbo.tblFlINT WHERE [Account Number] NOT IN
(SELECT Account FROM dbo.tblIntlAccountFallExcl) ORDER BY 1