Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-24749

Add index support for Bitwise query operations

    • Type: Icon: Improvement Improvement
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: Index Maintenance
    • Labels:
    • Query Optimization

      Issue Status as of Feb 11, 2020: Future Consideration

      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.

            25 Vote for this issue
            38 Start watching this issue