Performance issues for DBT3 queries #17, #18

Build tested: 5.5.2 (Drone build #1718)

Performed 10gb DBT3 performance on the build and noticed couple issues. #18 took 56 times longer to complete.

Query execution time:

5.5.1-1 Disk run
#17 30.388 sec
#18 14.922 sec

5.5.1-1 Cache run
#17 28.71 sec
#18 14.915 sec

5.5.2-1 Disk run
#17 50.439 sec
#18 833.523

5.5.2-1 Cache run
#17 50.436 sec
#18 834.642

Query #17
select
sum(l_extendedprice) / 7.0 as avg_yearly
from
lineitem lo,
part
where
p_partkey = l_partkey
and p_brand = 'Brand#15'
and p_container = 'LG BOX'
and l_quantity < (
select
0.2 * avg(l_quantity)
from
lineitem
where
l_partkey = lo.l_partkey
);

Query #18
select
c_name,
c_custkey,
o_orderkey,
o_orderdate,
o_totalprice,
sum(l_quantity)
from
customer,
orders,
lineitem
where
o_orderkey in (
select
l_orderkey
from
lineitem
group by
l_orderkey having
sum(l_quantity) > 313
)
and c_custkey = o_custkey
and o_orderkey = l_orderkey
group by
c_name,
c_custkey,
o_orderkey,
o_orderdate,
o_totalprice
order by
o_totalprice desc,
o_orderdate
LIMIT 100;