Rows Executes StmtText StmtId NodeId Parent PhysicalOp LogicalOp Argument DefinedValues EstimateRows EstimateIO EstimateCPU AvgRowSize TotalSubtreeCost OutputList Warnings Type Parallel EstimateExecutions ---- -------- -------- ------ ------ ------ ---------- --------- -------- ------------- ------------ ---------- ----------- ---------- ---------------- ---------- -------- ---- -------- ------------------ 118711 1 Nested Loops(Inner Join, OUTER REFERENCES:([UPP].[dbo].[_InfoRg11304].[_Fld11305RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11306RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11307RRef], [Expr1011], [Expr1022], [Expr1035]) WITH UNORDERED PREFETCH) 0 0 Nested Loops Inner Join OUTER REFERENCES:([UPP].[dbo].[_InfoRg11304].[_Fld11305RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11306RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11307RRef], [Expr1011], [Expr1022], [Expr1035]) WITH UNORDERED PREFETCH 1017,99 0 0,420195 39 1413,6 [_InfoRg11304_IR12].[_Fld11305RRef], [_InfoRg11304_IR12].[_Fld11306RRef] PLAN_ROW 0 1 118711 1 |--Stream Aggregate(GROUP BY:([UPP].[dbo].[_InfoRg11304].[_Fld11305RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11306RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11307RRef], [Expr1011]) DEFINE:([Expr1022]=MAX([Expr1027]))) 0 2 0 Stream Aggregate Aggregate GROUP BY:([UPP].[dbo].[_InfoRg11304].[_Fld11305RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11306RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11307RRef], [Expr1011]) [Expr1022]=MAX([Expr1027]) 100525 0 0,10227 83 1107,66 [UPP].[dbo].[_InfoRg11304].[_Fld11305RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11306RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11307RRef], [Expr1011], [Expr1022] PLAN_ROW 0 1 0 0 | |--Compute Scalar(DEFINE:([Expr1027]=[UPP].[dbo].[_InfoRg11304].[_RecorderTRef] as [_InfoRg11304_IR2].[_RecorderTRef]+[UPP].[dbo].[_InfoRg11304].[_RecorderRRef] as [_InfoRg11304_IR2].[_RecorderRRef])) 0 4 2 Compute Scalar Compute Scalar DEFINE:([Expr1027]=[UPP].[dbo].[_InfoRg11304].[_RecorderTRef] as [_InfoRg11304_IR2].[_RecorderTRef]+[UPP].[dbo].[_InfoRg11304].[_RecorderRRef] as [_InfoRg11304_IR2].[_RecorderRRef]) [Expr1027]=[UPP].[dbo].[_InfoRg11304].[_RecorderTRef] as [_InfoRg11304_IR2].[_RecorderTRef]+[UPP].[dbo].[_InfoRg11304].[_RecorderRRef] as [_InfoRg11304_IR2].[_RecorderRRef] 3,79582E+006 0 0,00640506 83 1107,56 [UPP].[dbo].[_InfoRg11304].[_Fld11305RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11306RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11307RRef], [Expr1011], [Expr1027] PLAN_ROW 0 1 120034 1 | |--Nested Loops(Inner Join, OUTER REFERENCES:([_InfoRg11304_IR2].[_Period], [_InfoRg11304_IR2].[_RecorderTRef], [_InfoRg11304_IR2].[_RecorderRRef], [_InfoRg11304_IR2].[_LineNo], [Expr1034]) WITH ORDERED PREFETCH) 0 5 4 Nested Loops Inner Join OUTER REFERENCES:([_InfoRg11304_IR2].[_Period], [_InfoRg11304_IR2].[_RecorderTRef], [_InfoRg11304_IR2].[_RecorderRRef], [_InfoRg11304_IR2].[_LineNo], [Expr1034]) WITH ORDERED PREFETCH 64050,6 0 0,267731 84 1107,52 [UPP].[dbo].[_InfoRg11304].[_Fld11305RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11306RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11307RRef], [Expr1011], [_InfoRg11304_IR2].[_RecorderTRef], [_InfoRg11304_IR2].[_RecorderRRef] PLAN_ROW 0 1 120034 1 | |--Nested Loops(Inner Join, OUTER REFERENCES:([UPP].[dbo].[_InfoRg11304].[_Fld11307RRef], [Expr1011], [tempdb].[dbo].[#tt6].[_REFFIELDRRef], [tempdb].[dbo].[#tt4].[_REFFIELDRRef], [Expr1033]) WITH ORDERED PREFETCH) 0 7 5 Nested Loops Inner Join OUTER REFERENCES:([UPP].[dbo].[_InfoRg11304].[_Fld11307RRef], [Expr1011], [tempdb].[dbo].[#tt6].[_REFFIELDRRef], [tempdb].[dbo].[#tt4].[_REFFIELDRRef], [Expr1033]) WITH ORDERED PREFETCH 64050,6 0 0,264381 96 927,61 [UPP].[dbo].[_InfoRg11304].[_Fld11305RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11306RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11307RRef], [Expr1011], [_InfoRg11304_IR2].[_Period], [_InfoRg11304_IR2].[_RecorderTRef], [_InfoRg11304_IR2].[_RecorderRRef], [_InfoRg11304_IR2].[_LineNo] PLAN_ROW 0 1 118711 1 | | |--Sort(ORDER BY:([UPP].[dbo].[_InfoRg11304].[_Fld11305RRef] ASC, [UPP].[dbo].[_InfoRg11304].[_Fld11306RRef] ASC, [UPP].[dbo].[_InfoRg11304].[_Fld11307RRef] ASC)) 0 9 7 Sort Sort ORDER BY:([UPP].[dbo].[_InfoRg11304].[_Fld11305RRef] ASC, [UPP].[dbo].[_InfoRg11304].[_Fld11306RRef] ASC, [UPP].[dbo].[_InfoRg11304].[_Fld11307RRef] ASC) 63249,1 0,0112613 4,63024 95 734,662 [UPP].[dbo].[_InfoRg11304].[_Fld11305RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11306RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11307RRef], [Expr1011], [tempdb].[dbo].[#tt6].[_REFFIELDRRef], [tempdb].[dbo].[#tt4].[_REFFIELDRRef] PLAN_ROW 0 1 118711 1 | | | |--Hash Match(Inner Join, HASH:([tempdb].[dbo].[#tt4].[_REFFIELDRRef])=([UPP].[dbo].[_InfoRg11304].[_Fld11305RRef]), RESIDUAL:([tempdb].[dbo].[#tt4].[_REFFIELDRRef]=[UPP].[dbo].[_InfoRg11304].[_Fld11305RRef])) 0 10 9 Hash Match Inner Join HASH:([tempdb].[dbo].[#tt4].[_REFFIELDRRef])=([UPP].[dbo].[_InfoRg11304].[_Fld11305RRef]), RESIDUAL:([tempdb].[dbo].[#tt4].[_REFFIELDRRef]=[UPP].[dbo].[_InfoRg11304].[_Fld11305RRef]) 63249,1 0 0,702093 95 730,02 [UPP].[dbo].[_InfoRg11304].[_Fld11305RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11306RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11307RRef], [Expr1011], [tempdb].[dbo].[#tt6].[_REFFIELDRRef], [tempdb].[dbo].[#tt4].[_REFFIELDRRef] PLAN_ROW 0 1 216 1 | | | |--Sort(DISTINCT ORDER BY:([tempdb].[dbo].[#tt4].[_REFFIELDRRef] ASC)) 0 11 10 Sort Distinct Sort DISTINCT ORDER BY:([tempdb].[dbo].[#tt4].[_REFFIELDRRef] ASC) 216 0,0112613 0,00271311 23 0,017494 [tempdb].[dbo].[#tt4].[_REFFIELDRRef] PLAN_ROW 0 1 216 1 | | | | |--Table Scan(OBJECT:([tempdb].[dbo].[#tt4])) 0 12 11 Table Scan Table Scan OBJECT:([tempdb].[dbo].[#tt4]) [tempdb].[dbo].[#tt4].[_REFFIELDRRef] 216 0,003125 0,0003946 23 0,0035196 [tempdb].[dbo].[#tt4].[_REFFIELDRRef] PLAN_ROW 0 1 118711 1 | | | |--Nested Loops(Inner Join, OUTER REFERENCES:([tempdb].[dbo].[#tt6].[_REFFIELDRRef])) 0 13 10 Nested Loops Inner Join OUTER REFERENCES:([tempdb].[dbo].[#tt6].[_REFFIELDRRef]) 93391,7 0 0,342449 79 729,3 [UPP].[dbo].[_InfoRg11304].[_Fld11305RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11306RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11307RRef], [Expr1011], [tempdb].[dbo].[#tt6].[_REFFIELDRRef] PLAN_ROW 0 1 903 1 | | | |--Sort(DISTINCT ORDER BY:([tempdb].[dbo].[#tt6].[_REFFIELDRRef] ASC)) 0 14 13 Sort Distinct Sort DISTINCT ORDER BY:([tempdb].[dbo].[#tt6].[_REFFIELDRRef] ASC) 903 0,0112613 0,0139313 23 0,03169 [tempdb].[dbo].[#tt6].[_REFFIELDRRef] PLAN_ROW 0 1 903 1 | | | | |--Table Scan(OBJECT:([tempdb].[dbo].[#tt6])) 0 15 14 Table Scan Table Scan OBJECT:([tempdb].[dbo].[#tt6]) [tempdb].[dbo].[#tt6].[_REFFIELDRRef] 903 0,00534722 0,0011503 23 0,00649752 [tempdb].[dbo].[#tt6].[_REFFIELDRRef] PLAN_ROW 0 1 118711 903 | | | |--Stream Aggregate(GROUP BY:([UPP].[dbo].[_InfoRg11304].[_Fld11307RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11305RRef]) DEFINE:([Expr1011]=MAX([UPP].[dbo].[_InfoRg11304].[_Period]), [UPP].[dbo].[_InfoRg11304].[_Fld11306RRef]=ANY([UPP].[dbo].[_InfoRg11304].[_Fld11306RRef]))) 0 16 13 Stream Aggregate Aggregate GROUP BY:([UPP].[dbo].[_InfoRg11304].[_Fld11307RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11305RRef]) [Expr1011]=MAX([UPP].[dbo].[_InfoRg11304].[_Period]), [UPP].[dbo].[_InfoRg11304].[_Fld11306RRef]=ANY([UPP].[dbo].[_InfoRg11304].[_Fld11306RRef]) 90,7261 0 9,97987E-005 63 728,926 [UPP].[dbo].[_InfoRg11304].[_Fld11305RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11306RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11307RRef], [Expr1011] PLAN_ROW 0 903 424794 903 | | | |--Sort(ORDER BY:([UPP].[dbo].[_InfoRg11304].[_Fld11307RRef] ASC, [UPP].[dbo].[_InfoRg11304].[_Fld11305RRef] ASC)) 0 17 16 Sort Sort ORDER BY:([UPP].[dbo].[_InfoRg11304].[_Fld11307RRef] ASC, [UPP].[dbo].[_InfoRg11304].[_Fld11305RRef] ASC) 90,7261 0,0112613 0,00102051 63 728,836 [UPP].[dbo].[_InfoRg11304].[_Period], [UPP].[dbo].[_InfoRg11304].[_Fld11305RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11306RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11307RRef] PLAN_ROW 0 903 424794 903 | | | |--Nested Loops(Inner Join) 0 18 17 Nested Loops Inner Join 90,7261 0 0,000498419 63 717,746 [UPP].[dbo].[_InfoRg11304].[_Period], [UPP].[dbo].[_InfoRg11304].[_Fld11305RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11306RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11307RRef] PLAN_ROW 0 903 903 903 | | | |--Top(TOP EXPRESSION:((1))) 0 20 18 Top Top TOP EXPRESSION:((1)) 1 0 1E-007 9 0,283325 PLAN_ROW 0 903 903 903 | | | | |--Index Spool(SEEK:([tempdb].[dbo].[#tt6].[_REFFIELDRRef]=[tempdb].[dbo].[#tt6].[_REFFIELDRRef])) 0 21 20 Index Spool Eager Spool SEEK:([tempdb].[dbo].[#tt6].[_REFFIELDRRef]=[tempdb].[dbo].[#tt6].[_REFFIELDRRef]) 1 0,0333953 0,0011611 9 0,283235 PLAN_ROW 0 903 903 1 | | | | |--Table Scan(OBJECT:([tempdb].[dbo].[#tt6])) 0 22 21 Table Scan Table Scan OBJECT:([tempdb].[dbo].[#tt6]) [tempdb].[dbo].[#tt6].[_REFFIELDRRef] 903 0,00534722 0,0011503 23 0,00649752 [tempdb].[dbo].[#tt6].[_REFFIELDRRef] PLAN_ROW 0 1 424794 903 | | | |--Merge Join(Inner Join, MERGE:([tempdb].[dbo].[#tt4].[_REFFIELDRRef])=([UPP].[dbo].[_InfoRg11304].[_Fld11305RRef]), RESIDUAL:([UPP].[dbo].[_InfoRg11304].[_Fld11305RRef]=[tempdb].[dbo].[#tt4].[_REFFIELDRRef])) 0 25 18 Merge Join Inner Join MERGE:([tempdb].[dbo].[#tt4].[_REFFIELDRRef])=([UPP].[dbo].[_InfoRg11304].[_Fld11305RRef]), RESIDUAL:([UPP].[dbo].[_InfoRg11304].[_Fld11305RRef]=[tempdb].[dbo].[#tt4].[_REFFIELDRRef]) 119,239 0 0,00662917 63 717,012 [UPP].[dbo].[_InfoRg11304].[_Period], [UPP].[dbo].[_InfoRg11304].[_Fld11305RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11306RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11307RRef] PLAN_ROW 0 903 182565 903 | | | |--Sort(DISTINCT ORDER BY:([tempdb].[dbo].[#tt4].[_REFFIELDRRef] ASC)) 0 26 25 Sort Distinct Sort DISTINCT ORDER BY:([tempdb].[dbo].[#tt4].[_REFFIELDRRef] ASC) 216 0,0112613 0,00271311 23 12,9075 [tempdb].[dbo].[#tt4].[_REFFIELDRRef] PLAN_ROW 0 903 195048 903 | | | | |--Table Scan(OBJECT:([tempdb].[dbo].[#tt4])) 0 27 26 Table Scan Table Scan OBJECT:([tempdb].[dbo].[#tt4]) [tempdb].[dbo].[#tt4].[_REFFIELDRRef] 216 0,0032035 0,0003161 23 0,288642 [tempdb].[dbo].[#tt4].[_REFFIELDRRef] PLAN_ROW 0 903 685148 903 | | | |--Sort(ORDER BY:([UPP].[dbo].[_InfoRg11304].[_Fld11305RRef] ASC)) 0 28 25 Sort Sort ORDER BY:([UPP].[dbo].[_InfoRg11304].[_Fld11305RRef] ASC) 268,404 0,0112613 0,00347832 63 698,116 [UPP].[dbo].[_InfoRg11304].[_Period], [UPP].[dbo].[_InfoRg11304].[_Fld11305RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11306RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11307RRef] PLAN_ROW 0 903 697780 903 | | | |--Nested Loops(Inner Join, OUTER REFERENCES:([UPP].[dbo].[_InfoRg11304].[_Period], [UPP].[dbo].[_InfoRg11304].[_RecorderTRef], [UPP].[dbo].[_InfoRg11304].[_RecorderRRef], [UPP].[dbo].[_InfoRg11304].[_LineNo], [Expr1032]) WITH UNORDERED PREFETCH) 0 29 28 Nested Loops Inner Join OUTER REFERENCES:([UPP].[dbo].[_InfoRg11304].[_Period], [UPP].[dbo].[_InfoRg11304].[_RecorderTRef], [UPP].[dbo].[_InfoRg11304].[_RecorderRRef], [UPP].[dbo].[_InfoRg11304].[_LineNo], [Expr1032]) WITH UNORDERED PREFETCH 268,404 0 0,00112193 89 684,69 [UPP].[dbo].[_InfoRg11304].[_Period], [UPP].[dbo].[_InfoRg11304].[_Fld11305RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11306RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11307RRef] PLAN_ROW 0 903 697780 903 | | | |--Index Seek(OBJECT:([UPP].[dbo].[_InfoRg11304].[_InfoR11304_ByDims23646_RTRN]), SEEK:([UPP].[dbo].[_InfoRg11304].[_Fld11306RRef]=[tempdb].[dbo].[#tt6].[_REFFIELDRRef]) ORDERED FORWARD) 0 31 29 Index Seek Index Seek OBJECT:([UPP].[dbo].[_InfoRg11304].[_InfoR11304_ByDims23646_RTRN]), SEEK:([UPP].[dbo].[_InfoRg11304].[_Fld11306RRef]=[tempdb].[dbo].[#tt6].[_REFFIELDRRef]) ORDERED FORWARD [UPP].[dbo].[_InfoRg11304].[_Period], [UPP].[dbo].[_InfoRg11304].[_RecorderTRef], [UPP].[dbo].[_InfoRg11304].[_RecorderRRef], [UPP].[dbo].[_InfoRg11304].[_LineNo], [UPP].[dbo].[_InfoRg11304].[_Fld11306RRef] 268,404 0,00386574 0,000452244 56 3,89125 [UPP].[dbo].[_InfoRg11304].[_Period], [UPP].[dbo].[_InfoRg11304].[_RecorderTRef], [UPP].[dbo].[_InfoRg11304].[_RecorderRRef], [UPP].[dbo].[_InfoRg11304].[_LineNo], [UPP].[dbo].[_InfoRg11304].[_Fld11306RRef] PLAN_ROW 0 903 697780 697780 | | | |--Clustered Index Seek(OBJECT:([UPP].[dbo].[_InfoRg11304].[_InfoR11304_ByPeriod_TRN]), SEEK:([UPP].[dbo].[_InfoRg11304].[_Period]=[UPP].[dbo].[_InfoRg11304].[_Period] AND [UPP].[dbo].[_InfoRg11304].[_RecorderTRef]=[UPP].[dbo].[_InfoRg11304].[_RecorderTRef] AND [UPP].[dbo].[_InfoRg11304].[_RecorderRRef]=[UPP].[dbo].[_InfoRg11304].[_RecorderRRef] AND [UPP].[dbo].[_InfoRg11304].[_LineNo]=[UPP].[dbo].[_InfoRg11304].[_LineNo]), WHERE:([UPP].[dbo].[_InfoRg11304].[_Active]=[@P1]) LOOKUP ORDERED FORWARD) 0 33 29 Clustered Index Seek Clustered Index Seek OBJECT:([UPP].[dbo].[_InfoRg11304].[_InfoR11304_ByPeriod_TRN]), SEEK:([UPP].[dbo].[_InfoRg11304].[_Period]=[UPP].[dbo].[_InfoRg11304].[_Period] AND [UPP].[dbo].[_InfoRg11304].[_RecorderTRef]=[UPP].[dbo].[_InfoRg11304].[_RecorderTRef] AND [UPP].[dbo].[_InfoRg11304].[_RecorderRRef]=[UPP].[dbo].[_InfoRg11304].[_RecorderRRef] AND [UPP].[dbo].[_InfoRg11304].[_LineNo]=[UPP].[dbo].[_InfoRg11304].[_LineNo]), WHERE:([UPP].[dbo].[_InfoRg11304].[_Active]=[@P1]) LOOKUP ORDERED FORWARD [UPP].[dbo].[_InfoRg11304].[_Fld11305RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11307RRef] 268,404 0,003125 0,0001581 40 679,786 [UPP].[dbo].[_InfoRg11304].[_Fld11305RRef], [UPP].[dbo].[_InfoRg11304].[_Fld11307RRef] PLAN_ROW 0 242369 120034 118711 | | |--Index Seek(OBJECT:([UPP].[dbo].[_InfoRg11304].[_InfoR11304_ByDims_RRRTRN] AS [_InfoRg11304_IR2]), SEEK:([_InfoRg11304_IR2].[_Fld11305RRef]=[tempdb].[dbo].[#tt4].[_REFFIELDRRef] AND [_InfoRg11304_IR2].[_Fld11306RRef]=[tempdb].[dbo].[#tt6].[_REFFIELDRRef] AND [_InfoRg11304_IR2].[_Fld11307RRef]=[UPP].[dbo].[_InfoRg11304].[_Fld11307RRef] AND [_InfoRg11304_IR2].[_Period]=[Expr1011]) ORDERED FORWARD) 0 46 7 Index Seek Index Seek OBJECT:([UPP].[dbo].[_InfoRg11304].[_InfoR11304_ByDims_RRRTRN] AS [_InfoRg11304_IR2]), SEEK:([_InfoRg11304_IR2].[_Fld11305RRef]=[tempdb].[dbo].[#tt4].[_REFFIELDRRef] AND [_InfoRg11304_IR2].[_Fld11306RRef]=[tempdb].[dbo].[#tt6].[_REFFIELDRRef] AND [_InfoRg11304_IR2].[_Fld11307RRef]=[UPP].[dbo].[_InfoRg11304].[_Fld11307RRef] AND [_InfoRg11304_IR2].[_Period]=[Expr1011]) ORDERED FORWARD [_InfoRg11304_IR2].[_Period], [_InfoRg11304_IR2].[_RecorderTRef], [_InfoRg11304_IR2].[_RecorderRRef], [_InfoRg11304_IR2].[_LineNo] 1 0,003125 0,0001581 40 192,684 [_InfoRg11304_IR2].[_Period], [_InfoRg11304_IR2].[_RecorderTRef], [_InfoRg11304_IR2].[_RecorderRRef], [_InfoRg11304_IR2].[_LineNo] PLAN_ROW 0 63249,1 120034 120034 | |--Clustered Index Seek(OBJECT:([UPP].[dbo].[_InfoRg11304].[_InfoR11304_ByPeriod_TRN] AS [_InfoRg11304_IR2]), SEEK:([_InfoRg11304_IR2].[_Period]=[UPP].[dbo].[_InfoRg11304].[_Period] as [_InfoRg11304_IR2].[_Period] AND [_InfoRg11304_IR2].[_RecorderTRef]=[UPP].[dbo].[_InfoRg11304].[_RecorderTRef] as [_InfoRg11304_IR2].[_RecorderTRef] AND [_InfoRg11304_IR2].[_RecorderRRef]=[UPP].[dbo].[_InfoRg11304].[_RecorderRRef] as [_InfoRg11304_IR2].[_RecorderRRef] AND [_InfoRg11304_IR2].[_LineNo]=[UPP].[dbo].[_InfoRg11304].[_LineNo] as [_InfoRg11304_IR2].[_LineNo]), WHERE:([UPP].[dbo].[_InfoRg11304].[_Active] as [_InfoRg11304_IR2].[_Active]=[@P2]) LOOKUP ORDERED FORWARD) 0 48 5 Clustered Index Seek Clustered Index Seek OBJECT:([UPP].[dbo].[_InfoRg11304].[_InfoR11304_ByPeriod_TRN] AS [_InfoRg11304_IR2]), SEEK:([_InfoRg11304_IR2].[_Period]=[UPP].[dbo].[_InfoRg11304].[_Period] as [_InfoRg11304_IR2].[_Period] AND [_InfoRg11304_IR2].[_RecorderTRef]=[UPP].[dbo].[_InfoRg11304].[_RecorderTRef] as [_InfoRg11304_IR2].[_RecorderTRef] AND [_InfoRg11304_IR2].[_RecorderRRef]=[UPP].[dbo].[_InfoRg11304].[_RecorderRRef] as [_InfoRg11304_IR2].[_RecorderRRef] AND [_InfoRg11304_IR2].[_LineNo]=[UPP].[dbo].[_InfoRg11304].[_LineNo] as [_InfoRg11304_IR2].[_LineNo]), WHERE:([UPP].[dbo].[_InfoRg11304].[_Active] as [_InfoRg11304_IR2].[_Active]=[@P2]) LOOKUP ORDERED FORWARD 64050,6 0,003125 0,0001581 40 179,647 PLAN_ROW 0 64050,6 118711 118711 |--Index Seek(OBJECT:([UPP].[dbo].[_InfoRg11304].[_InfoR11304_ByDims_RRRTRN] AS [_InfoRg11304_IR12]), SEEK:([_InfoRg11304_IR12].[_Fld11305RRef]=[UPP].[dbo].[_InfoRg11304].[_Fld11305RRef] AND [_InfoRg11304_IR12].[_Fld11306RRef]=[UPP].[dbo].[_InfoRg11304].[_Fld11306RRef] AND [_InfoRg11304_IR12].[_Fld11307RRef]=[UPP].[dbo].[_InfoRg11304].[_Fld11307RRef] AND [_InfoRg11304_IR12].[_Period]=[Expr1011] AND [_InfoRg11304_IR12].[_RecorderTRef]=substring([Expr1022],(1),(4)) AND [_InfoRg11304_IR12].[_RecorderRRef]=substring([Expr1022],(5),(16))) ORDERED FORWARD) 0 57 0 Index Seek Index Seek OBJECT:([UPP].[dbo].[_InfoRg11304].[_InfoR11304_ByDims_RRRTRN] AS [_InfoRg11304_IR12]), SEEK:([_InfoRg11304_IR12].[_Fld11305RRef]=[UPP].[dbo].[_InfoRg11304].[_Fld11305RRef] AND [_InfoRg11304_IR12].[_Fld11306RRef]=[UPP].[dbo].[_InfoRg11304].[_Fld11306RRef] AND [_InfoRg11304_IR12].[_Fld11307RRef]=[UPP].[dbo].[_InfoRg11304].[_Fld11307RRef] AND [_InfoRg11304_IR12].[_Period]=[Expr1011] AND [_InfoRg11304_IR12].[_RecorderTRef]=substring([Expr1022],(1),(4)) AND [_InfoRg11304_IR12].[_RecorderRRef]=substring([Expr1022],(5),(16))) ORDERED FORWARD [_InfoRg11304_IR12].[_Fld11305RRef], [_InfoRg11304_IR12].[_Fld11306RRef] 1 0,003125 0,0001581 39 305,521 [_InfoRg11304_IR12].[_Fld11305RRef], [_InfoRg11304_IR12].[_Fld11306RRef] PLAN_ROW 0 100525