Re: 문제81. (오늘의 마지막 문제) 아래의 SQL을 해쉬 세미 조인이 되게 튜닝하시오

[19기_이승원]

select count(*) from customers200; -- 55,500
select count(*) from sales200
 where amount_sold between 1 and 10000;--918,843

 select count(*)
 from customers200
  where cust_id in (select /*+ unnest push_subq
                           swap_join_inputs(customers200)*/
                          cust_id
                      from sales200
                       where amount_sold between 1 and 10000);     
select * from  table(dbms_xplan.display_cursor(null, null, 'ALLSTATS LAST'));