-- [SQL-8-1-6-a]: [SQL-8-1-1-a]와 같은 SQL
EXPLAIN (ANALYZE,COSTS OFF)
SELECT /*+ Leading((t1 t2)) NestLoop(t1 t2) */
t1.mbr_id ,t1.nick_nm ,t2.ord_dtm ,t2.ord_amt
FROM startdbpg.ms_mbr_big t1
INNER JOIN startdbpg.tr_ord_big t2 ON (t2.mbr_id = t1.mbr_id)
WHERE t1.mbr_gd = 'PLAT'
AND t1.join_tp = 'INV'
AND t2.ord_dtm >= '2023-12-21'::date
AND t2.ord_dtm < '2023-12-26'::date;
SQL
복사
-- [SQL-8-1-6-b]
SELECT t1.shop_id ,t1.shop_nm ,t2.ord_no ,t2.ord_dtm ,t2.ord_amt
FROM startdbpg.ms_shop_big t1
INNER JOIN startdbpg.tr_ord_big t2
ON (t2.shop_id = t1.shop_id)
WHERE t1.shop_size >= 190
AND t1.shop_oper_tp = 'DRCT'
AND t2.ord_dtm = '2025-01-05 07:04:00'::timestamp;
SQL
복사