-- [SQL-3-1-3-a]
CREATE INDEX tr_ord_big_x01 ON startdbpg.tr_ord_big(ord_dtm);
SQL
복사
-- [SQL-3-1-3-b]: [SQL-3-1-2-a]와 동일한 SQL
EXPLAIN (ANALYZE,COSTS OFF)
SELECT t1.mbr_id ,count(*) cnt
FROM startdbpg.tr_ord_big t1
WHERE t1.ord_dtm >= '2022-01-03'::date
AND t1.ord_dtm < '2022-01-04'::date
GROUP BY t1.mbr_id;
SQL
복사