MaintainSiftIndex Property

Version: Available or changed with runtime version 1.0.

Sets the value to determine whether SIFT structures (indexed views) should be created in SQL Server to support the corresponding SumIndexFields part of the Dynamics 365 Business Central key.

Applies to

  • Table key

Property Value

True to create the SIFT structures (indexed views) in SQL Server; otherwise, false. The default is true.

Syntax

key(<key name>;<comma-separated list of lookup fields>) { 
    MaintainSiftIndex=[true|false];
    SumIndexFields=<comma-separated list of aggregation fields>
}

Remarks

SumIndexFields are created in Dynamics 365 Business Central 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.

SumIndexFields Property
Properties