Skip to content

Instantly share code, notes, and snippets.

@FragsterAt

FragsterAt/gist:c21af4d867648bc8f3a40fa2f6936fc3

Created July 14, 2017 08:34
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save FragsterAt/c21af4d867648bc8f3a40fa2f6936fc3 to your computer and use it in GitHub Desktop.
Save FragsterAt/c21af4d867648bc8f3a40fa2f6936fc3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
StmtText StmtId NodeId Parent PhysicalOp LogicalOp Argument DefinedValues EstimateRows EstimateIO EstimateCPU AvgRowSize TotalSubtreeCost OutputList Warnings Type Parallel EstimateExecutions
-------- ------ ------ ------ ---------- --------- -------- ------------- ------------ ---------- ----------- ---------- ---------------- ---------- -------- ---- -------- ------------------
Table Insert(OBJECT:([tempdb].[dbo].[#tt5]), SET:([tempdb].[dbo].[#tt5].[_Q_001_F_000RRef] = [Union1043],[tempdb].[dbo].[#tt5].[_Q_001_F_001] = [Expr1046],[tempdb].[dbo].[#tt5].[_Q_001_F_002RRef] = [Union1045])) 0 0 Table Insert Insert OBJECT:([tempdb].[dbo].[#tt5]), SET:([tempdb].[dbo].[#tt5].[_Q_001_F_000RRef] = [Union1043],[tempdb].[dbo].[#tt5].[_Q_001_F_001] = [Expr1046],[tempdb].[dbo].[#tt5].[_Q_001_F_002RRef] = [Union1045]) 610506 26,6911 0,610506 9 62,3025 PLAN_ROW 0 1
|--Compute Scalar(DEFINE:([Expr1046]=CONVERT_IMPLICIT(nvarchar(10),[Union1044],0))) 0 1 0 Compute Scalar Compute Scalar DEFINE:([Expr1046]=CONVERT_IMPLICIT(nvarchar(10),[Union1044],0)) [Expr1046]=CONVERT_IMPLICIT(nvarchar(10),[Union1044],0) 610506 0 0,0610506 53 35,0009 [Union1043], [Union1045], [Expr1046] PLAN_ROW 0 1
|--Concatenation 0 2 1 Concatenation Concatenation [Union1043] = ([T3].[_Q_000_F_000RRef], [T8].[_Q_000_F_000RRef], [T13].[_Q_000_F_000RRef], [T18].[_Q_000_F_000RRef]), [Union1044] = ([Expr1013], [@P4], [Expr1032], [Expr1042]), [Union1045] = ([T1].[_Fld2610RRef], [T6].[_Fld2610RRef], [T11].[_Fld2610RRef], [T16].[_Fld2610RRef]) 610506 0 0,0610506 4043 34,9398 [Union1043], [Union1044], [Union1045] PLAN_ROW 0 1
|--Sort(DISTINCT ORDER BY:([T3].[_Q_000_F_000RRef] ASC, [T1].[_Fld2610RRef] ASC)) 0 3 2 Sort Distinct Sort DISTINCT ORDER BY:([T3].[_Q_000_F_000RRef] ASC, [T1].[_Fld2610RRef] ASC) 604,174 0,0112613 0,000662694 53 9,96545 [T1].[_Fld2610RRef], [T3].[_Q_000_F_000RRef], [Expr1013] PLAN_ROW 0 1
| |--Compute Scalar(DEFINE:([Expr1013]=CONVERT(nvarchar(10),[@P1],0))) 0 4 3 Compute Scalar Compute Scalar DEFINE:([Expr1013]=CONVERT(nvarchar(10),[@P1],0)) [Expr1013]=CONVERT(nvarchar(10),[@P1],0) 60,8497 0 6,08497E-006 53 9,95353 [T1].[_Fld2610RRef], [T3].[_Q_000_F_000RRef], [Expr1013] PLAN_ROW 0 1
| |--Hash Match(Inner Join, HASH:([T2].[_IDRRef])=([T3].[_Q_000_F_003RRef]), RESIDUAL:([Streloy_Copy_3].[dbo].[_Reference53].[_IDRRef] as [T2].[_IDRRef]=[tempdb].[dbo].[#tt4].[_Q_000_F_003RRef] as [T3].[_Q_000_F_003RRef])) 0 5 4 Hash Match Inner Join HASH:([T2].[_IDRRef])=([T3].[_Q_000_F_003RRef]), RESIDUAL:([Streloy_Copy_3].[dbo].[_Reference53].[_IDRRef] as [T2].[_IDRRef]=[tempdb].[dbo].[#tt4].[_Q_000_F_003RRef] as [T3].[_Q_000_F_003RRef]) 60,8497 0 0,0191221 39 9,95352 [T1].[_Fld2610RRef], [T3].[_Q_000_F_000RRef] PLAN_ROW 0 1
| |--Hash Match(Aggregate, HASH:([T1].[_Fld2610RRef], [T2].[_IDRRef]), RESIDUAL:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2610RRef] as [T1].[_Fld2610RRef] = [Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2610RRef] as [T1].[_Fld2610RRef] AND [Streloy_Copy_3].[dbo].[_Reference53].[_IDRRef] as [T2].[_IDRRef] = [Streloy_Copy_3].[dbo].[_Reference53].[_IDRRef] as [T2].[_IDRRef])) 0 6 5 Hash Match Aggregate HASH:([T1].[_Fld2610RRef], [T2].[_IDRRef]), RESIDUAL:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2610RRef] as [T1].[_Fld2610RRef] = [Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2610RRef] as [T1].[_Fld2610RRef] AND [Streloy_Copy_3].[dbo].[_Reference53].[_IDRRef] as [T2].[_IDRRef] = [Streloy_Copy_3].[dbo].[_Reference53].[_IDRRef] as [T2].[_IDRRef]) 22,7039 0 1,1447 39 9,92905 [T1].[_Fld2610RRef], [T2].[_IDRRef] PLAN_ROW 0 1
| | |--Merge Join(Inner Join, MANY-TO-MANY MERGE:([T5].[_Fld2608_TYPE], [T5].[_Fld2608_RTRef])=([T2].[_Fld967_TYPE], [T2].[_Fld967_RTRef]), RESIDUAL:([Streloy_Copy_3].[dbo].[_Reference53].[_Fld967_TYPE] as [T2].[_Fld967_TYPE]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_TYPE] as [T5].[_Fld2608_TYPE] AND [Streloy_Copy_3].[dbo].[_Reference53].[_Fld967_RTRef] as [T2].[_Fld967_RTRef]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RTRef] as [T5].[_Fld2608_RTRef])) 0 7 6 Merge Join Inner Join MANY-TO-MANY MERGE:([T5].[_Fld2608_TYPE], [T5].[_Fld2608_RTRef])=([T2].[_Fld967_TYPE], [T2].[_Fld967_RTRef]), RESIDUAL:([Streloy_Copy_3].[dbo].[_Reference53].[_Fld967_TYPE] as [T2].[_Fld967_TYPE]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_TYPE] as [T5].[_Fld2608_TYPE] AND [Streloy_Copy_3].[dbo].[_Reference53].[_Fld967_RTRef] as [T2].[_Fld967_RTRef]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RTRef] as [T5].[_Fld2608_RTRef]) 172304 0,000626 0,957417 39 8,78435 [T1].[_Fld2610RRef], [T2].[_IDRRef] PLAN_ROW 0 1
| | |--Merge Join(Inner Join, MANY-TO-MANY MERGE:([T1].[_Fld2608_TYPE], [T1].[_Fld2608_RTRef])=([T5].[_Fld2608_TYPE], [T5].[_Fld2608_RTRef]), RESIDUAL:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_TYPE] as [T1].[_Fld2608_TYPE]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_TYPE] as [T5].[_Fld2608_TYPE] AND [Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RTRef] as [T1].[_Fld2608_RTRef]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RTRef] as [T5].[_Fld2608_RTRef] AND [Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RRRef] as [T1].[_Fld2608_RRRef]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RRRef] as [T5].[_Fld2608_RRRef] AND [Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2609] as [T1].[_Fld2609]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2609] as [T5].[_Fld2609])) 0 8 7 Merge Join Inner Join MANY-TO-MANY MERGE:([T1].[_Fld2608_TYPE], [T1].[_Fld2608_RTRef])=([T5].[_Fld2608_TYPE], [T5].[_Fld2608_RTRef]), RESIDUAL:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_TYPE] as [T1].[_Fld2608_TYPE]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_TYPE] as [T5].[_Fld2608_TYPE] AND [Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RTRef] as [T1].[_Fld2608_RTRef]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RTRef] as [T5].[_Fld2608_RTRef] AND [Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RRRef] as [T1].[_Fld2608_RRRef]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RRRef] as [T5].[_Fld2608_RRRef] AND [Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2609] as [T1].[_Fld2609]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2609] as [T5].[_Fld2609]) 164457 0,000313 2,10871 33 7,81736 [T1].[_Fld2608_TYPE], [T1].[_Fld2608_RTRef], [T1].[_Fld2610RRef], [T5].[_Fld2608_TYPE], [T5].[_Fld2608_RTRef] PLAN_ROW 0 1
| | | |--Clustered Index Scan(OBJECT:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_InfoRg2607_ByDims_RNRR] AS [T1]), ORDERED FORWARD) 0 9 8 Clustered Index Scan Clustered Index Scan OBJECT:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_InfoRg2607_ByDims_RNRR] AS [T1]), ORDERED FORWARD [T1].[_Fld2608_TYPE], [T1].[_Fld2608_RTRef], [T1].[_Fld2608_RRRef], [T1].[_Fld2609], [T1].[_Fld2610RRef] 163454 2,63498 0,179956 53 2,81493 [T1].[_Fld2608_TYPE], [T1].[_Fld2608_RTRef], [T1].[_Fld2608_RRRef], [T1].[_Fld2609], [T1].[_Fld2610RRef] PLAN_ROW 0 1
| | | |--Clustered Index Scan(OBJECT:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_InfoRg2607_ByDims_RNRR] AS [T5]), WHERE:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2612] as [T5].[_Fld2612]=0x01) ORDERED FORWARD) 0 10 8 Clustered Index Scan Clustered Index Scan OBJECT:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_InfoRg2607_ByDims_RNRR] AS [T5]), WHERE:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2612] as [T5].[_Fld2612]=0x01) ORDERED FORWARD [T5].[_Fld2608_TYPE], [T5].[_Fld2608_RTRef], [T5].[_Fld2608_RRRef], [T5].[_Fld2609] 156009 2,63498 0,179956 38 2,81493 [T5].[_Fld2608_TYPE], [T5].[_Fld2608_RTRef], [T5].[_Fld2608_RRRef], [T5].[_Fld2609] PLAN_ROW 0 1
| | |--Index Scan(OBJECT:([Streloy_Copy_3].[dbo].[_Reference53].[_Referenc53_ByField975_RR] AS [T2]), ORDERED FORWARD) 0 12 7 Index Scan Index Scan OBJECT:([Streloy_Copy_3].[dbo].[_Reference53].[_Referenc53_ByField975_RR] AS [T2]), ORDERED FORWARD [T2].[_IDRRef], [T2].[_Fld967_TYPE], [T2].[_Fld967_RTRef] 1106 0,00756944 0,0013736 28 0,00894304 [T2].[_IDRRef], [T2].[_Fld967_TYPE], [T2].[_Fld967_RTRef] PLAN_ROW 0 1
| |--Table Scan(OBJECT:([tempdb].[dbo].[#tt4] AS [T3]), WHERE:([tempdb].[dbo].[#tt4].[_Q_000_F_002RRef] as [T3].[_Q_000_F_002RRef]=[@P3] AND [tempdb].[dbo].[#tt4].[_Q_000_F_001] as [T3].[_Q_000_F_001]=[@P2])) 0 15 5 Table Scan Table Scan OBJECT:([tempdb].[dbo].[#tt4] AS [T3]), WHERE:([tempdb].[dbo].[#tt4].[_Q_000_F_002RRef] as [T3].[_Q_000_F_002RRef]=[@P3] AND [tempdb].[dbo].[#tt4].[_Q_000_F_001] as [T3].[_Q_000_F_001]=[@P2]) [T3].[_Q_000_F_000RRef], [T3].[_Q_000_F_003RRef] 86,0648 0,00460648 0,0004793 74 0,00508578 [T3].[_Q_000_F_000RRef], [T3].[_Q_000_F_003RRef] PLAN_ROW 0 1
|--Hash Match(Inner Join, HASH:([T8].[_Q_000_F_003RRef])=([T7].[_IDRRef]), RESIDUAL:([Streloy_Copy_3].[dbo].[_Reference53].[_IDRRef] as [T7].[_IDRRef]=[tempdb].[dbo].[#tt4].[_Q_000_F_003RRef] as [T8].[_Q_000_F_003RRef])) 0 20 2 Hash Match Inner Join HASH:([T8].[_Q_000_F_003RRef])=([T7].[_IDRRef]), RESIDUAL:([Streloy_Copy_3].[dbo].[_Reference53].[_IDRRef] as [T7].[_IDRRef]=[tempdb].[dbo].[#tt4].[_Q_000_F_003RRef] as [T8].[_Q_000_F_003RRef]) 277041 0 1,47444 39 10,2118 [T6].[_Fld2610RRef], [T8].[_Q_000_F_000RRef] PLAN_ROW 0 1
| |--Table Scan(OBJECT:([tempdb].[dbo].[#tt4] AS [T8]), WHERE:([tempdb].[dbo].[#tt4].[_Q_000_F_002RRef] as [T8].[_Q_000_F_002RRef]=[@P6] AND [tempdb].[dbo].[#tt4].[_Q_000_F_001] as [T8].[_Q_000_F_001]=[@P5])) 0 21 20 Table Scan Table Scan OBJECT:([tempdb].[dbo].[#tt4] AS [T8]), WHERE:([tempdb].[dbo].[#tt4].[_Q_000_F_002RRef] as [T8].[_Q_000_F_002RRef]=[@P6] AND [tempdb].[dbo].[#tt4].[_Q_000_F_001] as [T8].[_Q_000_F_001]=[@P5]) [T8].[_Q_000_F_000RRef], [T8].[_Q_000_F_003RRef] 37,0478 0,00460648 0,0004793 74 0,00508578 [T8].[_Q_000_F_000RRef], [T8].[_Q_000_F_003RRef] PLAN_ROW 0 1
| |--Merge Join(Inner Join, MANY-TO-MANY MERGE:([T10].[_Fld2608_TYPE], [T10].[_Fld2608_RTRef])=([T7].[_Fld967_TYPE], [T7].[_Fld967_RTRef]), RESIDUAL:([Streloy_Copy_3].[dbo].[_Reference53].[_Fld967_TYPE] as [T7].[_Fld967_TYPE]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_TYPE] as [T10].[_Fld2608_TYPE] AND [Streloy_Copy_3].[dbo].[_Reference53].[_Fld967_RTRef] as [T7].[_Fld967_RTRef]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RTRef] as [T10].[_Fld2608_RTRef])) 0 22 20 Merge Join Inner Join MANY-TO-MANY MERGE:([T10].[_Fld2608_TYPE], [T10].[_Fld2608_RTRef])=([T7].[_Fld967_TYPE], [T7].[_Fld967_RTRef]), RESIDUAL:([Streloy_Copy_3].[dbo].[_Reference53].[_Fld967_TYPE] as [T7].[_Fld967_TYPE]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_TYPE] as [T10].[_Fld2608_TYPE] AND [Streloy_Copy_3].[dbo].[_Reference53].[_Fld967_RTRef] as [T7].[_Fld967_RTRef]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RTRef] as [T10].[_Fld2608_RTRef]) 172304 0,000626 0,938793 39 8,73205 [T6].[_Fld2610RRef], [T7].[_IDRRef] PLAN_ROW 0 1
| |--Merge Join(Inner Join, MANY-TO-MANY MERGE:([T6].[_Fld2608_TYPE], [T6].[_Fld2608_RTRef])=([T10].[_Fld2608_TYPE], [T10].[_Fld2608_RTRef]), RESIDUAL:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_TYPE] as [T6].[_Fld2608_TYPE]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_TYPE] as [T10].[_Fld2608_TYPE] AND [Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RTRef] as [T6].[_Fld2608_RTRef]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RTRef] as [T10].[_Fld2608_RTRef] AND [Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RRRef] as [T6].[_Fld2608_RRRef]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RRRef] as [T10].[_Fld2608_RRRef] AND [Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2609] as [T6].[_Fld2609]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2609] as [T10].[_Fld2609])) 0 23 22 Merge Join Inner Join MANY-TO-MANY MERGE:([T6].[_Fld2608_TYPE], [T6].[_Fld2608_RTRef])=([T10].[_Fld2608_TYPE], [T10].[_Fld2608_RTRef]), RESIDUAL:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_TYPE] as [T6].[_Fld2608_TYPE]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_TYPE] as [T10].[_Fld2608_TYPE] AND [Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RTRef] as [T6].[_Fld2608_RTRef]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RTRef] as [T10].[_Fld2608_RTRef] AND [Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RRRef] as [T6].[_Fld2608_RRRef]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RRRef] as [T10].[_Fld2608_RRRef] AND [Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2609] as [T6].[_Fld2609]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2609] as [T10].[_Fld2609]) 158478 0,000313 2,07503 33 7,78369 [T6].[_Fld2608_TYPE], [T6].[_Fld2608_RTRef], [T6].[_Fld2610RRef], [T10].[_Fld2608_TYPE], [T10].[_Fld2608_RTRef] PLAN_ROW 0 1
| | |--Clustered Index Scan(OBJECT:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_InfoRg2607_ByDims_RNRR] AS [T6]), ORDERED FORWARD) 0 24 23 Clustered Index Scan Clustered Index Scan OBJECT:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_InfoRg2607_ByDims_RNRR] AS [T6]), ORDERED FORWARD [T6].[_Fld2608_TYPE], [T6].[_Fld2608_RTRef], [T6].[_Fld2608_RRRef], [T6].[_Fld2609], [T6].[_Fld2610RRef] 163454 2,63498 0,179956 53 2,81493 [T6].[_Fld2608_TYPE], [T6].[_Fld2608_RTRef], [T6].[_Fld2608_RRRef], [T6].[_Fld2609], [T6].[_Fld2610RRef] PLAN_ROW 0 1
| | |--Clustered Index Scan(OBJECT:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_InfoRg2607_ByDims_RNRR] AS [T10]), WHERE:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2613] as [T10].[_Fld2613]=0x01) ORDERED FORWARD) 0 25 23 Clustered Index Scan Clustered Index Scan OBJECT:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_InfoRg2607_ByDims_RNRR] AS [T10]), WHERE:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2613] as [T10].[_Fld2613]=0x01) ORDERED FORWARD [T10].[_Fld2608_TYPE], [T10].[_Fld2608_RTRef], [T10].[_Fld2608_RRRef], [T10].[_Fld2609] 150337 2,63498 0,179956 38 2,81493 [T10].[_Fld2608_TYPE], [T10].[_Fld2608_RTRef], [T10].[_Fld2608_RRRef], [T10].[_Fld2609] PLAN_ROW 0 1
| |--Index Scan(OBJECT:([Streloy_Copy_3].[dbo].[_Reference53].[_Referenc53_ByField975_RR] AS [T7]), ORDERED FORWARD) 0 27 22 Index Scan Index Scan OBJECT:([Streloy_Copy_3].[dbo].[_Reference53].[_Referenc53_ByField975_RR] AS [T7]), ORDERED FORWARD [T7].[_IDRRef], [T7].[_Fld967_TYPE], [T7].[_Fld967_RTRef] 1106 0,00756944 0,0013736 28 0,00894304 [T7].[_IDRRef], [T7].[_Fld967_TYPE], [T7].[_Fld967_RTRef] PLAN_ROW 0 1
|--Compute Scalar(DEFINE:([Expr1032]=CONVERT(nvarchar(10),[@P7],0))) 0 30 2 Compute Scalar Compute Scalar DEFINE:([Expr1032]=CONVERT(nvarchar(10),[@P7],0)) [Expr1032]=CONVERT(nvarchar(10),[@P7],0) 300170 0 0,030017 53 10,2732 [T11].[_Fld2610RRef], [T13].[_Q_000_F_000RRef], [Expr1032] PLAN_ROW 0 1
| |--Hash Match(Inner Join, HASH:([T13].[_Q_000_F_003RRef])=([T12].[_IDRRef]), RESIDUAL:([Streloy_Copy_3].[dbo].[_Reference53].[_IDRRef] as [T12].[_IDRRef]=[tempdb].[dbo].[#tt4].[_Q_000_F_003RRef] as [T13].[_Q_000_F_003RRef])) 0 31 30 Hash Match Inner Join HASH:([T13].[_Q_000_F_003RRef])=([T12].[_IDRRef]), RESIDUAL:([Streloy_Copy_3].[dbo].[_Reference53].[_IDRRef] as [T12].[_IDRRef]=[tempdb].[dbo].[#tt4].[_Q_000_F_003RRef] as [T13].[_Q_000_F_003RRef]) 300170 0 1,50576 39 10,2432 [T11].[_Fld2610RRef], [T13].[_Q_000_F_000RRef] PLAN_ROW 0 1
| |--Table Scan(OBJECT:([tempdb].[dbo].[#tt4] AS [T13]), WHERE:([tempdb].[dbo].[#tt4].[_Q_000_F_002RRef] as [T13].[_Q_000_F_002RRef]=[@P9] AND [tempdb].[dbo].[#tt4].[_Q_000_F_001] as [T13].[_Q_000_F_001]=[@P8])) 0 32 31 Table Scan Table Scan OBJECT:([tempdb].[dbo].[#tt4] AS [T13]), WHERE:([tempdb].[dbo].[#tt4].[_Q_000_F_002RRef] as [T13].[_Q_000_F_002RRef]=[@P9] AND [tempdb].[dbo].[#tt4].[_Q_000_F_001] as [T13].[_Q_000_F_001]=[@P8]) [T13].[_Q_000_F_000RRef], [T13].[_Q_000_F_003RRef] 43,8874 0,00460648 0,0004793 74 0,00508578 [T13].[_Q_000_F_000RRef], [T13].[_Q_000_F_003RRef] PLAN_ROW 0 1
| |--Merge Join(Inner Join, MANY-TO-MANY MERGE:([T15].[_Fld2608_TYPE], [T15].[_Fld2608_RTRef])=([T12].[_Fld967_TYPE], [T12].[_Fld967_RTRef]), RESIDUAL:([Streloy_Copy_3].[dbo].[_Reference53].[_Fld967_TYPE] as [T12].[_Fld967_TYPE]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_TYPE] as [T15].[_Fld2608_TYPE] AND [Streloy_Copy_3].[dbo].[_Reference53].[_Fld967_RTRef] as [T12].[_Fld967_RTRef]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RTRef] as [T15].[_Fld2608_RTRef])) 0 33 31 Merge Join Inner Join MANY-TO-MANY MERGE:([T15].[_Fld2608_TYPE], [T15].[_Fld2608_RTRef])=([T12].[_Fld967_TYPE], [T12].[_Fld967_RTRef]), RESIDUAL:([Streloy_Copy_3].[dbo].[_Reference53].[_Fld967_TYPE] as [T12].[_Fld967_TYPE]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_TYPE] as [T15].[_Fld2608_TYPE] AND [Streloy_Copy_3].[dbo].[_Reference53].[_Fld967_RTRef] as [T12].[_Fld967_RTRef]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RTRef] as [T15].[_Fld2608_RTRef]) 172304 0,000626 0,938793 39 8,73205 [T11].[_Fld2610RRef], [T12].[_IDRRef] PLAN_ROW 0 1
| |--Merge Join(Inner Join, MANY-TO-MANY MERGE:([T11].[_Fld2608_TYPE], [T11].[_Fld2608_RTRef])=([T15].[_Fld2608_TYPE], [T15].[_Fld2608_RTRef]), RESIDUAL:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_TYPE] as [T11].[_Fld2608_TYPE]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_TYPE] as [T15].[_Fld2608_TYPE] AND [Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RTRef] as [T11].[_Fld2608_RTRef]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RTRef] as [T15].[_Fld2608_RTRef] AND [Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RRRef] as [T11].[_Fld2608_RRRef]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RRRef] as [T15].[_Fld2608_RRRef] AND [Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2609] as [T11].[_Fld2609]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2609] as [T15].[_Fld2609])) 0 34 33 Merge Join Inner Join MANY-TO-MANY MERGE:([T11].[_Fld2608_TYPE], [T11].[_Fld2608_RTRef])=([T15].[_Fld2608_TYPE], [T15].[_Fld2608_RTRef]), RESIDUAL:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_TYPE] as [T11].[_Fld2608_TYPE]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_TYPE] as [T15].[_Fld2608_TYPE] AND [Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RTRef] as [T11].[_Fld2608_RTRef]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RTRef] as [T15].[_Fld2608_RTRef] AND [Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RRRef] as [T11].[_Fld2608_RRRef]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RRRef] as [T15].[_Fld2608_RRRef] AND [Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2609] as [T11].[_Fld2609]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2609] as [T15].[_Fld2609]) 158478 0,000313 2,07503 33 7,78369 [T11].[_Fld2608_TYPE], [T11].[_Fld2608_RTRef], [T11].[_Fld2610RRef], [T15].[_Fld2608_TYPE], [T15].[_Fld2608_RTRef] PLAN_ROW 0 1
| | |--Clustered Index Scan(OBJECT:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_InfoRg2607_ByDims_RNRR] AS [T11]), ORDERED FORWARD) 0 35 34 Clustered Index Scan Clustered Index Scan OBJECT:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_InfoRg2607_ByDims_RNRR] AS [T11]), ORDERED FORWARD [T11].[_Fld2608_TYPE], [T11].[_Fld2608_RTRef], [T11].[_Fld2608_RRRef], [T11].[_Fld2609], [T11].[_Fld2610RRef] 163454 2,63498 0,179956 53 2,81493 [T11].[_Fld2608_TYPE], [T11].[_Fld2608_RTRef], [T11].[_Fld2608_RRRef], [T11].[_Fld2609], [T11].[_Fld2610RRef] PLAN_ROW 0 1
| | |--Clustered Index Scan(OBJECT:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_InfoRg2607_ByDims_RNRR] AS [T15]), WHERE:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2614] as [T15].[_Fld2614]=0x01) ORDERED FORWARD) 0 36 34 Clustered Index Scan Clustered Index Scan OBJECT:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_InfoRg2607_ByDims_RNRR] AS [T15]), WHERE:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2614] as [T15].[_Fld2614]=0x01) ORDERED FORWARD [T15].[_Fld2608_TYPE], [T15].[_Fld2608_RTRef], [T15].[_Fld2608_RRRef], [T15].[_Fld2609] 150337 2,63498 0,179956 38 2,81493 [T15].[_Fld2608_TYPE], [T15].[_Fld2608_RTRef], [T15].[_Fld2608_RRRef], [T15].[_Fld2609] PLAN_ROW 0 1
| |--Index Scan(OBJECT:([Streloy_Copy_3].[dbo].[_Reference53].[_Referenc53_ByField975_RR] AS [T12]), ORDERED FORWARD) 0 38 33 Index Scan Index Scan OBJECT:([Streloy_Copy_3].[dbo].[_Reference53].[_Referenc53_ByField975_RR] AS [T12]), ORDERED FORWARD [T12].[_IDRRef], [T12].[_Fld967_TYPE], [T12].[_Fld967_RTRef] 1106 0,00756944 0,0013736 28 0,00894304 [T12].[_IDRRef], [T12].[_Fld967_TYPE], [T12].[_Fld967_RTRef] PLAN_ROW 0 1
|--Compute Scalar(DEFINE:([Expr1042]=CONVERT(nvarchar(10),[@P10],0))) 0 44 2 Compute Scalar Compute Scalar DEFINE:([Expr1042]=CONVERT(nvarchar(10),[@P10],0)) [Expr1042]=CONVERT(nvarchar(10),[@P10],0) 32690,8 0 0,00326908 53 4,42831 [T16].[_Fld2610RRef], [T18].[_Q_000_F_000RRef], [Expr1042] PLAN_ROW 0 1
|--Hash Match(Inner Join, HASH:([T20].[_Fld2608_TYPE], [T20].[_Fld2608_RTRef], [T20].[_Fld2608_RRRef], [T20].[_Fld2609])=([T16].[_Fld2608_TYPE], [T16].[_Fld2608_RTRef], [T16].[_Fld2608_RRRef], [T16].[_Fld2609]), RESIDUAL:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_TYPE] as [T16].[_Fld2608_TYPE]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_TYPE] as [T20].[_Fld2608_TYPE] AND [Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RTRef] as [T16].[_Fld2608_RTRef]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RTRef] as [T20].[_Fld2608_RTRef] AND [Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RRRef] as [T16].[_Fld2608_RRRef]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RRRef] as [T20].[_Fld2608_RRRef] AND [Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2609] as [T16].[_Fld2609]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2609] as [T20].[_Fld2609])) 0 45 44 Hash Match Inner Join HASH:([T20].[_Fld2608_TYPE], [T20].[_Fld2608_RTRef], [T20].[_Fld2608_RRRef], [T20].[_Fld2609])=([T16].[_Fld2608_TYPE], [T16].[_Fld2608_RTRef], [T16].[_Fld2608_RRRef], [T16].[_Fld2609]), RESIDUAL:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_TYPE] as [T16].[_Fld2608_TYPE]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_TYPE] as [T20].[_Fld2608_TYPE] AND [Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RTRef] as [T16].[_Fld2608_RTRef]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RTRef] as [T20].[_Fld2608_RTRef] AND [Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RRRef] as [T16].[_Fld2608_RRRef]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2608_RRRef] as [T20].[_Fld2608_RRRef] AND [Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2609] as [T16].[_Fld2609]=[Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2609] as [T20].[_Fld2609]) 32690,8 0 2,43716 39 4,42504 [T16].[_Fld2610RRef], [T18].[_Q_000_F_000RRef] PLAN_ROW 0 1
|--Nested Loops(Inner Join, OUTER REFERENCES:([T17].[_Fld967_TYPE], [T17].[_Fld967_RTRef])) 0 46 45 Nested Loops Inner Join OUTER REFERENCES:([T17].[_Fld967_TYPE], [T17].[_Fld967_RTRef]) 27583,7 0 0,1153 53 0,70479 [T18].[_Q_000_F_000RRef], [T20].[_Fld2608_TYPE], [T20].[_Fld2608_RTRef], [T20].[_Fld2608_RRRef], [T20].[_Fld2609] PLAN_ROW 0 1
| |--Nested Loops(Inner Join, OUTER REFERENCES:([T18].[_Q_000_F_003RRef])) 0 47 46 Nested Loops Inner Join OUTER REFERENCES:([T18].[_Q_000_F_003RRef]) 1 0 4,18E-006 28 0,0086309 [T17].[_Fld967_TYPE], [T17].[_Fld967_RTRef], [T18].[_Q_000_F_000RRef] PLAN_ROW 0 1
| | |--Table Scan(OBJECT:([tempdb].[dbo].[#tt4] AS [T18]), WHERE:([tempdb].[dbo].[#tt4].[_Q_000_F_002RRef] as [T18].[_Q_000_F_002RRef]=[@P12] AND [tempdb].[dbo].[#tt4].[_Q_000_F_001] as [T18].[_Q_000_F_001]=[@P11])) 0 48 47 Table Scan Table Scan OBJECT:([tempdb].[dbo].[#tt4] AS [T18]), WHERE:([tempdb].[dbo].[#tt4].[_Q_000_F_002RRef] as [T18].[_Q_000_F_002RRef]=[@P12] AND [tempdb].[dbo].[#tt4].[_Q_000_F_001] as [T18].[_Q_000_F_001]=[@P11]) [T18].[_Q_000_F_000RRef], [T18].[_Q_000_F_003RRef] 1 0,00460648 0,0004793 74 0,00508578 [T18].[_Q_000_F_000RRef], [T18].[_Q_000_F_003RRef] PLAN_ROW 0 1
| | |--Clustered Index Seek(OBJECT:([Streloy_Copy_3].[dbo].[_Reference53].[PK___Referen__AC8ED0C4E284BB78] AS [T17]), SEEK:([T17].[_IDRRef]=[tempdb].[dbo].[#tt4].[_Q_000_F_003RRef] as [T18].[_Q_000_F_003RRef]) ORDERED FORWARD) 0 49 47 Clustered Index Seek Clustered Index Seek OBJECT:([Streloy_Copy_3].[dbo].[_Reference53].[PK___Referen__AC8ED0C4E284BB78] AS [T17]), SEEK:([T17].[_IDRRef]=[tempdb].[dbo].[#tt4].[_Q_000_F_003RRef] as [T18].[_Q_000_F_003RRef]) ORDERED FORWARD [T17].[_Fld967_TYPE], [T17].[_Fld967_RTRef] 1 0,003125 0,0001581 12 0,0032831 [T17].[_Fld967_TYPE], [T17].[_Fld967_RTRef] PLAN_ROW 0 1
| |--Clustered Index Seek(OBJECT:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_InfoRg2607_ByDims_RNRR] AS [T20]), SEEK:([T20].[_Fld2608_TYPE]=[Streloy_Copy_3].[dbo].[_Reference53].[_Fld967_TYPE] as [T17].[_Fld967_TYPE] AND [T20].[_Fld2608_RTRef]=[Streloy_Copy_3].[dbo].[_Reference53].[_Fld967_RTRef] as [T17].[_Fld967_RTRef]), WHERE:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2615] as [T20].[_Fld2615]=0x01) ORDERED FORWARD) 0 50 46 Clustered Index Seek Clustered Index Seek OBJECT:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_InfoRg2607_ByDims_RNRR] AS [T20]), SEEK:([T20].[_Fld2608_TYPE]=[Streloy_Copy_3].[dbo].[_Reference53].[_Fld967_TYPE] as [T17].[_Fld967_TYPE] AND [T20].[_Fld2608_RTRef]=[Streloy_Copy_3].[dbo].[_Reference53].[_Fld967_RTRef] as [T17].[_Fld967_RTRef]), WHERE:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_Fld2615] as [T20].[_Fld2615]=0x01) ORDERED FORWARD [T20].[_Fld2608_TYPE], [T20].[_Fld2608_RTRef], [T20].[_Fld2608_RRRef], [T20].[_Fld2609] 27583,7 0,529051 0,0361169 38 0,565168 [T20].[_Fld2608_TYPE], [T20].[_Fld2608_RTRef], [T20].[_Fld2608_RRRef], [T20].[_Fld2609] PLAN_ROW 0 1
|--Index Scan(OBJECT:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_InfoRg2607_ByDims2626_RRNR] AS [T16])) 0 51 45 Index Scan Index Scan OBJECT:([Streloy_Copy_3].[dbo].[_InfoRg2607].[_InfoRg2607_ByDims2626_RRNR] AS [T16]) [T16].[_Fld2608_TYPE], [T16].[_Fld2608_RTRef], [T16].[_Fld2608_RRRef], [T16].[_Fld2609], [T16].[_Fld2610RRef] 163454 1,10312 0,179956 53 1,28308 [T16].[_Fld2608_TYPE], [T16].[_Fld2608_RTRef], [T16].[_Fld2608_RRRef], [T16].[_Fld2609], [T16].[_Fld2610RRef] PLAN_ROW 0 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment