Why it is advisable to maintain as small clustered index?

 Posted by Rajnilari2015 on 2/4/2016 | Category: Sql Server Interview questions | Views: 1438 | Points: 40
Answer:

It is advisable to maintain as small clustered index as much as possible since the fields used in clustered index may also used in nonclustered index.Data in the database is also stored in the order of clustered index.So, maintaining a huge clustered index on a table with a large number of rows increases the size drastically.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response