add-index.md

title	description	author	ms.author	ms.topic	ms.custom	ms.date	ms.reviewer	audience	ms.search.region	ms.search.validFrom	ms.dyn365.ops.version
Add indexes to tables through extension	Learn how to add an index to a table through extension so that you can store additional data for access to data based on the new fields.	ivanv-microsoft	ivanv	how-to	bap-template	03/09/2020	johnmichalak	Developer	Global	2017-06-01	Platform update 4

Add indexes to tables through extension

[!include banner]

Often, you extend tables so that you can store additional data for later but also quickly access the data that is based on the new fields. Therefore, it's often beneficial to have a dedicated index that speeds up the database search. You can add a new index to an existing table through extension. To add an index to an existing table, you extend the selected table and then create an index just as you would create an index on a new table. You can add both new and existing fields so that they are part of the new index.

In the following illustration, an InventTable extension is used to define an index for a new field on the InventTable table.

Warning

You should not use this approach to create unique indexes. This change is an intrusive change that might break the solutions of other independent software vendors (ISVs) if those solutions are deployed in the same environment. This capability will be removed in future platform releases.

[!INCLUDEfooter-include]