27,579
社区成员
发帖
与我相关
我的任务
分享
where charindex('545000015014523',
isnull(tf.fnumber,'' )+ ',' +
isnull(tf.fname,'')+ ',' +
isnull(ta.flabelnumber,'' ))>0
SELECT FNumber
INTO #tf
FROM t_Farmer tf
WHERE tf.FName LIKE '%545000015014523%'
OR tf.FNumber LIKE '%545000015014523%'
CREATE CLUSTERED INDEX ix_tf ON #tf(FNumber)
SELECT FCompanyNumber
INTO #ta
FROM t_Animal ta
WHERE ta.flabelnumber LIKE '%545000015014523%'
CREATE CLUSTERED INDEX ix_ta ON #ta(FCompanyNumber)
SELECT COUNT(*) AS recordcount
FROM #ta ta
LEFT JOIN #tf tf
ON tf.FNumber = ta.FFarmerNumber
LEFT JOIN t_Company cm
ON cm.FNumber = ta.FCompanyNumber
WHERE cm.FCity = '百色市'
DROP INDEX ix_tf ON #tf
DROP INDEX ix_ta ON #ta
看下改成这样之后, 能不能快起来?SELECT COUNT(*) AS recordcount
FROM t_Animal ta
LEFT JOIN t_Farmer tf ON tf.FNumber = ta.FFarmerNumber
LEFT JOIN t_Company cm ON cm.FNumber = ta.FCompanyNumber
WHERE CHARINDEX('545000015014523', ISNULL(tf.fnumber, '')) > 0
OR CHARINDEX('545000015014523', ( ISNULL(tf.fname, '') )) > 0
OR CHARINDEX('545000015014523', ( ISNULL(ta.flabelnumber, '') )) > 0