-- [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
복사
-- [SQL-5-1-1-a]: [SQL-5-1-a]를 ord_st 조건만 사용해서 카운트
SELECT COUNT(*) cnt FROM startdbpg.tr_ord_big t1 WHERE t1.ord_st = 'PKUP';
SQL
복사
-- [SQL-5-1-1-b]: [SQL-5-1-a]를 카운트 SQL로 변경
SELECT COUNT(*) cnt
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
복사
