MongoDB Indexes - The Recipe behind Fast Query - How to Create Indexes and the B-Tree Data Structure

Welcome to the MongoDB Video Series. In this video, I'm talking about MongoDB indexes. Indexes drastically impacts the performance of MongoDB especially the search queries

It's highly unlikely that you can use MongoDB in production without MongoDB indexes

In this video, I've created our own data and then apply mongodb indexes into them to see the performance difference.

Not only that, I've also visually explained the B-Tree data structures which is used while creating MongoDB index

Hope it help you to learn something new. Thanks for tuning in and watching

#Mongodb #NoSQL #database

About Me i.e. An Insightful Techie

Greetings and Thanks a lot for checking out my YouTube Channel. I’m Deepak K Gupta (Daksh). This channel is a medium for me to share my learnings and journey as a Techie so that you not only learn from my experience but also from my mistakes

As a techie I am closely associated with software development, so most of my content will revolve around Programming Languages, AI, Machine learning and Databases. I share things which will help you learn, remember and use these things in an effective and efficient way.

As a Techie, I also know that there is a life beyond software development and it has a profound impact on our career as well as on our well being. I also share those learnings which I feel are worth sharing with the intention that it MAY help you in taking better decisions in your life.

Last but not the least, I'm a traveler and explorer by nature. I would like to take you with me on some of the interesting journeys around the world. Believe me there is more to learn outdoors than indoors

Hope you’ll like my contents and will be part of my journey 🙏

[harshvardhanpurohit]

I have an interview coming up and I needed someone to summarize indexing in Mongo for me and you've done it so concisely and smoothly ! Thank you so much for this. Even though your video is on the top of my searches I'm not sure why the views are less !!! :( Anyways keep posting great videos like this :)

[hackingguy]

Such a elegant explanation, Sir! I think you deserve more views, Try increasing camera and thumbnail quality, It will help you a lot!

[akashpundir]

That was a beautiful explanation of Indexes! Don't know why so less views, it's better than other videos on indexes.

[ryanaiden]

Good Sir you are an excellent teacher. Well done on this superb explanation.
“Isn’t it cool?”
Yes it is very cool!
Thanks you for the video.

[ShahanaBasheer]

Excellent video...❤ fully understandable❤ thank you so much😊

[piyalibanik]

Wow wonderfully explained... in simple clear language... thanks a lot 🙏

[alijunaid]

beautifully explained sir! you are a great teacher, where ever you are you deserve a raise, best wishes from Pakistan

[mdjawedalam]

great explanation sir thanks may allah bless you

[padmakarkasture]

explanation with live example ..so nice thanks

[rishabhanda]

Concept is explained beautifully in great detail. Thanks for sharing knowledge

[anandagarwal]

best video till date related to indexes . thanks a lot

[gowth_am_m]

I am really appreciate your work and explanation.👏

[williamlopez]

Thank you Sir, your video help me a lot 👍

[exe.mdnght]

Thank you Sir you are a Great Master !

[dzlandis]

This is a great explanation which is super helpful! Thank you :)

[keerthi]

When the collection is indexed on "salary" and you query for a specific salary, how come "index keys examined" is always 1. Will there not be an index scan examining "some" of the index keys until the required salary is found? I would expect "index keys examined" to be > 1 for some of the case. But it never is. Why? How does MongoDB get to a specific salary in just 1 lookup?

Even in your example at 16:23, MongoDB would have examined 3 index keys to get to salary 3 (as opposed to 1 as claimed by Explain Plan).

[TheMeepPlay]

Excelent video! thanks so much for the explanation.