Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
0.10.0
-
None
-
Reviewed
Description
If two tables are joined on columns with different names, the sort merge join optimization is not applied. E.g.
SELECT /*+ MAPJOIN(b) */ * FROM t1 a JOIN t2 b ON a.key = b.value;
This will not use sort merge join even if t1 and t2 are bucketed and sorted by key, value respectively.