Details
-
Improvement
-
Resolution: Unresolved
-
Major
-
Goldfish GA
-
0
-
Analytics Sprint 40, Analytics Sprint 41, Analytics Sprint 42
Description
We were picking an NL join incorrectly for this query. The NL is a lot slower than a HJ.
select sum(l.l_extendedprice * (1 - l.l_discount)) as revenue
|
from orders o, lineitem l
|
where l.l_orderkey = o.o_orderkey
|
and o.o_orderdate >= '1993-01-01' and o.o_orderdate < '1994-01-01';
|