8-4-5. 조인을 추가하자

-- [SQL-8-4-5-a]

SELECT  t1.*
FROM    startdbpg.tr_ord_big t1
WHERE   t1.ord_st = 'PKUP'
AND     t1.pkup_dtm >= '2024-02-01'::date
AND     t1.pkup_dtm <  '2024-02-02'::date;
SQL
복사

-- [SQL-8-4-5-b]

CREATE INDEX tr_ord_big_x27 ON startdbpg.tr_ord_big(ord_st, pkup_dtm);
SQL
복사

-- [SQL-8-4-5-c]

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

-- [SQL-8-4-5-d]

EXPLAIN (ANALYZE,BUFFERS,COSTS OFF)
SELECT  t1.*
FROM    startdbpg.cm_base_cd t0
        INNER JOIN startdbpg.tr_ord_big t1
            ON (t1.ord_st = t0.base_cd
            AND t0.base_cd_dv = 'ord_st')
WHERE   t1.pkup_dtm >= '2024-02-01'::date
AND     t1.pkup_dtm <  '2024-02-02'::date;
SQL
복사