BAQ Performance suddenly horrible

Off Topic
22

Thank You!
Order By 1 OPTION (RECOMPILE) seems to have fixed it, but unsure why. I’m not sure why I would see inconsistencies so drastic between users, even on the same computer?

Does anyone know if Epicor, or in here, if there is a good list of execution properties, what they are used for and how to use them? I did not see anything from Epicor just individual threads in this forum.

23

Google for parameter sniffing in SQL server.
Option RECOMPILE is quick and dirty fix and creates different execution plan on each run that also consume resources. You should not use it for queries that run often - like once a minute or less

2 Likes