Dynamics 365 Business Central: introducing the new Table Key module

Dynamics 365 Business Central

Dynamics 365 Business Central 2024 Wave 1 release introduces the ability to enable or disable indexes via AL code.
The new AlterKey method in the Database object allows for selecting a non-clustered index and enabling or disabling it.
The syntax for the AlterKey method is Database.AlterKey(KeyToDisable, Enable), where KeyToDisable is the reference to the index and Enable is a boolean indicating whether to enable or disable it.
The AlterKey method allows for disabling and re-enabling of non-unique non-clustered indices within the current transaction.
A new Table Key module in the System Application is introduced, providing methods to disable and re-enable table indexes easily.
Disabling keys before bulk table write operations can significantly improve performance.
An example of usage is provided where disabling indexes before deleting records from a large table increases performance.
The new feature will initially be available only for on-premises scenarios.

Registered users can view the full text for FREE!