Tell Me What Are The Types Of Indexes?

1.	Tell Me What Are The Types Of Indexes?
Answer» Indexes can be CLUSTERED and non-clustered indexes. Clustered index KEEPS all the RECORDS in the DATABASE in the order of clustered index key. There can be only ONE clustered index per table. Non-clustered indexes are stored as B-tree structure in their own storage separate from data storage in the table.

Answer»

Indexes can be CLUSTERED and non-clustered indexes.
Clustered index KEEPS all the RECORDS in the DATABASE in the order of clustered index key.
There can be only ONE clustered index per table.
Non-clustered indexes are stored as B-tree structure in their own storage separate from data storage in the table.

Discussion