-- [SQL-5-4-5-1-a]: [SQL-5-3-1-a]와 동일
EXPLAIN (ANALYZE,BUFFERS,COSTS OFF)
SELECT t1.mbr_id
FROM startdbpg.ms_mbr_big t1
WHERE LOWER(t1.mbr_id) = 'm00010';
SQL
복사
-- [SQL-5-4-5-1-b]: 인덱스 생성 후 [SQL-5-4-5-1-a]를 재실행
CREATE INDEX ms_mbr_big_fx01 ON startdbpg.ms_mbr_big(LOWER(mbr_id));
-- [SQL-5-4-5-1-a]
EXPLAIN (ANALYZE,BUFFERS,COSTS OFF)
SELECT t1.mbr_id
FROM startdbpg.ms_mbr_big t1
WHERE LOWER(t1.mbr_id) = 'm00010';
SQL
복사
-- [SQL-5-4-5-2-a]
EXPLAIN (ANALYZE,BUFFERS,COSTS OFF)
SELECT t1.*
FROM startdbpg.tr_ord_big t1
WHERE TO_CHAR(t1.ord_dtm,'YYYY-MM-DD') = '2023-04-01';
SQL
복사
-- [SQL-5-4-5-2-b]
CREATE INDEX tr_ord_big_fx01 ON startdbpg.tr_ord_big(TO_CHAR(ord_dtm,'YYYY-MM-DD'));
SQL
복사