Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to solve the performance impact of database LOB field", the content of the article is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "how to solve the performance impact of database LOB field" bar!

Today, developers report that a SQL query takes about 2-3 minutes:

SELECT * FROM (SELECT ROWNUM AS ROWNUMBER__, T.* FROM (Select T1.CONSULTINGCODE AS "ConsultingCode", T1.CATEGORY AS "Category", T1.CUSCODE AS "CusCode", T1.ORDERCODE AS "OrderCode", T1.WARECODE AS "WareCode", DECRYPTBYKEY (T1.MOBILEPHONE) AS "MobilePhone" DECRYPTBYKEY (T1.EMAILENCRYPT) AS "EmailEncrypt", T1.ASSIGNTIME AS "AssignTime", T1.REPLIER AS "Replier", T1.REPLYCODE AS "ReplyCode", T1.REPLYDATE AS "ReplyDate", T1.BYWAY AS "ByWay" T1.CREATETIME AS "CreateTime", T1.EVALUATE AS "Evaluate", T1.EXPIREMAN AS "ExpireMan", T1.EXPIREREASON AS "ExpireReason", T1.CONSULTINGTYPEID AS "ConsultingTypeID", T1.STATUS AS "Status" T1.QUESTION AS "Question", T1.MAILCONTENTS AS "MailContents", T1.REPLYCONTENT AS "ReplyContent" T1.ENCEMAIL AS "EncEmail" From mbs7_crm.KH_Consulting T1 left Join mbs7_crm.KH_Customer T2 on T1.CUSCODE = T2.CUSCODE ORDER BY T1.STATUS ASC T1.CREATETIME ASC) T WHERE "CreateTime" > = date '2013-9-1' AND "ReplyCode" IN ('128') AND "CreateTime"

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.