mongodb 批量添加索引, 已test开头的集合

发布时间 2023-04-13 12:36:02作者: AngDH

 

 

 

 

 

// To add an index to all collections in the database that start with "test" and have a field named "ts", and to run the operation in the background, use the following command:

db.getCollectionNames().forEach(function(collname) {
  if (collname.startsWith("test")) {
    db.getCollection(collname).createIndex({ts: 1}, {background: true});
  }
});