From the Obsidian library
Methods
- B-tree
- Hash index
- Geospatial index (for geographic data)
- Geohashing
- Quadtrees
- R-trees
- Inverted index (for full-text search)
References
- DB Indexing in System Design Interviews – B-tree, Geospatial, Inverted Index, and more! – YouTube: https://www.youtube.com/watch?v=BHCSL_ZifI0
- What is the MySQL index feature used for, and how do you use it? –
Tools & Programming – Beginner: mysql index索引功能有什么用，怎么用