Search

2-1-3. 실행계획 트리

-- [SQL-2-1-3-1-a] EXPLAIN SELECT t1.ord_no ,t1.ord_dtm ,t1.shop_id ,(SELECT s1.shop_nm FROM startdbpg.ms_shop s1 WHERE s1.shop_id = t1.shop_id) shop_nm FROM startdbpg.tr_ord t1 WHERE t1.ord_dtm >= '2024-01-01'::date AND t1.ord_dtm < '2024-01-02'::date;
SQL
복사