Can you name the most common index types used in database management systems?

The most common types of indexes in DBMS:

• B-Tree index — the most common type, suitable for fast search, sorting, and range queries.
• Hash index — effective for exact key searches but does not support range queries.
• Bitmap index — used for columns with low cardinality (e.g., gender, status), effective in analytical queries.
• Full-text index — designed for fast text search.

Example of creating a B-Tree index in SQL:

CREATE INDEX idx_user_name ON users(name);