-
Type:
Improvement
-
Resolution: Unresolved
-
Priority:
Minor - P4
-
Affects Version/s: None
-
Component/s: Querying
-
Labels:
-
Query Optimization
In the absence of a fix for SERVER-15168 (now tracked as SERVER-8045), it would be useful to output a warning when a query is issued which uses $min but not $max, or vice-versa. This is because such usage can often have deleterious performance, and is contrary to the intended usage of $min/$max (see DOCS-4015).
Since the main in-server usage of $min/$max is for sharding, and always specifies both $min and $max, the warning would only occur with user queries that only specify either $min or $max (but not both).
- is related to
-
SERVER-40873 Poor performance on certain configurations of hint/limit/min/max
-
- Closed
-
- related to
-
DOCS-4015 Document performance impacts of $min without $max (and vice-versa)
-
- Closed
-
-
-
- Closed
-