Запрос: SELECT T1._Document31399_IDRRef, T1._Fld31437RRef, (T1._Fld31444 * T3._Fld2160) FROM _Document31399_VT31435 T1 WITH(NOLOCK) LEFT OUTER JOIN _Reference160 T2 WITH(NOLOCK) ON T1._Fld31437RRef = T2._IDRRef LEFT OUTER JOIN _Reference98 T3 WITH(NOLOCK) ON (T2._Fld2750RRef = T3._IDRRef) WHERE (T1._Document31399_IDRRef = @P1) План: Rows Executes StmtText StmtId NodeId Parent PhysicalOp LogicalOp Argument DefinedValues EstimateRows EstimateIO EstimateCPU AvgRowSize TotalSubtreeCost OutputList Warnings Type Parallel EstimateExecutions ---- -------- -------- ------ ------ ------ ---------- --------- -------- ------------- ------------ ---------- ----------- ---------- ---------------- ---------- -------- ---- -------- ------------------ 0 0 Compute Scalar(DEFINE:([Expr1006]=[Test2].[dbo].[_Document31399_VT31435].[_Fld31444] as [T1].[_Fld31444]*[Test2].[dbo].[_Reference98].[_Fld2160] as [T3].[_Fld2160])) 0 0 Compute Scalar Compute Scalar DEFINE:([Expr1006]=[Test2].[dbo].[_Document31399_VT31435].[_Fld31444] as [T1].[_Fld31444]*[Test2].[dbo].[_Reference98].[_Fld2160] as [T3].[_Fld2160]) [Expr1006]=[Test2].[dbo].[_Document31399_VT31435].[_Fld31444] as [T1].[_Fld31444]*[Test2].[dbo].[_Reference98].[_Fld2160] as [T3].[_Fld2160] 249,138 0 2,49138E-005 52 0,80092 [T1].[_Document31399_IDRRef], [T1].[_Fld31437RRef], [Expr1006] PLAN_ROW 0 1 187 1 |--Nested Loops(Left Outer Join, OUTER REFERENCES:([T1].[_Fld31437RRef])) 0 1 0 Nested Loops Left Outer Join OUTER REFERENCES:([T1].[_Fld31437RRef]) 249,138 0 0,0010414 57 0,800895 [T1].[_Document31399_IDRRef], [T1].[_Fld31437RRef], [T1].[_Fld31444], [T3].[_Fld2160] PLAN_ROW 0 1 187 1 |--Clustered Index Seek(OBJECT:([Test2].[dbo].[_Document31399_VT31435].[_Docum31399_VT31435_IntKeyInd] AS [T1]), SEEK:([T1].[_Document31399_IDRRef]=[@P1]) ORDERED FORWARD) 0 2 1 Clustered Index Seek Clustered Index Seek OBJECT:([Test2].[dbo].[_Document31399_VT31435].[_Docum31399_VT31435_IntKeyInd] AS [T1]), SEEK:([T1].[_Document31399_IDRRef]=[@P1]) ORDERED FORWARD [T1].[_Document31399_IDRRef], [T1].[_Fld31437RRef], [T1].[_Fld31444] 249,138 0,00696974 0,000431051 48 0,00740079 [T1].[_Document31399_IDRRef], [T1].[_Fld31437RRef], [T1].[_Fld31444] PLAN_ROW 0 1 187 187 |--Index Spool(SEEK:([T1].[_Fld31437RRef]=[Test2].[dbo].[_Document31399_VT31435].[_Fld31437RRef] as [T1].[_Fld31437RRef])) 0 3 1 Index Spool Lazy Spool SEEK:([T1].[_Fld31437RRef]=[Test2].[dbo].[_Document31399_VT31435].[_Fld31437RRef] as [T1].[_Fld31437RRef]) 1 0,003125 0,000258775 16 0,792452 [T3].[_Fld2160] PLAN_ROW 0 249,138 187 187 |--Nested Loops(Left Outer Join, OUTER REFERENCES:([T2].[_Fld2750RRef])) 0 4 3 Nested Loops Left Outer Join OUTER REFERENCES:([T2].[_Fld2750RRef]) 1 0 4,18E-006 16 0,724857 [T3].[_Fld2160] PLAN_ROW 0 168,664 187 187 |--Clustered Index Seek(OBJECT:([Test2].[dbo].[_Reference160].[PK___Referen__AC8ED0C4435BB454] AS [T2]), SEEK:([T2].[_IDRRef]=[Test2].[dbo].[_Document31399_VT31435].[_Fld31437RRef] as [T1].[_Fld31437RRef]) ORDERED FORWARD) 0 5 4 Clustered Index Seek Clustered Index Seek OBJECT:([Test2].[dbo].[_Reference160].[PK___Referen__AC8ED0C4435BB454] AS [T2]), SEEK:([T2].[_IDRRef]=[Test2].[dbo].[_Document31399_VT31435].[_Fld31437RRef] as [T1].[_Fld31437RRef]) ORDERED FORWARD [T2].[_Fld2750RRef] 1 0,003125 0,0001581 23 0,376102 [T2].[_Fld2750RRef] PLAN_ROW 0 168,664 187 187 |--Clustered Index Seek(OBJECT:([Test2].[dbo].[_Reference98].[PK___Reference98NG__0D881CDA] AS [T3]), SEEK:([T3].[_IDRRef]=[Test2].[dbo].[_Reference160].[_Fld2750RRef] as [T2].[_Fld2750RRef]) ORDERED FORWARD) 0 6 4 Clustered Index Seek Clustered Index Seek OBJECT:([Test2].[dbo].[_Reference98].[PK___Reference98NG__0D881CDA] AS [T3]), SEEK:([T3].[_IDRRef]=[Test2].[dbo].[_Reference160].[_Fld2750RRef] as [T2].[_Fld2750RRef]) ORDERED FORWARD [T3].[_Fld2160] 1 0,003125 0,0001581 16 0,34805 [T3].[_Fld2160] PLAN_ROW 0 168,664