-
Type:
Improvement
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
Query Optimization
-
None
-
None
-
None
-
None
-
None
-
None
-
None
The script should answer questions like:
- Are the winning plans of two runs of the same query identical?
- If multiplanner picks a different plan from cost-based ranker, 1) What is the cost estimate for the plan that multiplanner picked? 2) What is the number of works for the plan that cost-based ranker thinks is better?
- Are the winning plans of two runs of the same query performance-wise equivalent (e.g. {a: 1} using index {a: 1} or {a:1, b: 1})?
It would be nice if the script would also display explanations in a easier-to-compare form.