MongoDB Query Planner Presentation
Some months ago I started working at MongoDB as Technical Services Engineer. It was a big and exciting change for me after several years in the relational world of MySQL. During that time a large percentage of cases from customers were related to bad query plans/wrong index selection. With MongoDB I found that the number of cases on that topic was very very (very) low. So I asked myself... why?
To answer that question I investigated Query Planner's internals and documented everything in these slides.
Both databases approach this complex topic using very different methods. I don't personally think that one is better than the other. As usual, it depends on the different uses cases. But I also have to admit that I really love MongoDB's empirical approach that in practice works perfectly.
I hope you will find the subject interesting!