How the indexing is getting worked?

 Posted by Suresh.mekkattil on 1/10/2011 | Category: Sql Server Interview questions | Views: 2512 | Points: 40

Indexing is basically working by means of sorting of the columns.
When you create a primary key field a Clustered Index will automatically created. And once that created ou cann't add more clustered index to that table.

This is because there is already a clustered index there and there is no other posibility for sorting the other row since the indexes are working by means of sort.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response

More Interview Questions by Suresh.mekkattil