Question
What are different types of indexes available in databases?
Asked by: USER6811
59 Viewed
59 Answers
Answer (59)
Common index types include B-tree indexes (most common), Hash indexes, and Full-text indexes. B-tree indexes are good for equality and range queries. Hash indexes are good for equality lookups. Full-text indexes are optimized for searching text data. The best type of index depends on the type of queries you're running.