Search

5-3-1. 검색키와 스톱키가 없는 SQL

-- [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-3-1-b] EXPLAIN (ANALYZE,BUFFERS,COSTS OFF) SELECT /*+ IndexOnlyScan(t1) */ t1.mbr_id FROM startdbpg.ms_mbr_big t1 WHERE LOWER(t1.mbr_id) = 'm00010';
SQL
복사