How to decide which index should be created on a table/ Clustered or Non Clustered?

Showing Answers 1 - 3 of 3 Answers

ipsita pani

  • May 27th, 2015

when we create a primary key on the table a clusterd index gets created automatically.

  Was this answer useful?  Yes

saira banu

  • Jun 10th, 2015


  Was this answer useful?  Yes


  • 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.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions