-- [SQL-8-2-2-a]: x25 인덱스 생성 후 [SQL-8-2-1-a]를 재실행
CREATE INDEX tr_ord_big_x25 ON startdbpg.tr_ord_big(shop_id, mbr_id);
-- [SQL-8-2-1-a]
EXPLAIN (ANALYZE,COSTS OFF)
SELECT /*+ MergeJoin(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 t2.shop_id = 'S025';
SQL
복사