-- [SQL-5-2-5-a]
EXPLAIN (ANALYZE,COSTS OFF)
SELECT /*+ IndexScan(t1 tr_ord_big_x03) */
t1.*
FROM startdbpg.tr_ord_big t1
WHERE t1.ord_dtm >= '2023-03-01'::date
AND t1.ord_dtm < '2023-04-01'::date
AND t1.mbr_id = 'M00031'
AND t1.shop_id = 'S007';
SQL
복사
-- [SQL-5-2-5-b]: [SQL-5-2-5-a]에 대한 Oracle의 실행계획
SELECT /*+ INDEX(t1 tr_ord_big_x03) */
t1.*
FROM startdbora.tr_ord_big t1
WHERE t1.ord_dtm >= TO_DATE('2023-03-01','YYYY-MM-DD')
AND t1.ord_dtm < TO_DATE('2023-04-01','YYYY-MM-DD')
AND t1.mbr_id = 'M00031'
AND t1.shop_id = 'S007';
SQL
복사