6-4. Check Quiz

-- [CQ-6-4-1]

CREATE INDEX x01 ON startdbpg.tr_event_entry_big(entry_dtm);

EXPLAIN (ANALYZE,COSTS OFF)
SELECT  t1.*
FROM    startdbpg.tr_event_entry_big t1
WHERE   t1.mbr_id = 'M03195'
ORDER BY t1.entry_dtm DESC
LIMIT 3;
SQL
복사

-- [CQ-6-4-2]

SELECT  t1.*
FROM    startdbpg.tr_event_entry_big t1
WHERE   t1.mbr_id = 'M07561'
ORDER BY t1.entry_dtm DESC ,t1.event_id DESC
LIMIT 10;
SQL
복사

-- [CQ-6-4-3]

SELECT  t1.*
FROM    startdbpg.tr_event_entry_big t1
WHERE   t1.entry_dtm >= (
                SELECT  MAX(TO_CHAR(x.entry_dtm,'YYYY-MM-DD'))::date
                FROM    startdbpg.tr_event_entry_big x
                );
SQL
복사