-- [SQL-5-1-4-a]: [SQL-5-1-a]의 조건 컬럼별로 각각 카운트 수행
SELECT COUNT(*) cnt FROM startdbpg.tr_ord_big t1 WHERE t1.ord_st = 'PKUP'; -- 26,291,052건
SELECT COUNT(*) cnt FROM startdbpg.tr_ord_big t1 WHERE t1.shop_id = 'S281'; -- 16,128건
SELECT COUNT(*) cnt
FROM startdbpg.tr_ord_big t1
WHERE t1.pkup_dtm >= TO_DATE('20221101','YYYYMMDD')
AND t1.pkup_dtm < TO_DATE('20221201','YYYYMMDD'); -- 615,348건
SQL
복사
-- [SQL-5-1-4-b]
CREATE INDEX tr_ord_big_x02 ON startdbpg.tr_ord_big(shop_id);
-- [SQL-5-1-a]를 재실행
EXPLAIN (ANALYZE,COSTS OFF)
SELECT t1.*
FROM startdbpg.tr_ord_big t1
WHERE t1.ord_st = 'PKUP'
AND t1.shop_id = 'S281'
AND t1.pkup_dtm >= '2022-11-01'::date
AND t1.pkup_dtm < '2022-12-01'::date;
SQL
복사
