1、SQLServer性能调优杂记(四)>> 系统上线完,性能问题往往是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=ORIGINORORIGINISNULL) AND (a
2、.DEST=DESTORDESTISNULL) AND (a.CONSIGNOR_CUSTOMER_CODE=CONSIGNOR_CUSTOMER_CODEORCONSIGNOR_CUSTOMER_CODEISNULL) AND (a.CONSIGNOR_NAMELIKE'%'+CONSIGNOR_NAME+'%'ORCONSIGNOR_NAMEISNULL) AND (a.CONSIGNEE_NAMELIKE'%'+CONSIGNEE_NAME+'%
3、39;ORCONSIGNEE_NAMEISNULL) AND (a.CODIFY_ON, a.CREATED_ON, a.CONSIGNOR_CUSTOMER_CODE, a.CONSIGNOR_CODE, a.CONSIGNOR_NAME, a.CONSIGNEE_NAME, a.C TB_CWBASa LEFTJOIN TB_CWBWEIGHTASb ON a.CWB_NO=b.CWB_NO AND b.AVAIL
4、ABLE='Y' WHERE a.AVAILABLE='Y' AND (a.CWB_NO='31017768390'OR (('31010930775'ISNULL) AND (a.AWB_NO=NULLORNULLISNULL) AND (a.BWB_NO=NULLORNULLISNULL) AND (a.IE_TYPE=NULLORNULLISNULL)
5、 AND (a.CREATED_ON>=NULLORNULLISNULL) AND (a.CREATED_ON<= NULLORNULLISNULL) A123下一页>>>>这篇文章来自..,。ND (a.PAYMENT=NULLORNULLISNULL) AND (a.ORIGIN=NULLORNULLISNULL) AND (a.DEST=NULLORNULLISNULL) AND (a.CONSIGNOR_CUSTOMER_CODE=NULLORNULLIS
6、NULL) AND (a.CONSIGNOR_NAMELIKE'%'+NULL+'%'ORNULLISNULL) AND (a.CONSIGNEE_NAMELIKE'%'+NULL+'%'ORNULLISNULL) AND (a.CODIFY_ON, a.CREATED_ON, a.CONSIGNOR_CUSTOMER_CODE, a.CONSIGNOR_CODE, a.CONSIGNOR_
7、NAME, a.CONSIGNEE_NAME, a.C TB_CENT=PAYMENTORPAYMENTISNULL) AND (a.ORIGIN=ORIGINORORIGINISNULL) AND (a.DEST=DESTORDESTISNULL) AND (a.CONSIGNOR_CUSTOMER_CODE=CONSIGNOR_CUSTOMER_CODEORCONSIGNOR_CUSTOMER_CODEISNULL) AND (a.CONSIGNOR_NAMEL