[DOCS-14049] Investigate index behavior on index intersection page Created: 11/Dec/20  Updated: 30/Oct/23  Due: 25/Dec/20  Resolved: 23/Dec/20

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

Type: Task Priority: Major - P3
Reporter: Paramjeet Desai Assignee: Joseph Dougherty
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Participants:
Days since reply: 3 years, 2 weeks, 2 days ago
Epic Link: DOCSP-11701
Story Points: 3

 Description   

Description

https://docs.mongodb.com/manual/core/index-intersection/
The above documentation mention

db.orders.find( { qty:

{ $gt: 10 }

} ).sort(

{ status: 1 }

) query won't use any of the indexes. But on checking with the same example we found out that it uses the index {qty:1}

Please check the code or the documentation

Scope of changes

Impact to Other Docs

MVP (Work and Date)

Resources (Scope or Design Docs, Invision, etc.)



 Comments   
Comment by Githook User [ 25/Jan/21 ]

Author:

{'name': 'Joseph Dougherty', 'email': 'joseph.dougherty@mongodb.com', 'username': 'jmd-mongo'}

Message: DOCS-14049 "Index Intersection and Sort" clarification
Branch: v4.2.12
https://github.com/mongodb/docs/commit/1c237ab561d18d42e1a6c13e2c3c84f5518ff288

Comment by Ian Whalen (Inactive) [ 07/Jan/21 ]

Author:

{'username': u'andf-mongodb', 'name': u'Joseph Dougherty', 'email': u'joseph.dougherty@mongodb.com'}

Message:DOCS-14049 "Index Intersection and Sort" clarification
Branch:master
https://github.com/mongodb/docs/commit/7a0663643293ae0042b118e8695e67338b2b832e

Comment by Githook User [ 23/Dec/20 ]

Author:

{'name': 'Joseph Dougherty', 'email': 'joseph.dougherty@mongodb.com', 'username': 'jmd-mongo'}

Message: DOCS-14049 "Index Intersection and Sort" clarification
Branch: v3.6
https://github.com/mongodb/docs/commit/918733762aa43f85efa824308e2505d67b9e42dd

Comment by Githook User [ 23/Dec/20 ]

Author:

{'name': 'Joseph Dougherty', 'email': 'joseph.dougherty@mongodb.com', 'username': 'jmd-mongo'}

Message: DOCS-14049 "Index Intersection and Sort" clarification
Branch: v4.0
https://github.com/mongodb/docs/commit/f1f1855e824a31d09e76f81a91fb4f27b79676a7

Comment by Githook User [ 23/Dec/20 ]

Author:

{'name': 'Joseph Dougherty', 'email': 'joseph.dougherty@mongodb.com', 'username': 'jmd-mongo'}

Message: DOCS-14049 "Index Intersection and Sort" clarification
Branch: v4.2
https://github.com/mongodb/docs/commit/1c237ab561d18d42e1a6c13e2c3c84f5518ff288

Generated at Thu Feb 08 08:09:22 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.