The AL developer preview is still evolving with frequent updates. Follow us on the Dynamics NAV Team Blog for the announcements.

MaintainSQLIndex Property

Sets a value that indicates whether a SQL Server index that corresponds to the Dynamics 365 for Finance and Operations, Business edition key should be created.

Applies To


Property Value

True to create the SQL Server index; otherwise, false. The default is true.


In Dynamics 365 for Finance and Operations, Business edition, you can use a key to sort data in a table by the set of fields specified in the key. SQL Server can sort data without an index on the fields to be sorted. However, if an index exists, sorting by the fields matching the index will be faster, but modifications to the table will be slower. The more indexes there are on a table, the slower the modifications become.

In situations where a key must be created to allow only occasional sorting (for example, when running infrequent reports), set this property to false to prevent slow modifications to the table.


You cannot disable this property on the primary key of a table. This key is always created in SQL Server.

See Also