I modify the following query SQL by changing the WHERE clause value and use the query QueryDef.SQL to save the changes. Before doing the update the query runs very fast but after it is much slower. The tables are indexed on the WHERE clause field (LoadID). What can I do to modify the query as I need and not affect the speed?
SELECT Clients.TheName AS ClientName, LoadStops.LoadID, LoadStops.Stop, OrderDetail.ProbillNumber, OrderHeader.ClientOrderNumber, OrderDetail.DeliveryPO, Format([LoadStops].[Arrived],”mm/dd/yyyy hh:nn”) AS Arrived, Format([LoadStops].[Departed],”mm/dd/yyyy hh:nn”) AS Departed, Locations.TheName
FROM (Locations INNER JOIN (((LoadStops INNER JOIN LoadDetails ON (LoadStops.Stop = LoadDetails.Stop) AND (LoadStops.LoadID = LoadDetails.LoadID)) INNER JOIN OrderDetail ON (LoadDetails.Item = OrderDetail.Item) AND (LoadDetails.ProbillNumber = OrderDetail.ProbillNumber)) INNER JOIN OrderHeader ON OrderDetail.ProbillNumber = OrderHeader.ProbillNumber) ON Locations.TheID = LoadStops.Location) INNER JOIN Clients ON OrderHeader.ClientID = Clients.TheID
WHERE (((LoadStops.LoadID)=146403))
ORDER BY Format([LoadStops].[Arrived],”mm/dd/yyyy hh:nn”);