API tools faq
paste
Guest User

Untitled

a guest
Feb 27th, 2018
434
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 40.61 KB | None | 0 0
raw download clone embed print report
  1. <?xml version="1.0" encoding="utf-16"?>
  2. <ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.2" Build="12.0.2000.8" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
  3. <BatchSequence>
  4. <Batch>
  5. <Statements>
  6. <StmtSimple StatementCompId="1" StatementEstRows="3.68273" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="TimeOut" CardinalityEstimationModelVersion="120" StatementSubTreeCost="2.22075" StatementText="SELECT DISTINCT&#xD;&#xA;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;evig.entityId&#xD;&#xA;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;, gle.id&#xD;&#xA;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;, gle.code&#xD;&#xA;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;, gle.name&#xD;&#xA;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;FROM [Junifer].[ExtraValueInstGroup] evig&#xD;&#xA; &#xD;&#xA;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;INNER JOIN [Junifer].[ExtraValueDfnGroup] evdg&#xD;&#xA;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;ON evdg.ID = evig.extraValueDfnGroupFk&#xD;&#xA;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;AND evdg.name = 'GDFS'&#xD;&#xA;&#xD;&#xA;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;INNER JOIN [Junifer].[PropertyDfnGroup] pfg&#xD;&#xA;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;ON pfg.id = evdg.propertyDfnGroupFk&#xD;&#xA;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;AND pfg.internalKey = 'Product Item Dfn_GDFS'&#xD;&#xA;&#xD;&#xA;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;INNER JOIN [Junifer].[PropertyInstGroup] pig&#xD;&#xA;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;ON pig.id = evig.propertyInstGroupFk&#xD;&#xA;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;AND pig.propertyDfnGroupFk = pfg.id&#xD;&#xA;&#xD;&#xA;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;INNER JOIN [Junifer].[PropertyInst] pit&#xD;&#xA;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;ON pit.propertyInstGroupFk = pig.id&#xD;&#xA;&#xD;&#xA;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;INNER JOIN [Junifer].[GeneralLedgerCode] gle&#xD;&#xA;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;ON gle.id = pit.valueStr&#xD;&#xA;-- 08/01/2017 - SR&#xD;&#xA;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;&#x9;AND ISNUMERIC(pit.valueStr) = 1" StatementType="SELECT" QueryHash="0x79C0783AAC87B8FB" QueryPlanHash="0x19F11FAF1147DB05" RetrievedFromCache="true">
  7. <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
  8. <QueryPlan DegreeOfParallelism="1" MemoryGrant="5432" CachedPlanSize="152" CompileTime="42" CompileCPU="21" CompileMemory="1168">
  9. <MissingIndexes>
  10. <MissingIndexGroup Impact="20.1637">
  11. <MissingIndex Database="[staging]" Schema="[Junifer]" Table="[ExtraValueInstGroup]">
  12. <ColumnGroup Usage="EQUALITY">
  13. <Column Name="[extraValueDfnGroupFk]" ColumnId="2" />
  14. </ColumnGroup>
  15. <ColumnGroup Usage="INCLUDE">
  16. <Column Name="[propertyInstGroupFk]" ColumnId="3" />
  17. <Column Name="[entityId]" ColumnId="4" />
  18. </ColumnGroup>
  19. </MissingIndex>
  20. </MissingIndexGroup>
  21. <MissingIndexGroup Impact="29.7937">
  22. <MissingIndex Database="[staging]" Schema="[Junifer]" Table="[PropertyInstGroup]">
  23. <ColumnGroup Usage="EQUALITY">
  24. <Column Name="[id]" ColumnId="1" />
  25. <Column Name="[propertyDfnGroupFk]" ColumnId="3" />
  26. </ColumnGroup>
  27. </MissingIndex>
  28. </MissingIndexGroup>
  29. <MissingIndexGroup Impact="27.4017">
  30. <MissingIndex Database="[staging]" Schema="[Junifer]" Table="[PropertyInst]">
  31. <ColumnGroup Usage="EQUALITY">
  32. <Column Name="[propertyInstGroupFk]" ColumnId="2" />
  33. </ColumnGroup>
  34. <ColumnGroup Usage="INCLUDE">
  35. <Column Name="[valueStr]" ColumnId="4" />
  36. </ColumnGroup>
  37. </MissingIndex>
  38. </MissingIndexGroup>
  39. </MissingIndexes>
  40. <Warnings>
  41. <PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(int,[pit].[valueStr],0)" />
  42. </Warnings>
  43. <MemoryGrantInfo SerialRequiredMemory="3072" SerialDesiredMemory="5432" RequiredMemory="3072" DesiredMemory="5432" RequestedMemory="5432" GrantWaitTime="0" GrantedMemory="5432" MaxUsedMemory="2184" />
  44. <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="524288" EstimatedPagesCached="131072" EstimatedAvailableDegreeOfParallelism="2" />
  45. <RelOp AvgRowSize="81" EstimateCPU="0.059495" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3.68273" LogicalOp="Aggregate" NodeId="0" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="2.22075">
  46. <OutputList>
  47. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[ExtraValueInstGroup]" Alias="[evig]" Column="entityId" />
  48. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[GeneralLedgerCode]" Alias="[gle]" Column="id" />
  49. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[GeneralLedgerCode]" Alias="[gle]" Column="name" />
  50. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[GeneralLedgerCode]" Alias="[gle]" Column="code" />
  51. </OutputList>
  52. <Warnings>
  53. <SpillToTempDb SpillLevel="1" />
  54. </Warnings>
  55. <MemoryFractions Input="0.00677966" Output="1" />
  56. <RunTimeInformation>
  57. <RunTimeCountersPerThread Thread="0" ActualRows="10514" ActualEndOfScans="1" ActualExecutions="1" />
  58. </RunTimeInformation>
  59. <Hash>
  60. <DefinedValues />
  61. <HashKeysBuild>
  62. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[ExtraValueInstGroup]" Alias="[evig]" Column="entityId" />
  63. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[GeneralLedgerCode]" Alias="[gle]" Column="id" />
  64. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[GeneralLedgerCode]" Alias="[gle]" Column="code" />
  65. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[GeneralLedgerCode]" Alias="[gle]" Column="name" />
  66. </HashKeysBuild>
  67. <BuildResidual>
  68. <ScalarOperator ScalarString="[staging].[Junifer].[ExtraValueInstGroup].[entityId] as [evig].[entityId] = [staging].[Junifer].[ExtraValueInstGroup].[entityId] as [evig].[entityId] AND [staging].[Junifer].[GeneralLedgerCode].[id] as [gle].[id] = [staging].[Junifer].[GeneralLedgerCode].[id] as [gle].[id] AND [staging].[Junifer].[GeneralLedgerCode].[code] as [gle].[code] = [staging].[Junifer].[GeneralLedgerCode].[code] as [gle].[code] AND [staging].[Junifer].[GeneralLedgerCode].[name] as [gle].[name] = [staging].[Junifer].[GeneralLedgerCode].[name] as [gle].[name]">
  69. <Logical Operation="AND">
  70. <ScalarOperator>
  71. <Logical Operation="AND">
  72. <ScalarOperator>
  73. <Logical Operation="AND">
  74. <ScalarOperator>
  75. <Compare CompareOp="IS">
  76. <ScalarOperator>
  77. <Identifier>
  78. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[ExtraValueInstGroup]" Alias="[evig]" Column="entityId" />
  79. </Identifier>
  80. </ScalarOperator>
  81. <ScalarOperator>
  82. <Identifier>
  83. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[ExtraValueInstGroup]" Alias="[evig]" Column="entityId" />
  84. </Identifier>
  85. </ScalarOperator>
  86. </Compare>
  87. </ScalarOperator>
  88. <ScalarOperator>
  89. <Compare CompareOp="IS">
  90. <ScalarOperator>
  91. <Identifier>
  92. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[GeneralLedgerCode]" Alias="[gle]" Column="id" />
  93. </Identifier>
  94. </ScalarOperator>
  95. <ScalarOperator>
  96. <Identifier>
  97. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[GeneralLedgerCode]" Alias="[gle]" Column="id" />
  98. </Identifier>
  99. </ScalarOperator>
  100. </Compare>
  101. </ScalarOperator>
  102. </Logical>
  103. </ScalarOperator>
  104. <ScalarOperator>
  105. <Compare CompareOp="IS">
  106. <ScalarOperator>
  107. <Identifier>
  108. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[GeneralLedgerCode]" Alias="[gle]" Column="code" />
  109. </Identifier>
  110. </ScalarOperator>
  111. <ScalarOperator>
  112. <Identifier>
  113. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[GeneralLedgerCode]" Alias="[gle]" Column="code" />
  114. </Identifier>
  115. </ScalarOperator>
  116. </Compare>
  117. </ScalarOperator>
  118. </Logical>
  119. </ScalarOperator>
  120. <ScalarOperator>
  121. <Compare CompareOp="IS">
  122. <ScalarOperator>
  123. <Identifier>
  124. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[GeneralLedgerCode]" Alias="[gle]" Column="name" />
  125. </Identifier>
  126. </ScalarOperator>
  127. <ScalarOperator>
  128. <Identifier>
  129. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[GeneralLedgerCode]" Alias="[gle]" Column="name" />
  130. </Identifier>
  131. </ScalarOperator>
  132. </Compare>
  133. </ScalarOperator>
  134. </Logical>
  135. </ScalarOperator>
  136. </BuildResidual>
  137. <RelOp AvgRowSize="81" EstimateCPU="0.389428" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="6179.64" LogicalOp="Inner Join" NodeId="1" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="2.16126">
  138. <OutputList>
  139. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[ExtraValueInstGroup]" Alias="[evig]" Column="entityId" />
  140. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[GeneralLedgerCode]" Alias="[gle]" Column="id" />
  141. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[GeneralLedgerCode]" Alias="[gle]" Column="name" />
  142. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[GeneralLedgerCode]" Alias="[gle]" Column="code" />
  143. </OutputList>
  144. <MemoryFractions Input="0.105085" Output="0.180057" />
  145. <RunTimeInformation>
  146. <RunTimeCountersPerThread Thread="0" ActualRows="10514" ActualEndOfScans="1" ActualExecutions="1" />
  147. </RunTimeInformation>
  148. <Hash>
  149. <DefinedValues />
  150. <HashKeysBuild>
  151. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[GeneralLedgerCode]" Alias="[gle]" Column="id" />
  152. </HashKeysBuild>
  153. <HashKeysProbe>
  154. <ColumnReference Column="Expr1012" />
  155. </HashKeysProbe>
  156. <ProbeResidual>
  157. <ScalarOperator ScalarString="[staging].[Junifer].[GeneralLedgerCode].[id] as [gle].[id]=[Expr1012]">
  158. <Compare CompareOp="EQ">
  159. <ScalarOperator>
  160. <Identifier>
  161. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[GeneralLedgerCode]" Alias="[gle]" Column="id" />
  162. </Identifier>
  163. </ScalarOperator>
  164. <ScalarOperator>
  165. <Identifier>
  166. <ColumnReference Column="Expr1012" />
  167. </Identifier>
  168. </ScalarOperator>
  169. </Compare>
  170. </ScalarOperator>
  171. </ProbeResidual>
  172. <RelOp AvgRowSize="77" EstimateCPU="0.0002505" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="85" LogicalOp="Table Scan" NodeId="2" Parallel="false" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="0.0033755" TableCardinality="85">
  173. <OutputList>
  174. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[GeneralLedgerCode]" Alias="[gle]" Column="id" />
  175. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[GeneralLedgerCode]" Alias="[gle]" Column="name" />
  176. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[GeneralLedgerCode]" Alias="[gle]" Column="code" />
  177. </OutputList>
  178. <RunTimeInformation>
  179. <RunTimeCountersPerThread Thread="0" ActualRows="85" ActualEndOfScans="1" ActualExecutions="1" />
  180. </RunTimeInformation>
  181. <TableScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  182. <DefinedValues>
  183. <DefinedValue>
  184. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[GeneralLedgerCode]" Alias="[gle]" Column="id" />
  185. </DefinedValue>
  186. <DefinedValue>
  187. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[GeneralLedgerCode]" Alias="[gle]" Column="name" />
  188. </DefinedValue>
  189. <DefinedValue>
  190. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[GeneralLedgerCode]" Alias="[gle]" Column="code" />
  191. </DefinedValue>
  192. </DefinedValues>
  193. <Object Database="[staging]" Schema="[Junifer]" Table="[GeneralLedgerCode]" Alias="[gle]" IndexKind="Heap" Storage="RowStore" />
  194. </TableScan>
  195. </RelOp>
  196. <RelOp AvgRowSize="15" EstimateCPU="0.350526" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="51182" LogicalOp="Inner Join" NodeId="3" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="1.76845">
  197. <OutputList>
  198. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[ExtraValueInstGroup]" Alias="[evig]" Column="entityId" />
  199. <ColumnReference Column="Expr1012" />
  200. </OutputList>
  201. <MemoryFractions Input="0.474576" Output="0.813163" />
  202. <RunTimeInformation>
  203. <RunTimeCountersPerThread Thread="0" ActualRows="10514" ActualEndOfScans="1" ActualExecutions="1" />
  204. </RunTimeInformation>
  205. <Hash>
  206. <DefinedValues />
  207. <HashKeysBuild>
  208. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[PropertyInstGroup]" Alias="[pig]" Column="id" />
  209. </HashKeysBuild>
  210. <HashKeysProbe>
  211. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[PropertyInst]" Alias="[pit]" Column="propertyInstGroupFk" />
  212. </HashKeysProbe>
  213. <RelOp AvgRowSize="15" EstimateCPU="0.4848" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5108.58" LogicalOp="Inner Join" NodeId="4" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="1.15606">
  214. <OutputList>
  215. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[ExtraValueInstGroup]" Alias="[evig]" Column="entityId" />
  216. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[PropertyInstGroup]" Alias="[pig]" Column="id" />
  217. </OutputList>
  218. <MemoryFractions Input="0.77601" Output="0.420339" />
  219. <RunTimeInformation>
  220. <RunTimeCountersPerThread Thread="0" ActualRows="10514" ActualEndOfScans="1" ActualExecutions="1" />
  221. </RunTimeInformation>
  222. <Hash>
  223. <DefinedValues />
  224. <HashKeysBuild>
  225. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[PropertyDfnGroup]" Alias="[pfg]" Column="id" />
  226. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[ExtraValueInstGroup]" Alias="[evig]" Column="propertyInstGroupFk" />
  227. </HashKeysBuild>
  228. <HashKeysProbe>
  229. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[PropertyInstGroup]" Alias="[pig]" Column="propertyDfnGroupFk" />
  230. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[PropertyInstGroup]" Alias="[pig]" Column="id" />
  231. </HashKeysProbe>
  232. <ProbeResidual>
  233. <ScalarOperator ScalarString="[staging].[Junifer].[PropertyInstGroup].[propertyDfnGroupFk] as [pig].[propertyDfnGroupFk]=[staging].[Junifer].[PropertyDfnGroup].[id] as [pfg].[id] AND [staging].[Junifer].[PropertyInstGroup].[id] as [pig].[id]=[staging].[Junifer].[ExtraValueInstGroup].[propertyInstGroupFk] as [evig].[propertyInstGroupFk]">
  234. <Logical Operation="AND">
  235. <ScalarOperator>
  236. <Compare CompareOp="EQ">
  237. <ScalarOperator>
  238. <Identifier>
  239. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[PropertyInstGroup]" Alias="[pig]" Column="propertyDfnGroupFk" />
  240. </Identifier>
  241. </ScalarOperator>
  242. <ScalarOperator>
  243. <Identifier>
  244. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[PropertyDfnGroup]" Alias="[pfg]" Column="id" />
  245. </Identifier>
  246. </ScalarOperator>
  247. </Compare>
  248. </ScalarOperator>
  249. <ScalarOperator>
  250. <Compare CompareOp="EQ">
  251. <ScalarOperator>
  252. <Identifier>
  253. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[PropertyInstGroup]" Alias="[pig]" Column="id" />
  254. </Identifier>
  255. </ScalarOperator>
  256. <ScalarOperator>
  257. <Identifier>
  258. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[ExtraValueInstGroup]" Alias="[evig]" Column="propertyInstGroupFk" />
  259. </Identifier>
  260. </ScalarOperator>
  261. </Compare>
  262. </ScalarOperator>
  263. </Logical>
  264. </ScalarOperator>
  265. </ProbeResidual>
  266. <RelOp AvgRowSize="19" EstimateCPU="0.248775" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="6180.13" LogicalOp="Inner Join" NodeId="5" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="0.490553">
  267. <OutputList>
  268. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[ExtraValueInstGroup]" Alias="[evig]" Column="propertyInstGroupFk" />
  269. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[ExtraValueInstGroup]" Alias="[evig]" Column="entityId" />
  270. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[PropertyDfnGroup]" Alias="[pfg]" Column="id" />
  271. </OutputList>
  272. <MemoryFractions Input="0.739278" Output="0.118905" />
  273. <RunTimeInformation>
  274. <RunTimeCountersPerThread Thread="0" ActualRows="10514" ActualEndOfScans="1" ActualExecutions="1" />
  275. </RunTimeInformation>
  276. <Hash>
  277. <DefinedValues />
  278. <HashKeysBuild>
  279. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[ExtraValueDfnGroup]" Alias="[evdg]" Column="id" />
  280. </HashKeysBuild>
  281. <HashKeysProbe>
  282. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[ExtraValueInstGroup]" Alias="[evig]" Column="extraValueDfnGroupFk" />
  283. </HashKeysProbe>
  284. <RelOp AvgRowSize="15" EstimateCPU="0.0177662" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Inner Join" NodeId="6" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="0.0292722">
  285. <OutputList>
  286. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[ExtraValueDfnGroup]" Alias="[evdg]" Column="id" />
  287. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[PropertyDfnGroup]" Alias="[pfg]" Column="id" />
  288. </OutputList>
  289. <MemoryFractions Input="0.894915" Output="0.155637" />
  290. <RunTimeInformation>
  291. <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
  292. </RunTimeInformation>
  293. <Hash>
  294. <DefinedValues />
  295. <HashKeysBuild>
  296. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[PropertyDfnGroup]" Alias="[pfg]" Column="id" />
  297. </HashKeysBuild>
  298. <HashKeysProbe>
  299. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[ExtraValueDfnGroup]" Alias="[evdg]" Column="propertyDfnGroupFk" />
  300. </HashKeysProbe>
  301. <RelOp AvgRowSize="79" EstimateCPU="0.0004903" EstimateIO="0.00756944" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Table Scan" NodeId="7" Parallel="false" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="0.00805974" TableCardinality="303">
  302. <OutputList>
  303. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[PropertyDfnGroup]" Alias="[pfg]" Column="id" />
  304. </OutputList>
  305. <RunTimeInformation>
  306. <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
  307. </RunTimeInformation>
  308. <TableScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  309. <DefinedValues>
  310. <DefinedValue>
  311. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[PropertyDfnGroup]" Alias="[pfg]" Column="id" />
  312. </DefinedValue>
  313. </DefinedValues>
  314. <Object Database="[staging]" Schema="[Junifer]" Table="[PropertyDfnGroup]" Alias="[pfg]" IndexKind="Heap" Storage="RowStore" />
  315. <Predicate>
  316. <ScalarOperator ScalarString="[staging].[Junifer].[PropertyDfnGroup].[internalKey] as [pfg].[internalKey]=N'Product Item Dfn_GDFS'">
  317. <Compare CompareOp="EQ">
  318. <ScalarOperator>
  319. <Identifier>
  320. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[PropertyDfnGroup]" Alias="[pfg]" Column="internalKey" />
  321. </Identifier>
  322. </ScalarOperator>
  323. <ScalarOperator>
  324. <Const ConstValue="N'Product Item Dfn_GDFS'" />
  325. </ScalarOperator>
  326. </Compare>
  327. </ScalarOperator>
  328. </Predicate>
  329. </TableScan>
  330. </RelOp>
  331. <RelOp AvgRowSize="39" EstimateCPU="0.000168" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.25" LogicalOp="Table Scan" NodeId="8" Parallel="false" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="0.003293" TableCardinality="10">
  332. <OutputList>
  333. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[ExtraValueDfnGroup]" Alias="[evdg]" Column="id" />
  334. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[ExtraValueDfnGroup]" Alias="[evdg]" Column="propertyDfnGroupFk" />
  335. </OutputList>
  336. <RunTimeInformation>
  337. <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
  338. </RunTimeInformation>
  339. <TableScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  340. <DefinedValues>
  341. <DefinedValue>
  342. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[ExtraValueDfnGroup]" Alias="[evdg]" Column="id" />
  343. </DefinedValue>
  344. <DefinedValue>
  345. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[ExtraValueDfnGroup]" Alias="[evdg]" Column="propertyDfnGroupFk" />
  346. </DefinedValue>
  347. </DefinedValues>
  348. <Object Database="[staging]" Schema="[Junifer]" Table="[ExtraValueDfnGroup]" Alias="[evdg]" IndexKind="Heap" Storage="RowStore" />
  349. <Predicate>
  350. <ScalarOperator ScalarString="[staging].[Junifer].[ExtraValueDfnGroup].[name] as [evdg].[name]=N'GDFS'">
  351. <Compare CompareOp="EQ">
  352. <ScalarOperator>
  353. <Identifier>
  354. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[ExtraValueDfnGroup]" Alias="[evdg]" Column="name" />
  355. </Identifier>
  356. </ScalarOperator>
  357. <ScalarOperator>
  358. <Const ConstValue="N'GDFS'" />
  359. </ScalarOperator>
  360. </Compare>
  361. </ScalarOperator>
  362. </Predicate>
  363. </TableScan>
  364. </RelOp>
  365. </Hash>
  366. </RelOp>
  367. <RelOp AvgRowSize="19" EstimateCPU="0.054563" EstimateIO="0.15794" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="49460" LogicalOp="Table Scan" NodeId="10" Parallel="false" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="0.212503" TableCardinality="49460">
  368. <OutputList>
  369. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[ExtraValueInstGroup]" Alias="[evig]" Column="extraValueDfnGroupFk" />
  370. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[ExtraValueInstGroup]" Alias="[evig]" Column="propertyInstGroupFk" />
  371. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[ExtraValueInstGroup]" Alias="[evig]" Column="entityId" />
  372. </OutputList>
  373. <RunTimeInformation>
  374. <RunTimeCountersPerThread Thread="0" ActualRows="49460" ActualEndOfScans="1" ActualExecutions="1" />
  375. </RunTimeInformation>
  376. <TableScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  377. <DefinedValues>
  378. <DefinedValue>
  379. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[ExtraValueInstGroup]" Alias="[evig]" Column="extraValueDfnGroupFk" />
  380. </DefinedValue>
  381. <DefinedValue>
  382. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[ExtraValueInstGroup]" Alias="[evig]" Column="propertyInstGroupFk" />
  383. </DefinedValue>
  384. <DefinedValue>
  385. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[ExtraValueInstGroup]" Alias="[evig]" Column="entityId" />
  386. </DefinedValue>
  387. </DefinedValues>
  388. <Object Database="[staging]" Schema="[Junifer]" Table="[ExtraValueInstGroup]" Alias="[evig]" IndexKind="Heap" Storage="RowStore" />
  389. </TableScan>
  390. </RelOp>
  391. </Hash>
  392. </RelOp>
  393. <RelOp AvgRowSize="15" EstimateCPU="0.0553561" EstimateIO="0.125347" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="50181" LogicalOp="Table Scan" NodeId="12" Parallel="false" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="0.180703" TableCardinality="50181">
  394. <OutputList>
  395. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[PropertyInstGroup]" Alias="[pig]" Column="id" />
  396. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[PropertyInstGroup]" Alias="[pig]" Column="propertyDfnGroupFk" />
  397. </OutputList>
  398. <RunTimeInformation>
  399. <RunTimeCountersPerThread Thread="0" ActualRows="50181" ActualEndOfScans="1" ActualExecutions="1" />
  400. </RunTimeInformation>
  401. <TableScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  402. <DefinedValues>
  403. <DefinedValue>
  404. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[PropertyInstGroup]" Alias="[pig]" Column="id" />
  405. </DefinedValue>
  406. <DefinedValue>
  407. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[PropertyInstGroup]" Alias="[pig]" Column="propertyDfnGroupFk" />
  408. </DefinedValue>
  409. </DefinedValues>
  410. <Object Database="[staging]" Schema="[Junifer]" Table="[PropertyInstGroup]" Alias="[pig]" IndexKind="Heap" Storage="RowStore" />
  411. </TableScan>
  412. </RelOp>
  413. </Hash>
  414. </RelOp>
  415. <RelOp AvgRowSize="19" EstimateCPU="0.0051182" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="51182" LogicalOp="Compute Scalar" NodeId="14" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.237293">
  416. <OutputList>
  417. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[PropertyInst]" Alias="[pit]" Column="propertyInstGroupFk" />
  418. <ColumnReference Column="Expr1012" />
  419. </OutputList>
  420. <ComputeScalar>
  421. <DefinedValues>
  422. <DefinedValue>
  423. <ColumnReference Column="Expr1012" />
  424. <ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[staging].[Junifer].[PropertyInst].[valueStr] as [pit].[valueStr],0)">
  425. <Convert DataType="int" Style="0" Implicit="true">
  426. <ScalarOperator>
  427. <Identifier>
  428. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[PropertyInst]" Alias="[pit]" Column="valueStr" />
  429. </Identifier>
  430. </ScalarOperator>
  431. </Convert>
  432. </ScalarOperator>
  433. </DefinedValue>
  434. </DefinedValues>
  435. <RelOp AvgRowSize="18" EstimateCPU="0.0564572" EstimateIO="0.175718" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="51182" LogicalOp="Table Scan" NodeId="15" Parallel="false" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="0.232175" TableCardinality="51182">
  436. <OutputList>
  437. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[PropertyInst]" Alias="[pit]" Column="propertyInstGroupFk" />
  438. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[PropertyInst]" Alias="[pit]" Column="valueStr" />
  439. </OutputList>
  440. <RunTimeInformation>
  441. <RunTimeCountersPerThread Thread="0" ActualRows="40974" ActualEndOfScans="1" ActualExecutions="1" />
  442. </RunTimeInformation>
  443. <TableScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  444. <DefinedValues>
  445. <DefinedValue>
  446. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[PropertyInst]" Alias="[pit]" Column="propertyInstGroupFk" />
  447. </DefinedValue>
  448. <DefinedValue>
  449. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[PropertyInst]" Alias="[pit]" Column="valueStr" />
  450. </DefinedValue>
  451. </DefinedValues>
  452. <Object Database="[staging]" Schema="[Junifer]" Table="[PropertyInst]" Alias="[pit]" IndexKind="Heap" Storage="RowStore" />
  453. <Predicate>
  454. <ScalarOperator ScalarString="isnumeric(CONVERT_IMPLICIT(varchar(510),[staging].[Junifer].[PropertyInst].[valueStr] as [pit].[valueStr],0))=(1)">
  455. <Compare CompareOp="EQ">
  456. <ScalarOperator>
  457. <Intrinsic FunctionName="isnumeric">
  458. <ScalarOperator>
  459. <Convert DataType="varchar" Length="510" Style="0" Implicit="true">
  460. <ScalarOperator>
  461. <Identifier>
  462. <ColumnReference Database="[staging]" Schema="[Junifer]" Table="[PropertyInst]" Alias="[pit]" Column="valueStr" />
  463. </Identifier>
  464. </ScalarOperator>
  465. </Convert>
  466. </ScalarOperator>
  467. </Intrinsic>
  468. </ScalarOperator>
  469. <ScalarOperator>
  470. <Const ConstValue="(1)" />
  471. </ScalarOperator>
  472. </Compare>
  473. </ScalarOperator>
  474. </Predicate>
  475. </TableScan>
  476. </RelOp>
  477. </ComputeScalar>
  478. </RelOp>
  479. </Hash>
  480. </RelOp>
  481. </Hash>
  482. </RelOp>
  483. </Hash>
  484. </RelOp>
  485. </QueryPlan>
  486. </StmtSimple>
  487. </Statements>
  488. </Batch>
  489. </BatchSequence>
  490. </ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!