A place to share Microsoft Dynamics Ax knowledge.Writing this blog has been to try and make the process of learning AX
programming easier for developers who are new to AX.I hope this blog helps you to
become an efficient AX developer.
Welcome to the wonderful world of AX programming!
Thursday, February 3, 2011
Diff between Primary Index and Cluster Index in Axapta ?
The fields in the Primary Index uniquely identify records in any given table. Each unique combination of Primary Index fields uniquely identifies one (and only one) record in the table. Primary Index fields MUST be unique. There can only be one primary key for a Table. Not all unique indexes are primary keys.
The Clustered index is the physical order in which records are stored in the table. Say you have a clustered index on a text field called "Name", and you insert a record with a name that starts with a letter D, the record will physically be inserted between the C and the E record. Clustered indexes do not have to be unique.
The fields in the Primary Index uniquely identify records in any given table. Each unique combination of Primary Index fields uniquely identifies one (and only one) record in the table. Primary Index fields MUST be unique. There can only be one primary key for a Table. Not all unique indexes are primary keys.
ReplyDeleteThe Clustered index is the physical order in which records are stored in the table. Say you have a clustered index on a text field called "Name", and you insert a record with a name that starts with a letter D, the record will physically be inserted between the C and the E record. Clustered indexes do not have to be unique.