Mongo atlas indexing

36 views

Skip to first unread message

Jithin KV

unread,

Feb 5, 2018, 6:07:51 AM2/5/18

to mongodb-user

Hi,

I'm using mongo atlas for my app. and i need to do indexing for the same. using create index i have made some sample combination. but i want to kow whether i need to specify indexing name while query. I'm using node strongloop as frame work.

Wan Bachtiar

unread,

Feb 5, 2018, 7:34:06 PM2/5/18

to mongodb-user

but i want to kow whether i need to specify indexing name while query.

Hi Jithin,

Generally with the correct indexes in place, you should not need to specify an index to use while querying.
I would recommend to read MongoDB Explain Results, the cursor.explain() method returns information on query plans and execution statistics of the query plans. It’s a great way to analyse your queries performance.
You may also find MongoDB Indexes a useful resource.

Depending on your MongoDB Atlas instances, instance size M10 and above also comes with MongoDB Performance Advisor. It monitors queries that MongoDB considers slow and suggests new indexes to improve query performance.
See also Blog: Improving MongoDB Performance with Automatically Generated Index Suggestions