Microsoft GP 10 database table using longer time to get results

Raghu Ariga 2016-08-09 20:15:30

The indexes refresh did not help in faster execution, it slowing the application.

Aaron Bertrand 2016-08-24 03:56:14
The query has to perform a scan because LTRIM(RTRIM(col))<>" is not sargable (and in cases where it can be coerced to be, you are probably returning too many rows for a seek to make sense anyway). This isn't an actual plan, so I don't know how many rows really come back from this query, but I suspect it is slow more because you are returning 4 million rows to some client than because the database is performing a scan.