[DOCS-6718] Clarify why certain prefix indexes are more performant Created: 03/Dec/15  Updated: 30/Oct/23  Resolved: 01/Nov/22

Status: Closed
Project: Documentation
Component/s: manual, Server
Affects Version/s: None
Fix Version/s: Server_Docs_20231030

Type: Bug Priority: Major - P3
Reporter: Docs Collector User (Inactive) Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: bite-sized
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Location: https://docs.mongodb.org/manual/tutorial/create-indexes-to-support-queries/#create-indexes-to-support-your-queries
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/47.0.2526.73 Safari/537.36
Referrer: https://docs.mongodb.org/manual/reference/indexes/
Screen Resolution: 1920 x 1200
repo: docs
source: tutorial/create-indexes-to-support-queries


Participants:
Days since reply: 1 year, 14 weeks, 1 day ago
Epic Link: DOCSP-1769
Story Points: 0.25

 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 }

"



 Comments   
Comment by Education Bot [ 01/Nov/22 ]

Hello! This ticket has been closed due to inactivity. If you believe this ticket is still important, please reopen it and leave a comment to explain why. Thank you!

Generated at Thu Feb 08 07:52:51 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.