A simple select statement is taking 5 minutes to run in SQL Server. There
are no sorts, groupings or where blocks, simply a Select Field1,Field2, ....
From Table. The table contains 606,775 records. When a query is run from
Access that uses a linked table to that table in SQL Server, it takes 35
minutes to run. When the same query is run from Access linked to a table in
another Access application also with 606,775 records, it runs in 35 seconds.
Any ideas ?