select * 耗时1秒不到
select 具体要的字段 19秒
不是一直说 写具体字段会快嘛?
select
A.palletid
,A.LOTID,
replace(B.Bcr_Mod_Subtype,'xxx',A.POWER_GRADE) Bcr_Mod_Subtype,
A.SITEID,
A.PRODUCT_DATE,
case when A.SITEID='1014' then 'China' else ' ' end As Modulepalace,
'Hanwha Solar' CellManufacturer,
'China' cellpalace,
A.POWER_GRADE,
E.IMAX,
E.VMAX,
E.Isc,
E.Voc,
E.FF,
E.Pmax
from (
select t.*,s.palletid from cim_lot t
inner join
(
select lotid,x.palletid from wM_LOT x where x.palletid
in
(
select * FROM TABLE(CAST(COMMON_PKG.FC_SplitToString(p_pallet, ',') AS Split_tbl))
)
) s on s.LOTID=t.LOTID
) A
left join PM_PRODUCTORDER B on A.Origin_Product_Order_No=B.PRODUCT_ORDER_NO AND A.SITEID = B.SITEID
left join PM_BARCODEID_INFO C on B.PRODUCT_ORDER_NO=C.PRODUCT_ORDER_NO AND B.SITEID = C.SITEID
left join PM_DCOLL_FLASH E on E.LOTID=A.LOTID AND A.SITEID = E.SITEID
AND A.Siteid='1014'
AND E.Comments='Y'
order by A.palletid
,A.LOTID
;