Question

What are the different types of database indexes?

Answer 1

• Some common types of database indexes include:
  • Single-column index: An index created on a single column.
  • Composite index: An index created on multiple columns, providing faster retrieval for queries involving those columns together.
  • Clustered index: The physical order of the table's rows is the same as the index order. Each table can have only one clustered index.
  • Non-clustered index: The index is stored separately from the actual table data. A table can have multiple non-clustered indexes.