Tuesday, November 15, 2016

Indexing

Indexing
========

Sample query ->

db.users.find({"age":{$lt:23}})


Execution plan ->

db.users.find({"age":{$lt:23}}).explain("executionStats")

Create Index on Age ->

db.users.ensureIndex({"age":1})


List index ->

db.users.getIndexes()

Drop index ->

db.users.dropIndex({"age":1})

No comments:

Post a Comment