Announcements
No record found.
What's the difference between ForceLiterals , ForcePlaceholders in context of optimal queries ? What are actually these terms and where to be used ?
*This post is locked for comments
There are already a lot of forum topics, blogs and documentation on the matter, you should use a search engine to find them.
Such as this one:
community.dynamics.com/.../147969
They do more harm than good in majority of the cases, but there could be some special select statements where you want the SQL Server Query optimizer engine to act in a specific way, which could be manipulated by using those keywords.
The AX kernel is using it for example to avoid parameter sniffing by enabling literals for DataAreaId field, so each company would get their own query execution plan for optimum performance by having a hardcoded DataAreaId value.
https://blogs.msdn.microsoft.com/axinthefield/sql-server-parameter-sniffing-with-dynamics-ax-just-plain-evil-redux-5-19-2014/
Kindly mark helpful answers as verified next to each post with the checkbox, thank you.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CP04-islander 39
Michel ROY 14
imran ul haq 8
