資源描述:
《sqlserver性能調(diào)優(yōu)雜記(四)》由會(huì)員上傳分享,免費(fèi)在線閱讀,更多相關(guān)內(nèi)容在學(xué)術(shù)論文-天天文庫(kù)。
1、SQLServer性能調(diào)優(yōu)雜記(四)>>教育資源庫(kù) 系統(tǒng)上線完,性能問(wèn)題往往是ODIFY_ON, a.CREATED_ON, a.CONSIGNOR_CUSTOMER_CODE, a.CONSIGNOR_CODE, a.CONSIGNOR_NAME, a.CONSIGNEE_NAME, a.C TB_CENT=PAYMENTORPAYMENTISNULL) AND (a.ORIGIN=ORIG
2、INORORIGINISNULL) AND (a.DEST=DESTORDESTISNULL) AND (a.CONSIGNOR_CUSTOMER_CODE=CONSIGNOR_CUSTOMER_CODEORCONSIGNOR_CUSTOMER_CODEISNULL) AND (a.CONSIGNOR_NAMELIKE'%'+CONSIGNOR_NAME+'%'ORCONSIGNOR_NAMEISNULL) AND (
3、a.CONSIGNEE_NAMELIKE'%'+CONSIGNEE_NAME+'%'ORCONSIGNEE_NAMEISNULL) AND (a.CODIFY_ON, a.CREATED_ON, a.CONSIGNOR_CUSTOMER_CODE, a.CONSIGNOR_CODE, a.CONSIGNOR_NAME, a.CONSIGNEE_NAME, a.C
4、TB_CWBASa LEFTJOIN TB_CWBWEIGHTASb ON a.CWB_NO=b.CWB_NO AND b.AVAILABLE='Y' WHERE a.AVAILABLE='Y' AND (a.CWB_NO='31017768390'OR (('31010930775'ISNULL) AND
5、 (a.AWB_NO=NULLORNULLISNULL) AND (a.BWB_NO=NULLORNULLISNULL) AND (a.IE_TYPE=NULLORNULLISNULL) AND (a.CREATED_ON>=NULLORNULLISNULL) AND (a.CREATED_ON<= NULLORNULLISNULL) A123下一頁(yè)>>>>這篇文章來(lái)自..,。ND (a.PAYMENT=NULLORNULLI
6、SNULL) AND (a.ORIGIN=NULLORNULLISNULL) AND (a.DEST=NULLORNULLISNULL) AND (a.CONSIGNOR_CUSTOMER_CODE=NULLORNULLISNULL) AND (a.CONSIGNOR_NAMELIKE'%'+NULL+'%'ORNULLISNULL) AND (a.CONSIGNEE_NAMELIKE'%'
7、+NULL+'%'ORNULLISNULL) AND (a.CODIFY_ON, a.CREATED_ON, a.CONSIGNOR_CUSTOMER_CODE, a.CONSIGNOR_CODE, a.CONSIGNOR_NAME, a.CONSIGNEE_NAME, a.C TB_CENT=PAYMENTORPAYMENTISNULL) AND (a.ORIGIN
8、=ORIGINORORIGINISNULL) AND (a.DEST=DESTORDESTISNULL) AND (a.CONSIGNOR_CUSTOMER_CODE=CONSIGNOR_CUSTOMER_CODEORCONSIGNOR_CUSTOMER_CODEISNULL) AND (a.CONSIGNOR_NAMELIKE''%''+CONSIGNOR_NAME+''%''OR