The AL developer preview is still evolving with frequent updates. Follow us on the Dynamics NAV Team Blog for the announcements.
Sets the value to determine whether SIFT structures should be created in SQL Server to support the corresponding SumIndexFields for the Dynamics 365 for Finance and Operations, Business edition key.
True to create the SIFT structures in SQL Server; otherwise, false. The default is true.
SumIndexFields are created in Dynamics 365 for Finance and Operations, Business edition to support FlowField calculations and other fast summing operations. SQL Server can sum numeric data by scanning the table. If the SIFT structures exist for the SumIndexFields, summing the fields is faster, especially for large sets of records, but modifications to the table are slower because the SIFT structures must also be maintained.
In situations where SumIndexFields must be created on a key to enable FlowField calculations, but the calculations are performed infrequently or on small sets of data, you can disable this property to prevent slow modifications to the table.