-- [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
복사

