Sets the actual fields that are used in the corresponding index on SQL Server.
This property allows you to define the fields that are used in the SQL index.
The fields in the SQL index can:
- Differ in number from the fields defined in
the key in Microsoft Dynamics NAV—there can be fewer fields or more
- Be arranged in a different order.
If you use this property to define an index on a key that is not the primary key, then the index that is created contains exactly the fields that you specify and will not be a unique index. A unique index will only be created if it contains all of the primary key fields.
If you use this property to define an index for the primary key, it must include all the fields defined in the primary key. You can add extra fields and you can rearrange the fields to suit your needs.