22,301
社区成员




--尽量不要用远程表来连接
IF OBJECT_ID('tempdb..#tmp') IS NOT NULL
DROP TABLE #tmp
SELECT *
INTO #tmp
FROM LinkedServer.dbname.dbo.T3
CREATE CLUSTERED INDEX ix_tmp ON #tmp (RF1,RF3)
SELECT * FROM localserver.dbo.t1 a
INNER JOIN localserver.dbo.t2 b ON a. F1=b.F1 AND a.F2=b.F2
INNER JOIN #tmp c ON a.F1= c.RF1 and a.F3=c.RF3
DROP TABLE #tmp