-
Type: Improvement
-
Resolution: Unresolved
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Index Maintenance
-
None
-
Query Optimization
Indexes for bitwise operations currently are not supported and the documentation for Bitwise Query Operators contains this information.
Support for this capability is not a trivial task, and currently, it is not on the short-term roadmap.
We understand that this feature is very desirable and appreciate votes and comments from the community.
MongoDB Developer Community Forum is a good place to discuss this problem. Also, here is an interesting article with some useful information about potential optimizations.
Original description
Creating this issue to include support use of indexes on Bitwise query operations. As mentioned by Ramon Fernandez in SERVER-3518
User Case:
We are heavily using Bitwise query operators to pull count out of collection of 40 million records. Query performance as expected but CPU spikes when queries are running.
- related to
-
SERVER-3518 Bitwise query operators
- Closed