MongoDB 2.6 Improves Open-Source Database Performance
Page 1 of 1
Among the new features in MongoDB 2.6 is one called Index Intersection. Stirman said index intersection enables the query planner to use more than one index to resolve a query.
"With index intersection, developers can address more queries with simple indexes and with less upfront index design," Stirman said.
Stirman said that as an example, in a sales reporting application, a product manager might want to identify all customers who have ordered more than a given quantity of a specific part number. Using index intersection, the existing indexes for part number and quantity can be combined (intersected) to optimize the query, rather than requiring a separate compound index. This also results in reduced overhead to the working set size, and more efficient updates.