Difference between Primary & Cluster index in ax

Primary index: It works on unique indexes. The data should be unique and not null. Retrieve data from the database.

Clustered Index: It works on unique and non unique indexes.retrieve data from the AOS.

The advantages of having a cluster index are as follows:

·                     Search results are quicker when records are retrieved by the cluster index, especially if records are retrieved sequentially along the index.

·                     Other indexes that use fields that are a part of the cluster index might use less data space.

·                     Fewer files in the database; data is clustered in the same file as the clustering index. This reduces the space used on the disk and in the cache.

The disadvantages of having a cluster index are as follows:

·                     It takes longer to update records (but only when the fields in the clustering index are changed).

·                     More data space might be used for other indexes that use fields that are not part of the cluster index if the clustering index is wider than approximately 20 characters).