How many types of indexes are available in SQL Server?

 Posted by Rajusingh on 8/21/2011 | Category: Sql Server Interview questions | Views: 17285 | Points: 40

There are four type's of index's available in Sql Server.

Cluster : We can create only index in Table. When we create primary key then cluster index create automatically.

Non Cluster: we can create 256 non cluster index in table but should be crate 3 index in table because effect on performance. when create unique key then non cluster index create automatically.

Unique: We can create unique index too.

Composite Key: when we create index with two columns together then composite key index create. like class name and roll no create one index.

Source: self | Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response

More Interview Questions by Rajusingh