Answer:
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