-- [CQ-7-5-4]
EXPLAIN (COSTS OFF)
SELECT /*+ */
t1.* ,t2.* , t3.*
FROM startdbpg.tr_ord t1
INNER JOIN startdbpg.tr_ord_det t2
ON (t1.ord_no = t2.ord_no)
INNER JOIN startdbpg.ms_item t3
ON (t3.item_id = t2.item_id)
WHERE t1.ord_no BETWEEN 10 AND 30
AND t2.ord_no BETWEEN 10 AND 30;
SQL
복사
