Index Usage for Nested Logical Queries - Tess Avitabile

June 29, 2017

Tess Avitabile, Software Engineer, MongoDB

Have you had a case of the horrible ORs? Indexing nested logical queries (ORs inside of ANDs) is traditionally a challenge for databases. In most databases, it's on the user to ensure their queries are structured in a way that the database can find an indexed solution. In MongoDB 3.6, we recognize more nested logical queries that can utilize indexes.

Theoretical computer scientist and query team engineer Tess Avitabile takes you behind the scenes to the MongoDB query planner. By knowing the internals, you will develop an intuitive understanding for when a nested logical query will have an indexed solution. You will also see how we can now index more nested logical queries by manipulating the tree structure of queries.

 

Previous Video
Scaling MongoDB to a Million Collections - Michael Cahill
Scaling MongoDB to a Million Collections - Michael Cahill

Next Video
New Features in MongoDB Atlas - Cory Mintz
New Features in MongoDB Atlas - Cory Mintz