Uploaded image for project: 'Compass '
  1. Compass
  2. COMPASS-4675

Text index is ignored if run explain plan for a query covered by an index

    XMLWordPrintableJSON

Details

    • Icon: Bug Bug
    • Resolution: Declined
    • Icon: Major - P3 Major - P3
    • 1.26.0
    • 1.26.0
    • Explain
    • None
    • Not Needed

    Description

      Problem Description

      Steps to Reproduce

      1. Open any collection
      2. Go to Indexes tab
      3. Create text index on any string field
      4. Go to the Explain Plan tab
      5. Write some query that uses field with just created index on it
      6. click Explain

      Expected Results

      "Index Keys Examined:<number of documents>"

       "Query used the following index: <text index name>

      Actual Results

      "Index Keys Examined:0"

      "No index available for this query." is displayed 

      Attachments

        Activity

          People

            Unassigned Unassigned
            olena.protsiuk@mongodb.com Olena Protsiuk (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: