Index Usage for Nested Logical Queries
Speaker:
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.