[DOCS-9778] Comment on: "manual/core/query-optimization.txt" Created: 16/Jan/17  Updated: 30/Oct/23

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 Do Votes: 0
Labels: collector-298ba4e7, docs-triage
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Ubuntu 14.04 on Virtualbox on Windows

Location: https://docs.mongodb.com/v3.0/core/query-optimization/
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36
Referrer: https://docs.mongodb.com/manual/core/query-optimization/
Screen Resolution: 1920 x 1080


Participants:
Days since reply: 1 year, 14 weeks, 2 days ago
Epic Link: DOCSP-1769

 Description   

Covered queries:
I have noticed that in v3.0 a "find" query with a $in condition uses index only ("totalDocsExamined: 0" in explain() result), while a count query with the same conditions does not. Is this an undocumented limitation or just different optimization results for these 2 kinds of queries?



 Comments   
Comment by Education Bot [ 31/Oct/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:59:07 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.