How Indexing improve query performance in mongodb

Question

I need to know abt how indexing in mongo improve query performance. And currently my db is not indexed. How can i index an existing DB.? Also is i need to create a new field only for indexing.?.

Mark Hillick · Accepted Answer · 2012-10-17 13:37:12Z

2

Fundamentally, indexes in MongoDB are similar to indexes in other database systems. MongoDB supports indexes on any field or sub-field contained in documents within a MongoDB collection.

Indexes are covered in detail here and I highly recommend reading this documentation.

There are sections on indexing operations, strategies and creation options as well as a detailed explanations on the various indexes such as compound indexes (i.e. an index on multiple fields).

One thing to note is that by default, creating an index is a blocking operation. Creating an index is as simple as:

db.collection.ensureIndex( { zip: 1})

Something like this will be returned, indicating the index was correctly inserted:

Inserted 1 record(s) in 7ms

Building an index on a large collection of data, the operation can take a long time to complete. To resolve this issue, the background option can allow you to continue to use your mongod instance during the index build.

Limitations on indexing in MongoDB is covered here.

edited Oct 17, 2012 at 13:37

answered Oct 17, 2012 at 13:31

Mark Hillick

6,9831 gold badge21 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mohammed shebin Over a year ago

Thank u.. I need further information about how can i add a new field to every document in a collection which i can use it for only indexing..?.

Collectives™ on Stack Overflow

How Indexing improve query performance in mongodb

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related