What are the two types of indexes and explain them in detail? Orwhat’s the difference between clustered and non-clustered indexes

There are basically two types of indexes:-

  • Clustered Indexes.
  • Non-Clustered Indexes.

In clustered index the non-leaf level actually points to the actual data.In Non-Clustered index the leaf nodes point to pointers (they are rowid’s) which then point to actual data.