mongodb索引

MongoDB indexes use a B-tree data structure.
索引不能重新命名，只能删除重建
查看索引
db.collection.getIndexes()
b-tree与b+tree区别？

单列索引

db.products.createIndex(
  { item: 1, quantity: -1 } ,
  { name: "query for inventory" }
)
Multikey Index
MongoDB uses multikey indexes to index the content stored in arrays. If you index a field that holds an array value, MongoDB creates separate index entries for every element of the array. These multikey indexes allow queries to select documents that contain arrays by matching on element or elements of the arrays. MongoDB automatically determines whether to create a multikey index if the indexed field contains an array value; you do not need to explicitly specify the multikey type.

TTL indexes are special indexes that MongoDB can use to automatically remove documents from a collection after a certain amount of time. This is ideal for certain types of information like machine generated event data, logs, and session information that only need to persist in a database for a finite amount of time.
索引上不通的collation,不能进行字符串的对比

对现有的数据大表建立索引的时候，采用后台运行方式
在对数据集合建立索引的过程中，数据库会停止该集合的所有读写操作，因此如果建立索引的数据量大，建立过程慢的情况下，建议采用后台运行的方式，避免影响正常业务流程。

db.test.ensureIndex({“username”:1,“age”:-1},{“background”:true}) #默认情况下background是false。

mongodb为什么用b-tree mysql为什么用b+tree
参考： https://www.cnblogs.com/kaleidoscope/p/9481991.html
————————————————
版权声明：本文为CSDN博主「小月盟盟」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/u012939368/article/details/76696673