DAY_SITE_KEYWORD_DETAIL数据在千万,DAY_SITE_KEYWORD_INFO在千万,怎么做优化才能提高效率? UPDATE A
SET A.KeywordAccessCount=A.KeywordAccessCount+B.KeywordAccessCount,
A.KeywordValue=A.KeywordValue+B.KeywordValue
FROM DAY_SITE_KEYWORD_DETAIL A JOIN
DAY_SITE_KEYWORD_INFO C ON C.DayPKId=A.DayPKId JOIN
#DAY_SITE_KEYWORD_DETAIL B ON A.KeywordName=B.KeywordName and
C.SitePKId=B.SitePKId AND
C.ReportDate=B.ReportDate
SET A.KeywordAccessCount=A.KeywordAccessCount+B.KeywordAccessCount,
A.KeywordValue=A.KeywordValue+B.KeywordValue
FROM DAY_SITE_KEYWORD_DETAIL A JOIN
DAY_SITE_KEYWORD_INFO C ON C.DayPKId=A.DayPKId JOIN
#DAY_SITE_KEYWORD_DETAIL B ON A.KeywordName=B.KeywordName and
C.SitePKId=B.SitePKId AND
C.ReportDate=B.ReportDate
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货