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.
Read the full story at DatabaseJournal:
MongoDB 2.6 Improves Open-Source Database Performance
Sean Michael Kerner is a senior editor at InternetNews.com. Follow him on Twitter @TechJournalist.
