-
Type:
Improvement
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
Query Optimization
-
None
-
None
-
None
-
None
-
None
-
None
-
None
In order to figure out if the winning plan is optimal, we need to obtain the actual cardinality of any of the sub-joins.
One way to do this is to reconstruct the sub-join from of its portion of the explain() and run it.