MongoDB: Indexing - Create, Update, Delete and Analyze MongoDb Indexes

basic-mongo-queries.js

//show databases 
show dbs 

//Use Database test
use test

// show collections from the database 
show collections

// show counts of records in collection 
db.employee.count()

//find all 
db.employee.find({})      // it only show first page of data 

//find with query matching 
db.employee.find({name: "Dipak"})

// count with query matching 
db.employee.count({name: "Dipak"})

//count with find 
db.employee.find({name: "Dipak"}).count()

//Query planner of the query
db.employee.find({name: "Dipak"}).explain()

// Query planner as well execution status of the query 
db.employee.find({name: "Dipak"}).explain("executionStats")

mongo-manage-indexes.js

//show indexes on collection 
db.employee.getIndexes()

//create single key index 
db.employee.createIndex({name: 1})
db.employee.createIndex({department: 1})

// create index  in desc order 
db.employee.createIndex({department: -1})

//create index with name 
db.employee.createIndex({department: 1}, {name: "dept_index"})


// create index in background 
db.employee.createIndex({department: 1}, { background: true })

// create multi key index 
db.employee.createIndex({name:1, department:1})



// drop specific index
db.employee.dropIndex("dept_index")

// drop all indexes 
db.employee.dropIndexes()


// Modify index 
// Drop existing index and create new index again