Deprecated: X++ index hint clause

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

In Microsoft Dynamics AX 2009, the administrative tool named Microsoft Dynamics AX Server Configuration Utility offered an option that was labeled Allow INDEX hints on queries. Access to this configuration option is no longer available in the configuration utility for Microsoft Dynamics AX 2012, and the option is deprecated. In the system the option’s value is False by default.

Any legacy X++ select statements that include the index hint clause still run fine in Microsoft Dynamics AX 2012. But due to the default value of False, the index hint clause is now ignored, such as in the following code example:

    static void Main(Args _args)    // X++
    {
        CustTable custTableBuffer;
    
        custTableBuffer.disableCache(true);
    
        select
            generateOnly
            forceLiterals
                MainContactWorker
            from
                custTableBuffer
            INDEX HINT HcmWorkerIdx   //index hint is IGNORED in AX 2012.
            where
                custTableBuffer.MainContactWorker == 0
        ;
    
        Global::info(CustTableBuffer.getSQLStatement());
    }

    
    /*****
    The following is output pasted from the Infolog window, with
    whitespace added.
    Notice that this resultant SELECT statement, built by the AX AOS for
    Microsoft SQL Server, lacks an INDEX clause.
    That absence indicates that the AX X++ compiler ignored
    the 'index hint' clause.
    
    
    SELECT
        T1.MAINCONTACTWORKER, T1.RECID
      FROM
        CUSTTABLE T1
      WHERE
        ( ( (PARTITION=5637144576) AND
            (DATAAREAID=N'dat')
          ) AND
          (MAINCONTACTWORKER=0)
        )
    *****/

Overview