What is indexing in MongoDB :
Hello Everyone so basically index is a part of data structure that helps to find or search data from the collection in the very efficient way. With help of MongoDB indexing find the data with help of match query without performing whole collection scan. If a collection is well indexed then MongoDB use the index to fetch the data very fast because it uses an index and limit no. of data that examine so it’s faster than examine whole collection data.
MongoDB Indexing Types :
indexing in MongoDB has many types that help to execute data in an efficient way and optimize your query as well.
1. Single field index
2. Compound index
3. Multikey index
4. Geo index
5. Covered index
6. Hashed index
How to Create, Delete and Get index :
Simply run this command in your Mongo shell to create indexes
|
1 |
Db.collection.createIndex({type : 1}) |
• Collection means your collection name
• Type means you filed name that you want to index
• 1 for ascending order and -1 for descending order
How to Delete indexes –
|
1 2 |
Db.collection.dropIndexes({type : 1}) For particular index delete Db.collection.dropIndexes() Delete All indexes |
How to Get All indexes –
|
1 |
Db.collection.getIndexes() |
Index Properties are-
Indexing has many properties like-
• Unique – It makes that field Unique that helps MongoDB to reject duplicate field of the collection. Just pass this during index creation.
|
1 |
Db.collection.createIndex({type : 1},{unique:true}) |
• Sparse – it is the very useful property of index because it ensures that the index only takes that data that have indexed field and do not take data that have no indexed. Just pass this during index creation
|
1 |
Db.collection.createIndex({type: 1},{ sparse:true}) |
• Partial – it is similar like sparse but in partial we just make a filter condition, so if the data will match this filter index condition then it will take if not then simply index ignore this indexed field.
Key Point To Remember :
• Mongo DB uses only one index at a time if you have more than one field in your query then you have to use compound index instead of the single index also compound index matters with ordering so the order of query filed same as compound index field order then it works perfectly.
Also, MongoDB optimizes best index that is suitable for the query so you have to not worry about this it will take the best index that matches the query.
For example –
If This is your query
|
1 |
Db.find({_id:101,”type”:”user”}) |
Then both indexes not were using for finding data
|
1 2 |
Db.createIndex({_id:1}) Db.createIndex({type:1} |
So only compound index will use for finding the data fast
|
1 |
Db.createIndex({_id:1,type:1}) |
• Indexing was fast the data searching but it will slow the Insert/Update/Delete so indexing fast the writing process and slow the Read process
• If you using sorting in your query to sort data then it affects to your query and also slows the query process so it takes more time.
Just use the sorting filed in your index at last then it will optimize your query very effective like this-
|
1 2 |
Db.createIndex({_id:1,type:1,date:-1}) Db.find({_id:101,”type”:”user”}).sort({date:-1}) |
• Use explain in your query to ensure that indexed is applied properly in winning plan
|
1 |
Db.find({_id:101,”type”:”user”}).sort({date:-1}).explain(true) |
I hope this article will help you to understand the fast process of MongoDB and how it optimizes the search query with Index.
If you have any query related to Indexing in MongoDB then ask in a comment.
Hope you like this post, so don’t forget to share with friends on Facebook.
