Index Sufficiency Warning
Parent: Archive Rules · Published reference · snapshot 2026-10-15 · viability 3.20 / 5 (research)
↓ Facts as markdownall context files
Depth-first rabbithole dossier for Index Sufficiency Warning; source-anchored research pack.
These notes link each claim to its source. Some citations identify archived research reports that are no longer hosted on this site. A published reference means the content is available; it does not certify independent review or accuracy.Read the editorial policy and follow the sources before relying on a claim.
How it works
- [medium] Atlas runs an index sufficiency query during the first archive run to determine the efficiency of the archival process. Sources: https://www.mongodb.com/docs/atlas/online-archive/configure-online-archive-standard.md, https://www.mongodb.com/docs/atlas/online-archive/configure-online-archive-time-series.md [source]
Problems, failure modes and limitations
- [high] If the ratio of documents scanned to documents returned is 10 or more, the query result triggers an `Index Sufficiency Warning`. Sources: https://www.mongodb.com/docs/atlas/online-archive/configure-online-archive-standard.md, https://www.mongodb.com/docs/atlas/online-archive/configure-online-archive-time-series.md, https://www.mongodb.com/community/forums/t/sort-exceeded-memory-limit-of-104857600-bytes/269787 [source]
- [medium] The index sufficiency query stops running after sufficient indexes are detected, and Atlas does not issue an `Index Sufficiency Warning` if an index is dropped later and slows down the archiving process. Sources: https://www.mongodb.com/docs/atlas/online-archive/configure-online-archive-standard.md, https://www.mongodb.com/docs/atlas/online-archive/configure-online-archive-time-series.md [source]
- [low] For date-based archives, you must index the date field; an index sufficiency error occurs only if there are no indexes or compound indexes containing the date time field. Sources: https://www.mongodb.com/community/forums/t/sort-exceeded-memory-limit-of-104857600-bytes/269787 [source]
Facts and statements
- [low] The `ONLINE_ARCHIVE_INSUFFICIENT_INDEXES_CHECK` alert indicates an Online Archive Insufficient Indexes Alert, while `ONLINE_ARCHIVE_INSUFFICIENT_INDEXES_RESOLVED` indicates the alert is resolved. Sources: https://www.mongodb.com/docs/atlas/reference/atlas-alert-event-types.md [source]
Related concepts
- Index — is a part of Index Sufficiency Warning
- Sufficiency — is a part of Index Sufficiency Warning
- Warning — is a part of Index Sufficiency Warning
Children
- No children recorded.