[SERVER-38051] Add warning/check mechanism to explain() output for old indexes and multikey Created: 09/Nov/18  Updated: 06/Dec/22  Resolved: 05/Jan/21

Status: Closed
Project: Core Server
Component/s: Querying
Affects Version/s: None
Fix Version/s: None

Type: Improvement Priority: Minor - P4
Reporter: Nic Cottrell Assignee: Backlog - Query Execution
Resolution: Won't Do Votes: 1
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
is related to DOCS-11033 Rebuild index for Multikey path track... Closed
Assigned Teams:
Query Execution
Participants:
Case:

 Description   

I've seen many cases of updating from 3.2 and hitting SERVER-15086. It's not obvious to look for a missing multiKeyPaths field in the output of explain()

It would be great if explain() could include some heuristic checks (similar to startupWarnings in mongod) which look for common problems are report them in the output as warnings. Something like "Winning index needs to be rebuilt to benefit from SERVER-15086" would be great. 


Generated at Thu Feb 08 04:47:49 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.