-- [SQL-6-3-1-a]
EXPLAIN (ANALYZE,BUFFERS,COSTS OFF)
SELECT t1.pay_tp ,SUM(t1.ord_amt) ord_amt_sum
FROM startdbpg.tr_ord_big t1
WHERE t1.shop_id = 'S100'
GROUP BY t1.pay_tp;
SQL
복사
-- [SQL-6-3-1-b]: enable_hashagg를 비활성화한 후 [SQL-6-3-1-a]를 재실행
SET enable_hashagg = OFF;
-- [SQL-6-3-1-a]
EXPLAIN (ANALYZE,BUFFERS,COSTS OFF)
SELECT t1.pay_tp ,SUM(t1.ord_amt) ord_amt_sum
FROM startdbpg.tr_ord_big t1
WHERE t1.shop_id = 'S100'
GROUP BY t1.pay_tp;
SQL
복사
-- [SQL-6-3-1-c]
SET enable_hashagg = ON;
SQL
복사
