MongoDBeasy

TTL index: what does it do and when would you use it?

Answer

A TTL index automatically deletes documents after a specified time based on a date field. Use it for expiring data like sessions, OTPs, or temporary logs to avoid manual cleanup.

db.sessions.createIndex({ expiresAt: 1 }, { expireAfterSeconds: 0 })

Related questions

MongoDB

Unique vs sparse vs partial indexes: what’s the difference?

#mongo#indexes#unique

MongoDB

Text indexes: when would you use them and what’s a limitation?

#mongo#text-index#search

MongoDB

`$lookup`: what does it do and what is a common pitfall?

#mongo#lookup#aggregation

MongoDB

Replica set elections: what happens during an election?

#mongo#replica-set#election

MongoDB

Read preference in replica sets: what does `primary` vs `secondary` mean?

#mongo#replica-set#read-preference

MongoDB

Read concern vs write concern: what do they control?

#mongo#consistency#read-concern