[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 |
Descriptionhttps://docs.mongodb.com/manual/core/index-intersection/ 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 changesImpact to Other DocsMVP (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: |
| Comment by Ian Whalen (Inactive) [ 07/Jan/21 ] |
|
Author: {'username': u'andf-mongodb', 'name': u'Joseph Dougherty', 'email': u'joseph.dougherty@mongodb.com'}Message: |
| Comment by Githook User [ 23/Dec/20 ] |
|
Author: {'name': 'Joseph Dougherty', 'email': 'joseph.dougherty@mongodb.com', 'username': 'jmd-mongo'}Message: |
| Comment by Githook User [ 23/Dec/20 ] |
|
Author: {'name': 'Joseph Dougherty', 'email': 'joseph.dougherty@mongodb.com', 'username': 'jmd-mongo'}Message: |
| Comment by Githook User [ 23/Dec/20 ] |
|
Author: {'name': 'Joseph Dougherty', 'email': 'joseph.dougherty@mongodb.com', 'username': 'jmd-mongo'}Message: |