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