5-3-5. 중복된 인덱스

-- [SQL-5-3-5-a]

EXPLAIN (ANALYZE,BUFFERS,COSTS OFF)
SELECT  t1.*
FROM    startdbpg.tr_ord_big t1
WHERE   t1.ord_dtm >= '2021-01-01'::date
AND     t1.ord_dtm <  '2021-01-03'::date;
SQL
복사

-- [SQL-5-3-5-b]

EXPLAIN (ANALYZE,BUFFERS,COSTS OFF)
SELECT  /*+ IndexScan(t1 tr_ord_big_x03) */ -- > 힌트 추가
        t1.*
FROM    startdbpg.tr_ord_big t1
WHERE   t1.ord_dtm >= '2021-01-01'::date
AND     t1.ord_dtm <  '2021-01-03'::date;
SQL
복사

-- [SQL-5-3-5-c]

SELECT  t1.*
FROM    startdbpg.tr_ord_big t1
WHERE   t1.ord_dtm >= '2021-01-01'::date
AND     t1.ord_dtm <  '2021-01-03'::date
AND     t1.mbr_id  =  'M02804';
SQL
복사