This keyword can be used either in the form index <indexName> or index hint<indexName>. If only index is used, Microsoft Dynamics AX generates anorder by clause that corresponds to the index components.
An incorrectly used index hint can affect performance, so index hints should
only be applied to SQL statements that do not have dynamic where or order byclauses and where the effect of the hint can be verified.
Microsoft Dynamics AX automatically removes index hints referring to a
disabled index.
By default index hints are disabled on the AOS.
Best Regards,
Hossein Karimi
AX,365,NAV(tutorials: tips and tricks)
Friday, July 6, 2018
Index or Index Hint Keywords
+10 years of experience with hands-on lead-level background in the full life cycle of software development with demonstrated cross-functional team leadership skills.
Programming:
• ERP :Microsoft Dynamics AX 2012
• Language :X++, C#, C++, XAML, Asp.Net, Html, VB.Net, Android
• Environment : Windows XP, Windows 8, Windows 10, Windows Server
• DataBase : Oracle 9i,10g,11g and SqlServer and SQLlite
Subscribe to:
Post Comments (Atom)
-
To integrate Microsoft Dynamics AX and Analysis Services, you must connect Analysis Services to the Application Object Server (AOS). To do s...
-
The below select query will give the both the Sales Line record count and the sum of sales quantity. static void Test_Data(Args _args) ... -
A List object contains members that are accessed sequentially. Lists are structures that can contain members of any X++ type. All the member...
No comments:
Post a Comment