5-3-7. LIKE 패턴과 인덱스

-- [SQL-5-3-7-a]

EXPLAIN (ANALYZE,COSTS OFF)
SELECT  t1.mbr_id ,t1.nick_nm
FROM    startdbpg.ms_mbr_big t1
WHERE   t1.nick_nm LIKE 'Cloud100%';
SQL
복사

-- [SQL-5-3-7-b]: x01(nick_nm) 인덱스 생성 후 [SQL-5-3-7-a]를 재실행

CREATE INDEX ms_mbr_big_x01 ON startdbpg.ms_mbr_big(nick_nm);

-- [SQL-5-3-7-a]

EXPLAIN (ANALYZE,COSTS OFF)
SELECT  t1.mbr_id ,t1.nick_nm
FROM    startdbpg.ms_mbr_big t1
WHERE   t1.nick_nm LIKE 'Cloud100%';
SQL
복사

-- [SQL-5-3-7-c]

EXPLAIN (ANALYZE,COSTS OFF)
SELECT  t1.mbr_id ,t1.nick_nm
FROM    startdbpg.ms_mbr_big t1
WHERE   t1.nick_nm LIKE '%Cloud100%';
SQL
복사

-- [SQL-5-3-7-1-a]

SELECT  t1.datcollate
FROM    pg_database t1
WHERE   t1.datname = current_database();
SQL
복사