-
Type:
Improvement
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
Query Optimization
-
None
-
None
-
None
-
None
-
None
-
None
-
None
SERVER-112338 produces INLJ plans with the first eligible index which has a prefix on the equijoin fields. This algorithm has two problems:
- It is not deterministic if the order of indexes in the catalog changes
- It may pick a suboptimal index (larger than required)
In this ticket, we should use a heuristic to pick the smallest index (fewest number of components) to satisfy the INLJ. In the case where two indexes have the same number of components, we should pick one deterministically.
- is related to
-
SERVER-112338 Produce Indexed Nested Loop Join plans from random reorderer when possible
-
- Closed
-