when we create a primary key on the table a clusterd index gets created automatically.
saira banu
Jun 10th, 2015
Table
Vipin
Jul 7th, 2015
It is always a good practice to create a Clustered Index on the Primary key and make sure that the Primary key is sequential. A table can have only one clustered index where as a table can have unlimited non clustered index.
Also it is the best to create a non clustered index on the foreign keys because the when writing JOIN queries it is going to be way more faster and easier.
Hope this helps.
How to decide which index should be created on a table/ Clustered or Non Clustered?
Related Answered Questions
Related Open Questions