Register now or log in to join your professional community.
Clustered Index is created on your primary key of the table. Therefore you cannot have more than one primary key and as such only one clustered index will be created on a table.
But you can have composite primary key wherein you create a primary key on more than one field, by clubbing them and having the constraint primary key on the fields asif one field as composite primary key. My 2 cents. Thanks.
A table can have only one clustered Index (Primary Key). Creating clustered index on the column, then data is stored in data pages in a clustered index column sorted order, which improvise the data retrieval. Table can be sorted in only one specific order. We can't follow two or three orders. That is the reason, we can create only one clustered index.
