- 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!
Sign In Now!
