Performance – support for included columns in keys


This content is archived and is not being updated. For the latest documentation, go to What's new and planned for Dynamics 365 Business Central. For the latest release plans, go to Dynamics 365 and Microsoft Power Platform release plans.

Enabled for Public preview General availability
Users, automatically Oct 1, 2021 Oct 1, 2021

Business value

With the introduction of the partial record loading feature, a developer can now tailor indexes to include exactly the data needed for certain queries, so that all data needed for a specific query could be loaded just with the index pages.

Feature details

AL developers can now create fully covering indexes that perform well. Just use the new keyword IncludedColumns in the key definition to create indexes with included columns on the leaf nodes.

Benefits of indexes with included columns are:

  • Included columns do not count against the 16 fields in an index definition.
  • An index with included columns require less I/O on the database.
  • An index with included columns is smaller and more likely to be cached in the database cache.

See also

Secondary keys with included fields (docs)