select bb.* from
(
select aa.*, rownum rr from
(
select
s.code,
s.product_line,
s.product_family,
s.product,
s.second_handler,
(select d.item_name from sup_dict_item d where d.item_id = s.product_line and d.nls_lang=#lang# ) as product_line_name,
(select d.item_name from sup_dict_item d where d.item_id = s.product_family and d.nls_lang=#lang# ) as product_family_name,
(select d.item_name from sup_dict_item d where d.item_id = s.product and d.nls_lang=#lang# ) as product_name
from SUP_PO_APPLY_SECOND_HANDLER s
where 1=1
优化以后 :select bb.* from
(
select aa.*, rownum rr from
(
select
s.code,
s.product_line,
s.product_family,
s.product,
s.second_handler,
d1.item_name as product_line_name,
d2.item_name as product_family_name,
d3.item_name as product_name
from SUP_PO_APPLY_SECOND_HANDLER s inner join sup_dict_item d1 on d1.item_id = s.product_line and d1.nls_lang=#lang#
inner join sup_dict_item d2 on d2.item_id = s.product_family and d2.nls_lang=#lang#
inner join sup_dict_item d3 on d3.item_id = s.product and d3.nls_lang=#lang#
where 1=1
(
select aa.*, rownum rr from
(
select
s.code,
s.product_line,
s.product_family,
s.product,
s.second_handler,
(select d.item_name from sup_dict_item d where d.item_id = s.product_line and d.nls_lang=#lang# ) as product_line_name,
(select d.item_name from sup_dict_item d where d.item_id = s.product_family and d.nls_lang=#lang# ) as product_family_name,
(select d.item_name from sup_dict_item d where d.item_id = s.product and d.nls_lang=#lang# ) as product_name
from SUP_PO_APPLY_SECOND_HANDLER s
where 1=1
优化以后 :select bb.* from
(
select aa.*, rownum rr from
(
select
s.code,
s.product_line,
s.product_family,
s.product,
s.second_handler,
d1.item_name as product_line_name,
d2.item_name as product_family_name,
d3.item_name as product_name
from SUP_PO_APPLY_SECOND_HANDLER s inner join sup_dict_item d1 on d1.item_id = s.product_line and d1.nls_lang=#lang#
inner join sup_dict_item d2 on d2.item_id = s.product_family and d2.nls_lang=#lang#
inner join sup_dict_item d3 on d3.item_id = s.product and d3.nls_lang=#lang#
where 1=1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货