Indexing
Back: Relational Databases
Data structures that speed up data retrieval at the cost of additional storage and write overhead. Proper indexing is the single most impactful optimization for database performance.
Concepts
- B-Tree Indexes
- Hash Indexes
- Composite Indexes
- Covering Indexes
- Partial Filtered Indexes
- Full-Text Indexes
- GIN GiST Indexes
- Index Anti-Patterns