What is an Index in D365 F&O?
Indexes are used to Sort, Improve the performance of data retrieval and to ensure the Existence of the unique records in the table. Index can be created by one or more fields.
What is Unique key?
Unique key will not allow Duplicate values in the Table, but
it will accept only one null value.
- It can be created by setting allow duplicated to “No” in the Index properties in D365F&O.
- It will accept only one null value in the given index.
- It is available as child key to set the value in the Primary index & Cluster index property in Table.
What is Non-Unique key?
Non-Unique index will allow duplicate values in the record.
- It can be created by setting allow duplicated to “Yes” in the Index properties in D365F&O.
- It will accept null values and duplicate values.
- It is not available to set the Primary index property in the Table properties.
- It is available as child key in the Cluster index property.
What is Primary key?
Primary key will not allow any null values or any duplicate
values in the Table.
- It can be created by setting allow duplicated to “No” in the Index properties and required fields as Mandatory in the Field property in D365F&O.
- No null value can be found in the Table as the required field is set as Mandatory in the field property.
- It is available as child key to set the value in the Primary index & Cluster index property in Table.
What is Primary Index (Table property)?
Primary Index is used to sort the data in the Frontend list page.
- It will only accept Primary and Unique keys.
- To set any key as Primary index, such key should not accept duplicate values in the table and Allow duplicates to “No”.
What is Cluster Index (Table property)?
Cluster Index is used to sort the Data in the Database.
- It will accept all types of keys from the table i.e Primary, Unique, Non-Unique keys.