库存产品日期查询功能sql优化
摘要:优化后的sql为:...FROM Sale_Ty A...LEFT OUTER JOIN SalPrdDate_Td E ON A.EffDt = E.EffDt AND A.CustCd = E.CustCd AND A.PrdCd = E.PrdCd WHERE A.EffDt = @EffDt and E.EffDt = @EffDt ..., 大大提高了性能
阅读全文
posted @ 2012-02-17 20:16