HTML
Database Index Types - HTML
Database indexes are data structures used to speed up data retrieval. Various types exist depending on the use case, including B-Tree indexes, Hash indexes, and Bitmap indexes, each optimized for specific query patterns and data characteristics. Selecting the appropriate index is a crucial element in database performance optimization.
database
index
B-Tree
Hash
Bitmap
SQL
performance optimization
<table>
<thead><tr><th>code</th><th>slug</th><th>name</th><th>description</th><th>category</th><th>supportedDatabases</th><th>useCases</th></tr></thead>
<tbody><tr><td>1</td><td>b-tree-index</td><td>B-Tree Index</td><td>The most commonly used balanced tree structure index.</td><td>General-purpose Index</td><td>["MySQL","PostgreSQL","Oracle","SQL Server","MongoDB"]</td><td>["Equality searches","Range queries","Sorting operations","Primary keys","Foreign keys"]</td></tr>
<tr><td>2</td><td>hash-index</td><td>Hash Index</td><td>An index providing constant-time access using hash functions.</td><td>Key-value Index</td><td>["Redis","MySQL (MEMORY)","PostgreSQL","Some NoSQL databases"]</td><td>["Equality searches","Point lookups","Transaction processing","Key-value access"]</td></tr>
<tr><td>3</td><td>bitmap-index</td><td>Bitmap Index</td><td>An index using bit arrays optimized for low-cardinality columns.</td><td>Analytical Index</td><td>["Oracle","PostgreSQL (extensions)","Data warehouse systems"]</td><td>["Low-cardinality columns","Data warehousing","Complex filtering","Read-heavy environments"]</td></tr>
<tr><td>4</td><td>full-text-index</td><td>Full-Text Index</td><td>An index specialized for searching unstructured text data.</td><td>Text Search Index</td><td>["MySQL","PostgreSQL","SQL Server","Elasticsearch"]</td><td>["Full-text search","Partial match search","Similar word search","Document search"]</td></tr>
<tr><td>5</td><td>vector-index</td><td>Vector Index</td><td>An index specialized for similarity search of high-dimensional vectors.</td><td>AI/ML Index</td><td>["PostgreSQL (pgvector)","Pinecone","Milvus","Weaviate"]</td><td>["Similarity search","Image search","Recommendation systems","Semantic search"]</td></tr>
<tr><td>6</td><td>spatial-index</td><td>Spatial Index</td><td>An index specialized for searching geospatial data.</td><td>Geospatial Index</td><td>["PostgreSQL (PostGIS)","MySQL","Oracle Spatial","MongoDB"]</td><td>["Neighbor search","Range search","Distance calculation","Geographic information search"]</td></tr></tbody>
</table>