Uploaded image for project: 'Documentation'
  1. Documentation
  2. DOCS-10322

Clarify eligibility of compound indexes that contain geospatial and text indexes

      Our documentation for Sparse Indexes contains the following:

      sparse Index and Incomplete Results

      If a sparse index would result in an incomplete result set for queries and sort operations, MongoDB will not use that index unless a hint() explicitly specifies the index.

      Geospatial and text indexes are sparse by definition and are documented as such (eg: here). While it can be concluded from that documentation that there are associated eligibility considerations, it is not nearly as clear as what is described in the Sparse Index documentation above.

      This can be problematic since these indexes can also be compound. In multiple places in the documentation we highlight the benefits of constructing indexes in such a way that their prefix ordering supports multiple query shapes (eg here and here. The sparse nature of these indexes adds additional constraints when designing them. The documentation should more clearly highlight these considerations.

            Assignee:
            dave.cuthbert@mongodb.com Dave Cuthbert (Inactive)
            Reporter:
            christopher.harris@mongodb.com Chris Harris
            Votes:
            5 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved:
              1 year, 25 weeks, 4 days ago