Difference between Primary and Cluster index in Axapta

Primary index uniquely identifies records in any given table. Each unique combination of Primary Key fields uniquely identifies only one record in the table. There can only be one primary key per table.

Cluster Index is the physical order in which records are stored in the table. Cluster Indexes do not have to be unique.

No comments: