一些索引的限制
来源:互联网 发布:淘宝开的店铺怎么关闭 编辑:程序博客网 时间:2024/05/16 14:22
Extra Overhead:
Every 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 Usage:
Since 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, it will start deleting some indexes and hence causing performance loss.
Query Limitations:
Indexing can't be used in queries which use:
- Regular expressions or negation operators like $nin, $not, etc.
- Arithmetic operators like $mod, etc.
- $where clause
Hence, it is always advisable to check the index usage for your queries.
Index Key Limits:
Starting 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 Limit:
MongoDB will not insert any document into an indexed collection if the indexed field value of this document exceeds the index key limit. Same is the case with mongorestore and mongoimport utilities.
Maximum Ranges:
- 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
- 一些索引的限制
- mysql索引长度的一些限制
- mysql索引的限制
- mysql--索引的限制
- Mysql的一些限制
- win64的一些限制
- Mysql的一些限制
- 代码的一些限制
- 对索引视图的限制
- MySQL中索引的限制
- 限制索引
- 一些有用的索引
- 索引的一些总结
- 索引的一些总结
- 索引的一些总结
- 索引的一些总结
- 索引的一些注意事项
- 索引的一些知识
- 原串翻转
- HDOJ 2036 求多边形面积
- 1001. A+B Format (20)
- Hibernate getCurrentSession() 方法的细节
- 金融系统中PBOC/EMV的TLV的算法实现(含C++/C#)
- 一些索引的限制
- 页面置换算法
- 将110号员工的工资修改为其所在部门的平均工资多100元
- iOS 中获得键盘的弹出和隐藏
- 第4周—项目3.(3)单链表递增
- 安卓控件使用系列18:DatePicker日期控件和TimePicker时间控件的使用
- uva 11354 bond 倍增
- UVALive 4119 Always an integer(差分数列+模拟)
- 1002