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

Clarify why certain prefix indexes are more performant

    XMLWordPrintableJSON

Details

    Description

      URL: https://docs.mongodb.org/manual/tutorial/create-indexes-to-support-queries/#create-indexes-to-support-your-queries

      Could you provide a further explanation on the following texts in Documentation? Thanks!

      "There are some situations where the prefix indexes may offer better query performance: for example if z is a large array.

      The

      { x: 1, y: 1, z: 1 }

      index can also support many of the same queries as the following index:

      { x: 1, z: 1 }

      "

      Attachments

        Activity

          People

            Unassigned Unassigned
            xgen-internal-docs Docs Collector User (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              1 year, 14 weeks, 1 day ago