MongoDB - Indexing Limitations
MongoDB - Indexing Limitations we will learn about Indexing Limitations and its other components.
Extra OverheadEvery index occupies some space as well as causes an overhead on each insert, update and delete.So if you rarely use your collection for read operations, it makes sense not to use indexes.
RAM UsageSince indexes are stored in RAM, you should make sure that the total size of the index does not exceed the RAM limit. If the total size increases the RAM size
- Regular expressions or negation operators like $nin, $not, etc.
- Arithmetic operators like $mod, etc.
- $where clause
Index Key LimitsStarting from version 2.6, MongoDB will not create an index if the value of existing index field exceeds the index key limit.
Inserting Documents Exceeding Index Key LimitMongoDB will not insert any document into an indexed collection if the indexed field value of this document exceeds the index key limit.
- A collection cannot have more than 64 indexes.
- The length of the index name cannot be longer than 125 characters.
- A compound index can have maximum 31 fields indexed.