Hi Experts,
I currently have an Access 2010 query with uses one SQL table and one SQL view.
1) DATA-LOAD_SHEET 2) dbo_View_LoadSheetTopDelNo
This query updates the delivery number (DelvNum) and Postcode details in the DATA-LOAD_SHEET table from the dbo_View_LoadSheetTopDelNo SQL view (these two fields can change quite often so query needs to run to update them). The problem is the query takes a long time to run - usually about 1 minute or more.
The DATA-LOAD_SHEET table currently only has 77 records and the dbo_View_LoadSheetTopDelNo has 7177 records. Opening the two tables individually do not take too long to open. The larger table takes a bit longer. So it seems it’s the query that’s the issue. Any ideas on how I could improve the speed of this query?
Access SQL view is as below:
UPDATE dbo_View_LoadSheetTopDelNo INNER JOIN [DATA-LOAD_SHEET] ON dbo_View_LoadSheetTopDelNo.DocNum = [DATA-LOAD_SHEET].OrderNum SET [DATA-LOAD_SHEET].DelvNum = [dbo_View_LoadSheetTopDelNo].[highest_delivery_number], [DATA-LOAD_SHEET].POSTCODE = [dbo_View_LoadSheetTopDelNo].[ZipCode];
Thanks
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.