Search

3-5. Check Quiz

-- [CQ-3-5-1] EXPLAIN (ANALYZE,COSTS OFF) SELECT * FROM startdbpg.tr_event_entry_big t1 WHERE t1.entry_dtm >= '20240101'::date AND t1.entry_dtm < '20240102'::date;
SQL
복사
-- [CQ-3-5-3] EXPLAIN (ANALYZE,COSTS OFF) SELECT * FROM startdbpg.ms_shop t1 WHERE t1.shop_id >= 'S010' AND t1.shop_id < 'S020';
SQL
복사
-- [CQ-3-5-4] EXPLAIN (ANALYZE,COSTS OFF) SELECT * FROM startdbpg.ms_shop t1 WHERE t1.shop_id >= 'S010' AND t1.shop_id < 'S020';
SQL
복사