8-1-9. 조인 조건의 Index Cond 확인

-- [SQL-8-1-9-a] EXPLAIN (ANALYZE,BUFFERS,COSTS OFF) SELECT /*+ Leading((t1 t2)) NestLoop(t1 t2) IndexScan(t2 tr_ord_big_x24) */ 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_id = 'M00010' AND t2.ord_dtm >= '2023-12-21'::date AND t2.ord_dtm < '2023-12-26'::date;

-- [SQL-8-1-9-b]: [SQL-8-1-9-a]의 힌트 제거 EXPLAIN (ANALYZE,BUFFERS,COSTS OFF) SELECT 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_id = 'M00010' AND t2.ord_dtm >= '2023-12-21'::date AND t2.ord_dtm < '2023-12-26'::date;