#MongoDB Index Types, How, When and Where Should They be Used?
summary
MongoDB has 12 index types and the talk shows concrete tradeoffs: collection scans on 100,000 documents take about 350 ms on 100k docs without an index but B‑tree indexes can drop lookups to near zero at query time while increasing write I/O per index. Multikey arrays send whole arrays in replication, TTL deletions run roughly every 60s and can overwhelm the server if many rows expire at once, and unique indexes not allowed on sharded collections.
AI-written summary · about
chapters (16)
- 0:00Start
- 1:38Agenda
- 2:03What is an index?
- 3:13how do indexes work?
- 4:06indexes in #MongoDB
- 6:22how do indexes work?
- 7:09Costs of maintaining indexes
- 8:47indexes in #MongoDB
- 9:27Type of indexes
- 15:142d Sphare
- 16:18text indexes
- 17:07sparse and filtered indexes
- 17:52Hash indexes
- 18:14TTL indexes
- 19:05Quick review
- 19:51Q&A
