Difference between Primary & Cluster index.

X++ Programming Language >   D365 Table >   Indexes in Dynamics 365 Finance and Operations (D365FO)  

Short Question

185


Answer:

Difference between Primary & Cluster index.

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: Olt 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).


This Particular section is dedicated to Question & Answer only. If you want learn more about X++ Programming Language. Then you can visit below links to get more depth on this subject.




Join Our telegram group to ask Questions

Click below button to join our groups.