Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

Can Clustered Index have two Cluster index.... If not Why?

user-image
Question ajoutée par Ubaid sayeed Mohd abdul sayeed , Senior Programmer , Moksha solutions
Date de publication: 2016/09/23
Gayasuddin Mohammed
par Gayasuddin Mohammed , Advocate , Practicing Law before High Court at Hyderabad

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.

Roshan Zameer Mohammad
par Roshan Zameer Mohammad , Technology Lead , Infosys Limited

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.

More Questions Like This

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?