Maybe because it's returning 52 times as many rows? Please post the query plan and the two
actual execution plans.
John
Due to the nature of the database - I cant post the actual query. But essentially it's using a pass through query in MS Access directly to the server and written as
SET NOCOUNT ON SELECT field1, field2, field3, Date1 From sqlTBLone WHERE (field1 = 'something') and (Date1 Between '2018/01/28' AND ''2018/02/03')
There's loads more tables with joins, but it's simply written as in the above example
Without the actual execution plans, it's pure guesswork. If you cannot post the actual execution plan, there's not a whole lot that we can do.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA