-- [CQ-4-5-1]
EXPLAIN (ANALYZE,COSTS OFF)
SELECT t1.*
FROM startdbpg.ms_mbr_big t1
WHERE t1.join_tp = 'SNS'
AND t1.mbr_id >= 'M00011'
AND t1.mbr_id <= 'M00020';
SQL
복사
-- [CQ-4-5-2]
-- [1번 SQL]
SELECT t1.*
FROM startdbpg.tr_event_entry_big t1
WHERE t1.entry_no BETWEEN 1 AND 10;
-- [2번 SQL]
SELECT t1.entry_dtm ,t1.entry_no
FROM startdbpg.tr_event_entry_big t1
WHERE t1.entry_dtm >= '2022-07-01'::date
AND t1.entry_dtm < '2022-08-01'::date;
SQL
복사
-- [CQ-4-5-3]
CREATE INDEX x01 ON startdbpg.tr_event_entry_big (entry_dtm);
EXPLAIN (ANALYZE,COSTS OFF)
SELECT /*+ IndexOnlyScan(t1) */
t1.entry_dtm
FROM startdbpg.tr_event_entry_big t1
WHERE TO_CHAR(t1.entry_dtm,'YYYYMM') = '202208';
SQL
복사