MongoDB Compound Index and Indexing

[@IdanBernard]

Great video, thank you so much!

[@Cognitive-Programmer]

Thanks a lot 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

[@lalitbelwal7231]

easy explaination

[@Cognitive-Programmer]

Thanks for your comment 🙏

[@msbasera]

Great Explaination Sir ❤️

[@Cognitive-Programmer]

Thank you so much for your comment 🙏

[@shreyashachoudhary480]

Loved it

[@Cognitive-Programmer]

Thank you 🙏

[@Pray4Tony]

Thank you

[@Cognitive-Programmer]

Thanks 🙏

[@Vijay-Yarramsetty]

audio quality is good in this video

[@Cognitive-Programmer]

Thank you 🙏

[@monireol]

Thanks a lot

[@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 🙏

[@nizarbouali5837]

Thanks !!

[@Cognitive-Programmer]

Thanks for your comment 🙏

[@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

[@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

[@reyanshspeak2847]

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

[@funnyclipz520]

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

[@Cognitive-Programmer]

Thanks for your comment 🙏

[@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?

[@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.

[@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

[@prasadshivan79]

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

[@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 🙏

[@monireol]

Limit is 64

[@Cognitive-Programmer]

Thanks for your comment 🙏