ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

user-image
تم إضافة السؤال من قبل Ubaid sayeed Mohd abdul sayeed , Senior Programmer , Moksha solutions
تاريخ النشر: 2016/09/23
Gayasuddin Mohammed
من قبل 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
من قبل 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.

المزيد من الأسئلة المماثلة

هل تحتاج لمساعدة في كتابة سيرة ذاتية تحتوي على الكلمات الدلالية التي يبحث عنها أصحاب العمل؟