SELECT a.detail_pos,
         a.cut_type,
         a.cut_len,
         a.product_id,
         a.status
    FROM setup_cut_sched_list a, gtrax_mt b, res_material m
   WHERE     b.product_id = NVL (m.parent_product_id, m.product_id)
         AND a.product_id = b.product_id
         AND b.zone_name = 'Z_1170'
         AND b.piece_pos_in_place = 1
         AND a.cd_id = '1'
ORDER BY 1

위에있는 쿼리를 아래쿼리처럼 고칠경우 성능이 증가할 수 있을까요?

아니면 더 나빠지려나요?

 SELECT a.detail_pos,
         a.cut_type,
         a.cut_len,
         a.product_id,
         a.status
    FROM setup_cut_sched_list a
   WHERE     A.PRODUCT_ID =
                (SELECT B.PRODUCT_ID
                   FROM gtrax_mt b, res_material m
                  WHERE     b.product_id =
                               NVL (m.parent_product_id, m.product_id)
                        AND B.ZONE_NAME = 'Z_1170'
                        AND B.PIECE_POS_IN_PLACE = 1)
         AND a.cd_id = '1'
ORDER BY 1