SQLIndex Property
Sets the actual fields that are used in the corresponding index on SQL Server.
Applies To
Keys
Remarks
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 fields.
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.