[ ax2012 ] Primary key, Clustered index, Replacement key

Primary key : The unique primary key should point to either the natural key, or the surrogate key (RecId).

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. ( ref : dynamicsuser )

Replacement key : indicate which fields are displayed on the UI, regardless of the table’s primary key ( ref : axinternals )


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s