What Are Indexes?

1.	What Are Indexes?
Answer» Index can be thought as index of the book that is used for fast retrieval of INFORMATION. Index uses one or more column index keys and pointers to the record to locate record. Index is used to SPEED up query performance. Both exist as B-tree STRUCTURE. Kind of the INDEXES are CLUSTERED and non-clustered.

Answer»

Index can be thought as index of the book that is used for fast retrieval of INFORMATION.
Index uses one or more column index keys and pointers to the record to locate record.
Index is used to SPEED up query performance.
Both exist as B-tree STRUCTURE.
Kind of the INDEXES are CLUSTERED and non-clustered.

Discussion