What is an index and types of indexes. How many number of indexes can be used per table

 Posted by Pardhu2020 on 2/18/2014 | Category: Sql Server Interview questions | Views: 2293 | Points: 40
Answer:

Indexs are used for the faster retrivel of data.

Two types of indexes
1)Cluster index,2)Non-clustered index

clustered index is physically stored a table can have 1 clustered index
non clustered index is logically stored a table can have 249 non clustred index

CLUSTERED INDEX:
Clustered index will be created by default when u create primary key on a column. So we can create one clustered index per table. clustered index is stored in serial passion.

NON CLUSTERED INDEX:
Non clustered index will be created automatically when u create unique key on a column. A table can have no.of unique keys, so we can create no.of non clustered indexes per table.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response