第一个语句:
select Newid(), C.FCPP,C.FCC1,C.FCC2,C.FCXH,C.FC5, C.FCC3,C.FYG, C.FBM, C.FDJ, C.FCC5,C.FCXS,C.FDJ, 0, C.FSL, C.FI1, C.FCK, C.FCLX, C.FCBZ,replace(C.FNumber,'-',''), C.FD2, C.FHT, C.FKH, C.FGUID ,0 , C.FD3 ,0 , C.FC3 ,C.FC4 ,0, 0, 0 , C.FCC6,C.FCC8,C.FCDJ,999999999,999999999,isnull(M.FCM15,M.FM1) from (select * from d_buy_ghfb where FNumber='GK-090317-1675') C,B_CMS_ProductInfo M where C.FCPP=M.FCPP and C.FCXH=M.FCXH and C.Fnumber like 'GK%' or C.Fnumber like 'PO%'
第二个语句: select Newid(), C.FCPP,C.FCC1,C.FCC2,C.FCXH,C.FC5, C.FCC3,C.FYG, C.FBM, C.FDJ, C.FCC5,C.FCXS,C.FDJ, 0, C.FSL, C.FI1, C.FCK, C.FCLX, C.FCBZ,replace(C.FNumber,'-',''), C.FD2, C.FHT, C.FKH, C.FGUID ,0 , C.FD3 ,0 , C.FC3 ,C.FC4 ,0, 0, 0 , C.FCC6,C.FCC8,C.FCDJ,999999999,999999999,isnull(M.FCM15,M.FM1) from (select * from d_buy_ghfb where FNumber='GK-090317-1675') C left outer join B_CMS_ProductInfo M on C.FCPP=M.FCPP and C.FCXH=M.FCXH where C.Fnumber like 'GK%' or C.Fnumber like 'PO%' 第一个语句竞然比第二个语句多执行30倍..
B_CMS_ProductInfo 30万记录.. d_buy_ghfb :如果带上单号可能只有100来条..
select Newid(), C.FCPP,C.FCC1,C.FCC2,C.FCXH,C.FC5, C.FCC3,C.FYG, C.FBM, C.FDJ, C.FCC5,C.FCXS,C.FDJ, 0, C.FSL, C.FI1, C.FCK, C.FCLX, C.FCBZ,replace(C.FNumber,'-',''), C.FD2, C.FHT, C.FKH, C.FGUID ,0 , C.FD3 ,0 , C.FC3 ,C.FC4 ,0, 0, 0 , C.FCC6,C.FCC8,C.FCDJ,999999999,999999999,isnull(M.FCM15,M.FM1) from (select * from d_buy_ghfb where FNumber='GK-090317-1675') C,B_CMS_ProductInfo M where C.FCPP=M.FCPP and C.FCXH=M.FCXH and C.Fnumber like 'GK%' or C.Fnumber like 'PO%'
第二个语句: select Newid(), C.FCPP,C.FCC1,C.FCC2,C.FCXH,C.FC5, C.FCC3,C.FYG, C.FBM, C.FDJ, C.FCC5,C.FCXS,C.FDJ, 0, C.FSL, C.FI1, C.FCK, C.FCLX, C.FCBZ,replace(C.FNumber,'-',''), C.FD2, C.FHT, C.FKH, C.FGUID ,0 , C.FD3 ,0 , C.FC3 ,C.FC4 ,0, 0, 0 , C.FCC6,C.FCC8,C.FCDJ,999999999,999999999,isnull(M.FCM15,M.FM1) from (select * from d_buy_ghfb where FNumber='GK-090317-1675') C left outer join B_CMS_ProductInfo M on C.FCPP=M.FCPP and C.FCXH=M.FCXH where C.Fnumber like 'GK%' or C.Fnumber like 'PO%' 第一个语句竞然比第二个语句多执行30倍..
B_CMS_ProductInfo 30万记录.. d_buy_ghfb :如果带上单号可能只有100来条..
第一种写法是inner join
第二种写法是left outer join 数据很可能不一样
但应该是第二种写法数据量比较大啊,不知道LZ到底想说什么》