MongoDB Compound Index and Indexing

[@IdanBernard]

Great video, thank you so much!

[@Cognitive-Programmer]

Thanks a lot for your comment 🙏

[@msbasera]

Great Explaination Sir ❤️

[@Cognitive-Programmer]

Thank you so much for your comment 🙏

[@shreyashachoudhary480]

Loved it

[@Cognitive-Programmer]

Thank you 🙏

[@lalitbelwal7231]

easy explaination

[@Cognitive-Programmer]

Thanks for your comment 🙏

[@monireol]

Thanks a lot

[@Cognitive-Programmer]

Thanks for your comment 🙏

[@Pixelflames1]

I'm so exited but i still have no idea how to implement it in my code or on my mongodb server through the terminal

[@nizarbouali5837]

Thanks !!

[@Cognitive-Programmer]

Thanks for your comment 🙏

[@komalsingla6032]

Sir, thank you for sharing this tutorial video. I need to ask one question -- There is one use case as how to modify index because migrating all data impacts performance. Please suggest some solutions.

[@Cognitive-Programmer]

Thanks for your comment. I don't think I understood your question but let me try. You indexes are dynamic, every time you insert a new data, your index is modified to accommodate the fast search. Hope it helps Thank 🙏

[@Pray4Tony]

Thank you

[@Cognitive-Programmer]

Thanks 🙏

[@lalitbelwal7231]

is there any video on composite indexing in case size is exceeding

[@Cognitive-Programmer]

No not yet on my channel..but I intend to talk more on topic of index in upcoming videos.. sorry about that 👍

[@lalitbelwal7231]

@@Cognitive-Programmer no problem I will be happy to see that in future as I am stuck already in that soup.

[@funnyclipz520]

awesome explanation... can you share the mongodump in the description?

[@Cognitive-Programmer]

Thanks for your comment 🙏

[@arbazahmed7748]

Amazing, Sir I have a question which is confusing me a lot. I hope you'll fix it for sure... I have a collection with 30M documents. each document contains 4 keys and 4 values like (Bill_id, Amount, City, Tel). How should I create indexes ? Should I use 4(square) indexes? like 36 indexes ?

[@fanzhang8823]

Just put keys and sorted field(s) into compound index, put exact march field(s) at first, then sorted filed(s) and ranch match field(s) into the index

[@techshortstamil5573]

Great video! Using mongoimport we have a param specifying the numinsertionworker for parallel insertion do we have a similar param in pymongo, if not do you suggest any ways that we could achieve parallel insertion using python?

[@MahenderPratapSingh-c6f]

hi, i have a question how can i used both direction sorting in compound index for example : i have compound index "active_1_name_1__id_1", name is used for sorting , i want to used name for ascending sorting as well as descending sorting

[@reyanshspeak2847]

How to specify two custom indexes on two different fields in the compound autocompleted query?

[@Vijay-Yarramsetty]

audio quality is good in this video

[@Cognitive-Programmer]

Thank you 🙏

[@prasadshivan79]

Hello Sir, Is it possible to get indexStats using pymongo?

[@thirumurugand9287]

Most of the time 'FETCH' step execution time will be ~0. Shouldn't we look at Actual query execution time to see performance benefit after applying the indexes ?

[@Cognitive-Programmer]

Hi Thanks for your comment Yes, to properly evaluate the performance, it needs to be checked with large dataset

[@monireol]

Limit is 64

[@Cognitive-Programmer]

Thanks for your comment 🙏

[@sujith5441]

Compound Index size seems very large

[@iampiyush100]

Supposed if our document on 10th place they why mongodb search 10000 documents?

[@Cognitive-Programmer]

Thanks for your comment MongoDB doesn’t know if the document at the 10th place is the only document matching the criteria.. so it needs to search Hope it clarifies your question Thanks again 🙏