API tools faq
paste
Advertisement
robin16

Temptable_XMLPlan

robin16
Aug 11th, 2016
267
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 281.18 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.4457.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
  3. <BatchSequence>
  4. <Batch>
  5. <Statements>
  6. <StmtSimple StatementCompId="11" StatementEstRows="1" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="120" StatementSubTreeCost="0.00989064" StatementText="SELECT TOP 1 @Client_ID=CUST_ID &#xD;&#xA; FROM DBO.FORMPFFUNDMAINTENANCE ffm&#xD;&#xA; INNER JOIN dbo.F_delimitedsplit8k(@FundID,@Delimiter) Splt &#xD;&#xA; ON Splt.item = ffm.id&#xD;&#xA; ORDER BY 1" StatementType="SELECT" QueryHash="0x48027442B25D8F60" QueryPlanHash="0x46330055824E2CD6" RetrievedFromCache="false">
  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="1696" CachedPlanSize="40" CompileTime="7" CompileCPU="7" CompileMemory="1192">
  9. <MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="1696" RequiredMemory="512" DesiredMemory="1696" RequestedMemory="1696" GrantWaitTime="0" GrantedMemory="1696" MaxUsedMemory="16" />
  10. <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="3145728" EstimatedPagesCached="3145728" EstimatedAvailableDegreeOfParallelism="8" />
  11. <RelOp AvgRowSize="19" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Top" NodeId="0" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="0.00989064">
  12. <OutputList>
  13. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFFundMaintenance]" Alias="[ffm]" Column="CUST_ID" />
  14. </OutputList>
  15. <RunTimeInformation>
  16. <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
  17. </RunTimeInformation>
  18. <Top RowCount="false" IsPercent="false" WithTies="false">
  19. <TopExpression>
  20. <ScalarOperator ScalarString="(1)">
  21. <Const ConstValue="(1)" />
  22. </ScalarOperator>
  23. </TopExpression>
  24. <RelOp AvgRowSize="19" EstimateCPU="0.0066043" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Concatenation" NodeId="1" Parallel="false" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="0.638027">
  25. <OutputList>
  26. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFFundMaintenance]" Alias="[ffm]" Column="CUST_ID" />
  27. </OutputList>
  28. <RunTimeInformation>
  29. <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
  30. </RunTimeInformation>
  31. <Merge>
  32. <DefinedValues>
  33. <DefinedValue>
  34. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFFundMaintenance]" Alias="[ffm]" Column="CUST_ID" />
  35. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFFundMaintenance]" Alias="[ffm]" Column="CUST_ID" />
  36. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFFundMaintenance]" Alias="[ffm]" Column="CUST_ID" />
  37. </DefinedValue>
  38. </DefinedValues>
  39. <RelOp AvgRowSize="19" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Inner Join" NodeId="2" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00328844">
  40. <OutputList>
  41. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFFundMaintenance]" Alias="[ffm]" Column="CUST_ID" />
  42. </OutputList>
  43. <RunTimeInformation>
  44. <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
  45. </RunTimeInformation>
  46. <NestedLoops Optimized="false">
  47. <OuterReferences>
  48. <ColumnReference Column="Expr1001" />
  49. </OuterReferences>
  50. <RelOp AvgRowSize="15" EstimateCPU="1.157E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Constant Scan" NodeId="3" Parallel="false" PhysicalOp="Constant Scan" EstimatedTotalSubtreeCost="1.157E-06">
  51. <OutputList>
  52. <ColumnReference Column="Expr1001" />
  53. </OutputList>
  54. <RunTimeInformation>
  55. <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
  56. </RunTimeInformation>
  57. <ConstantScan>
  58. <Values>
  59. <Row>
  60. <ScalarOperator ScalarString="(1)">
  61. <Const ConstValue="(1)" />
  62. </ScalarOperator>
  63. </Row>
  64. </Values>
  65. </ConstantScan>
  66. </RelOp>
  67. <RelOp AvgRowSize="19" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="5" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="779">
  68. <OutputList>
  69. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFFundMaintenance]" Alias="[ffm]" Column="CUST_ID" />
  70. </OutputList>
  71. <RunTimeInformation>
  72. <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
  73. </RunTimeInformation>
  74. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  75. <DefinedValues>
  76. <DefinedValue>
  77. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFFundMaintenance]" Alias="[ffm]" Column="CUST_ID" />
  78. </DefinedValue>
  79. </DefinedValues>
  80. <Object Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFFundMaintenance]" Index="[PK_ID]" Alias="[ffm]" IndexKind="Clustered" Storage="RowStore" />
  81. <SeekPredicates>
  82. <SeekPredicateNew>
  83. <SeekKeys>
  84. <Prefix ScanType="EQ">
  85. <RangeColumns>
  86. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFFundMaintenance]" Alias="[ffm]" Column="ID" />
  87. </RangeColumns>
  88. <RangeExpressions>
  89. <ScalarOperator ScalarString="CONVERT_IMPLICIT(int,substring([@FundID],CONVERT_IMPLICIT(int,[Expr1001],0),CONVERT_IMPLICIT(int,isnull(CONVERT_IMPLICIT(bigint,CASE WHEN charindex([@Delimiter],[@FundID],CONVERT_IMPLICIT(int,[Expr1001],0))=(0) THEN NULL ELSE charindex([@Delimiter],[@FundID],CONVERT_IMPLICIT(int,[Expr1001],0)) END,0)-[Expr1001],(8000)),0)),0)">
  90. <Convert DataType="int" Style="0" Implicit="true">
  91. <ScalarOperator>
  92. <Intrinsic FunctionName="substring">
  93. <ScalarOperator>
  94. <Identifier>
  95. <ColumnReference Column="@FundID" />
  96. </Identifier>
  97. </ScalarOperator>
  98. <ScalarOperator>
  99. <Convert DataType="int" Style="0" Implicit="true">
  100. <ScalarOperator>
  101. <Identifier>
  102. <ColumnReference Column="Expr1001" />
  103. </Identifier>
  104. </ScalarOperator>
  105. </Convert>
  106. </ScalarOperator>
  107. <ScalarOperator>
  108. <Convert DataType="int" Style="0" Implicit="true">
  109. <ScalarOperator>
  110. <Intrinsic FunctionName="isnull">
  111. <ScalarOperator>
  112. <Arithmetic Operation="SUB">
  113. <ScalarOperator>
  114. <Convert DataType="bigint" Style="0" Implicit="true">
  115. <ScalarOperator>
  116. <IF>
  117. <Condition>
  118. <ScalarOperator>
  119. <Compare CompareOp="EQ">
  120. <ScalarOperator>
  121. <Intrinsic FunctionName="charindex">
  122. <ScalarOperator>
  123. <Identifier>
  124. <ColumnReference Column="@Delimiter" />
  125. </Identifier>
  126. </ScalarOperator>
  127. <ScalarOperator>
  128. <Identifier>
  129. <ColumnReference Column="@FundID" />
  130. </Identifier>
  131. </ScalarOperator>
  132. <ScalarOperator>
  133. <Convert DataType="int" Style="0" Implicit="true">
  134. <ScalarOperator>
  135. <Identifier>
  136. <ColumnReference Column="Expr1001" />
  137. </Identifier>
  138. </ScalarOperator>
  139. </Convert>
  140. </ScalarOperator>
  141. </Intrinsic>
  142. </ScalarOperator>
  143. <ScalarOperator>
  144. <Const ConstValue="(0)" />
  145. </ScalarOperator>
  146. </Compare>
  147. </ScalarOperator>
  148. </Condition>
  149. <Then>
  150. <ScalarOperator>
  151. <Const ConstValue="NULL" />
  152. </ScalarOperator>
  153. </Then>
  154. <Else>
  155. <ScalarOperator>
  156. <Intrinsic FunctionName="charindex">
  157. <ScalarOperator>
  158. <Identifier>
  159. <ColumnReference Column="@Delimiter" />
  160. </Identifier>
  161. </ScalarOperator>
  162. <ScalarOperator>
  163. <Identifier>
  164. <ColumnReference Column="@FundID" />
  165. </Identifier>
  166. </ScalarOperator>
  167. <ScalarOperator>
  168. <Convert DataType="int" Style="0" Implicit="true">
  169. <ScalarOperator>
  170. <Identifier>
  171. <ColumnReference Column="Expr1001" />
  172. </Identifier>
  173. </ScalarOperator>
  174. </Convert>
  175. </ScalarOperator>
  176. </Intrinsic>
  177. </ScalarOperator>
  178. </Else>
  179. </IF>
  180. </ScalarOperator>
  181. </Convert>
  182. </ScalarOperator>
  183. <ScalarOperator>
  184. <Identifier>
  185. <ColumnReference Column="Expr1001" />
  186. </Identifier>
  187. </ScalarOperator>
  188. </Arithmetic>
  189. </ScalarOperator>
  190. <ScalarOperator>
  191. <Const ConstValue="(8000)" />
  192. </ScalarOperator>
  193. </Intrinsic>
  194. </ScalarOperator>
  195. </Convert>
  196. </ScalarOperator>
  197. </Intrinsic>
  198. </ScalarOperator>
  199. </Convert>
  200. </ScalarOperator>
  201. </RangeExpressions>
  202. </Prefix>
  203. </SeekKeys>
  204. </SeekPredicateNew>
  205. </SeekPredicates>
  206. </IndexScan>
  207. </RelOp>
  208. </NestedLoops>
  209. </RelOp>
  210. <RelOp AvgRowSize="19" EstimateCPU="0.60342" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Sort" NodeId="6" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.00989064">
  211. <OutputList>
  212. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFFundMaintenance]" Alias="[ffm]" Column="CUST_ID" />
  213. </OutputList>
  214. <MemoryFractions Input="1" Output="1" />
  215. <RunTimeInformation>
  216. <RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
  217. </RunTimeInformation>
  218. <Sort Distinct="false">
  219. <OrderBy>
  220. <OrderByColumn Ascending="true">
  221. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFFundMaintenance]" Alias="[ffm]" Column="CUST_ID" />
  222. </OrderByColumn>
  223. </OrderBy>
  224. <RelOp AvgRowSize="19" EstimateCPU="0.000418" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="10000" LogicalOp="Inner Join" NodeId="7" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00989064">
  225. <OutputList>
  226. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFFundMaintenance]" Alias="[ffm]" Column="CUST_ID" />
  227. </OutputList>
  228. <RunTimeInformation>
  229. <RunTimeCountersPerThread Thread="0" ActualRows="9" ActualEndOfScans="1" ActualExecutions="1" />
  230. </RunTimeInformation>
  231. <NestedLoops Optimized="false">
  232. <OuterReferences>
  233. <ColumnReference Column="Expr1052" />
  234. </OuterReferences>
  235. <RelOp AvgRowSize="15" EstimateCPU="1E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="100" LogicalOp="Compute Scalar" NodeId="8" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.00070439">
  236. <OutputList>
  237. <ColumnReference Column="Expr1052" />
  238. </OutputList>
  239. <ComputeScalar>
  240. <DefinedValues>
  241. <DefinedValue>
  242. <ColumnReference Column="Expr1052" />
  243. <ScalarOperator ScalarString="[Expr1051]+(1)">
  244. <Arithmetic Operation="ADD">
  245. <ScalarOperator>
  246. <Identifier>
  247. <ColumnReference Column="Expr1051" />
  248. </Identifier>
  249. </ScalarOperator>
  250. <ScalarOperator>
  251. <Const ConstValue="(1)" />
  252. </ScalarOperator>
  253. </Arithmetic>
  254. </ScalarOperator>
  255. </DefinedValue>
  256. </DefinedValues>
  257. <RelOp AvgRowSize="15" EstimateCPU="8.8E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="100" LogicalOp="Filter" NodeId="9" Parallel="false" PhysicalOp="Filter" EstimatedTotalSubtreeCost="0.00069439">
  258. <OutputList>
  259. <ColumnReference Column="Expr1051" />
  260. </OutputList>
  261. <RunTimeInformation>
  262. <RunTimeCountersPerThread Thread="0" ActualRows="9" ActualEndOfScans="1" ActualExecutions="1" />
  263. </RunTimeInformation>
  264. <Filter StartupExpression="false">
  265. <RelOp AvgRowSize="15" EstimateCPU="1E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="100" LogicalOp="Top" NodeId="10" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="0.00060639">
  266. <OutputList>
  267. <ColumnReference Column="Expr1051" />
  268. </OutputList>
  269. <RunTimeInformation>
  270. <RunTimeCountersPerThread Thread="0" ActualRows="40" ActualEndOfScans="1" ActualExecutions="1" />
  271. </RunTimeInformation>
  272. <Top RowCount="false" IsPercent="false" WithTies="false">
  273. <TopExpression>
  274. <ScalarOperator ScalarString="CONVERT_IMPLICIT(bigint,isnull(datalength([@FundID]),(0)),0)">
  275. <Identifier>
  276. <ColumnReference Column="ConstExpr1057">
  277. <ScalarOperator>
  278. <Convert DataType="bigint" Style="0" Implicit="true">
  279. <ScalarOperator>
  280. <Intrinsic FunctionName="isnull">
  281. <ScalarOperator>
  282. <Intrinsic FunctionName="datalength">
  283. <ScalarOperator>
  284. <Identifier>
  285. <ColumnReference Column="@FundID" />
  286. </Identifier>
  287. </ScalarOperator>
  288. </Intrinsic>
  289. </ScalarOperator>
  290. <ScalarOperator>
  291. <Const ConstValue="(0)" />
  292. </ScalarOperator>
  293. </Intrinsic>
  294. </ScalarOperator>
  295. </Convert>
  296. </ScalarOperator>
  297. </ColumnReference>
  298. </Identifier>
  299. </ScalarOperator>
  300. </TopExpression>
  301. <RelOp AvgRowSize="15" EstimateCPU="0.0008" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="100" LogicalOp="Compute Scalar" NodeId="11" Parallel="false" PhysicalOp="Sequence Project" EstimatedTotalSubtreeCost="0.00059639">
  302. <OutputList>
  303. <ColumnReference Column="Expr1051" />
  304. </OutputList>
  305. <RunTimeInformation>
  306. <RunTimeCountersPerThread Thread="0" ActualRows="40" ActualEndOfScans="0" ActualExecutions="1" />
  307. </RunTimeInformation>
  308. <SequenceProject>
  309. <DefinedValues>
  310. <DefinedValue>
  311. <ColumnReference Column="Expr1051" />
  312. <ScalarOperator ScalarString="row_number">
  313. <Sequence FunctionName="row_number" />
  314. </ScalarOperator>
  315. </DefinedValue>
  316. </DefinedValues>
  317. <RelOp AvgRowSize="15" EstimateCPU="0.0002" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="100" LogicalOp="Segment" NodeId="12" Parallel="false" PhysicalOp="Segment" EstimatedTotalSubtreeCost="0.00058839">
  318. <OutputList>
  319. <ColumnReference Column="Segment1058" />
  320. </OutputList>
  321. <RunTimeInformation>
  322. <RunTimeCountersPerThread Thread="0" ActualRows="40" ActualEndOfScans="0" ActualExecutions="1" />
  323. </RunTimeInformation>
  324. <Segment>
  325. <GroupBy />
  326. <SegmentColumn>
  327. <ColumnReference Column="Segment1058" />
  328. </SegmentColumn>
  329. <RelOp AvgRowSize="9" EstimateCPU="0.0418" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="100" LogicalOp="Inner Join" NodeId="13" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00058639">
  330. <OutputList />
  331. <Warnings NoJoinPredicate="true" />
  332. <RunTimeInformation>
  333. <RunTimeCountersPerThread Thread="0" ActualRows="40" ActualEndOfScans="0" ActualExecutions="1" />
  334. </RunTimeInformation>
  335. <NestedLoops Optimized="false">
  336. <RelOp AvgRowSize="9" EstimateCPU="0.00418" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="10" LogicalOp="Inner Join" NodeId="14" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="6.31521E-05">
  337. <OutputList />
  338. <Warnings NoJoinPredicate="true" />
  339. <RunTimeInformation>
  340. <RunTimeCountersPerThread Thread="0" ActualRows="4" ActualEndOfScans="0" ActualExecutions="1" />
  341. </RunTimeInformation>
  342. <NestedLoops Optimized="false">
  343. <RelOp AvgRowSize="9" EstimateCPU="0.000418" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Inner Join" NodeId="15" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="6.494E-06">
  344. <OutputList />
  345. <Warnings NoJoinPredicate="true" />
  346. <RunTimeInformation>
  347. <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
  348. </RunTimeInformation>
  349. <NestedLoops Optimized="false">
  350. <RelOp AvgRowSize="9" EstimateCPU="1.0157E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Constant Scan" NodeId="16" Parallel="false" PhysicalOp="Constant Scan" EstimatedTotalSubtreeCost="1.157E-06">
  351. <OutputList />
  352. <RunTimeInformation>
  353. <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
  354. </RunTimeInformation>
  355. <ConstantScan />
  356. </RelOp>
  357. <RelOp AvgRowSize="9" EstimateCPU="1.0157E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Constant Scan" NodeId="17" Parallel="false" PhysicalOp="Constant Scan" EstimatedTotalSubtreeCost="1.157E-06">
  358. <OutputList />
  359. <RunTimeInformation>
  360. <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
  361. </RunTimeInformation>
  362. <ConstantScan />
  363. </RelOp>
  364. </NestedLoops>
  365. </RelOp>
  366. <RelOp AvgRowSize="9" EstimateCPU="1.0157E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="10" LogicalOp="Constant Scan" NodeId="18" Parallel="false" PhysicalOp="Constant Scan" EstimatedTotalSubtreeCost="1.0157E-05">
  367. <OutputList />
  368. <RunTimeInformation>
  369. <RunTimeCountersPerThread Thread="0" ActualRows="4" ActualEndOfScans="0" ActualExecutions="1" />
  370. </RunTimeInformation>
  371. <ConstantScan />
  372. </RelOp>
  373. </NestedLoops>
  374. </RelOp>
  375. <RelOp AvgRowSize="9" EstimateCPU="1.0157E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="9.99" EstimatedExecutionMode="Row" EstimateRows="10" LogicalOp="Constant Scan" NodeId="19" Parallel="false" PhysicalOp="Constant Scan" EstimatedTotalSubtreeCost="0.000110057">
  376. <OutputList />
  377. <RunTimeInformation>
  378. <RunTimeCountersPerThread Thread="0" ActualRows="40" ActualEndOfScans="3" ActualExecutions="4" />
  379. </RunTimeInformation>
  380. <ConstantScan />
  381. </RelOp>
  382. </NestedLoops>
  383. </RelOp>
  384. </Segment>
  385. </RelOp>
  386. </SequenceProject>
  387. </RelOp>
  388. </Top>
  389. </RelOp>
  390. <Predicate>
  391. <ScalarOperator ScalarString="substring([@FundID],CONVERT_IMPLICIT(int,[Expr1051],0),(1))=[@Delimiter]">
  392. <Compare CompareOp="EQ">
  393. <ScalarOperator>
  394. <Intrinsic FunctionName="substring">
  395. <ScalarOperator>
  396. <Identifier>
  397. <ColumnReference Column="@FundID" />
  398. </Identifier>
  399. </ScalarOperator>
  400. <ScalarOperator>
  401. <Convert DataType="int" Style="0" Implicit="true">
  402. <ScalarOperator>
  403. <Identifier>
  404. <ColumnReference Column="Expr1051" />
  405. </Identifier>
  406. </ScalarOperator>
  407. </Convert>
  408. </ScalarOperator>
  409. <ScalarOperator>
  410. <Const ConstValue="(1)" />
  411. </ScalarOperator>
  412. </Intrinsic>
  413. </ScalarOperator>
  414. <ScalarOperator>
  415. <Identifier>
  416. <ColumnReference Column="@Delimiter" />
  417. </Identifier>
  418. </ScalarOperator>
  419. </Compare>
  420. </ScalarOperator>
  421. </Predicate>
  422. </Filter>
  423. </RelOp>
  424. </ComputeScalar>
  425. </RelOp>
  426. <RelOp AvgRowSize="19" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="99" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="28" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00989064" TableCardinality="779">
  427. <OutputList>
  428. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFFundMaintenance]" Alias="[ffm]" Column="CUST_ID" />
  429. </OutputList>
  430. <RunTimeInformation>
  431. <RunTimeCountersPerThread Thread="0" ActualRows="9" ActualEndOfScans="0" ActualExecutions="9" />
  432. </RunTimeInformation>
  433. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  434. <DefinedValues>
  435. <DefinedValue>
  436. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFFundMaintenance]" Alias="[ffm]" Column="CUST_ID" />
  437. </DefinedValue>
  438. </DefinedValues>
  439. <Object Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFFundMaintenance]" Index="[PK_ID]" Alias="[ffm]" IndexKind="Clustered" Storage="RowStore" />
  440. <SeekPredicates>
  441. <SeekPredicateNew>
  442. <SeekKeys>
  443. <Prefix ScanType="EQ">
  444. <RangeColumns>
  445. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFFundMaintenance]" Alias="[ffm]" Column="ID" />
  446. </RangeColumns>
  447. <RangeExpressions>
  448. <ScalarOperator ScalarString="CONVERT_IMPLICIT(int,substring([@FundID],CONVERT_IMPLICIT(int,[Expr1052],0),CONVERT_IMPLICIT(int,isnull(CONVERT_IMPLICIT(bigint,CASE WHEN charindex([@Delimiter],[@FundID],CONVERT_IMPLICIT(int,[Expr1052],0))=(0) THEN NULL ELSE charindex([@Delimiter],[@FundID],CONVERT_IMPLICIT(int,[Expr1052],0)) END,0)-[Expr1052],(8000)),0)),0)">
  449. <Convert DataType="int" Style="0" Implicit="true">
  450. <ScalarOperator>
  451. <Intrinsic FunctionName="substring">
  452. <ScalarOperator>
  453. <Identifier>
  454. <ColumnReference Column="@FundID" />
  455. </Identifier>
  456. </ScalarOperator>
  457. <ScalarOperator>
  458. <Convert DataType="int" Style="0" Implicit="true">
  459. <ScalarOperator>
  460. <Identifier>
  461. <ColumnReference Column="Expr1052" />
  462. </Identifier>
  463. </ScalarOperator>
  464. </Convert>
  465. </ScalarOperator>
  466. <ScalarOperator>
  467. <Convert DataType="int" Style="0" Implicit="true">
  468. <ScalarOperator>
  469. <Intrinsic FunctionName="isnull">
  470. <ScalarOperator>
  471. <Arithmetic Operation="SUB">
  472. <ScalarOperator>
  473. <Convert DataType="bigint" Style="0" Implicit="true">
  474. <ScalarOperator>
  475. <IF>
  476. <Condition>
  477. <ScalarOperator>
  478. <Compare CompareOp="EQ">
  479. <ScalarOperator>
  480. <Intrinsic FunctionName="charindex">
  481. <ScalarOperator>
  482. <Identifier>
  483. <ColumnReference Column="@Delimiter" />
  484. </Identifier>
  485. </ScalarOperator>
  486. <ScalarOperator>
  487. <Identifier>
  488. <ColumnReference Column="@FundID" />
  489. </Identifier>
  490. </ScalarOperator>
  491. <ScalarOperator>
  492. <Convert DataType="int" Style="0" Implicit="true">
  493. <ScalarOperator>
  494. <Identifier>
  495. <ColumnReference Column="Expr1052" />
  496. </Identifier>
  497. </ScalarOperator>
  498. </Convert>
  499. </ScalarOperator>
  500. </Intrinsic>
  501. </ScalarOperator>
  502. <ScalarOperator>
  503. <Const ConstValue="(0)" />
  504. </ScalarOperator>
  505. </Compare>
  506. </ScalarOperator>
  507. </Condition>
  508. <Then>
  509. <ScalarOperator>
  510. <Const ConstValue="NULL" />
  511. </ScalarOperator>
  512. </Then>
  513. <Else>
  514. <ScalarOperator>
  515. <Intrinsic FunctionName="charindex">
  516. <ScalarOperator>
  517. <Identifier>
  518. <ColumnReference Column="@Delimiter" />
  519. </Identifier>
  520. </ScalarOperator>
  521. <ScalarOperator>
  522. <Identifier>
  523. <ColumnReference Column="@FundID" />
  524. </Identifier>
  525. </ScalarOperator>
  526. <ScalarOperator>
  527. <Convert DataType="int" Style="0" Implicit="true">
  528. <ScalarOperator>
  529. <Identifier>
  530. <ColumnReference Column="Expr1052" />
  531. </Identifier>
  532. </ScalarOperator>
  533. </Convert>
  534. </ScalarOperator>
  535. </Intrinsic>
  536. </ScalarOperator>
  537. </Else>
  538. </IF>
  539. </ScalarOperator>
  540. </Convert>
  541. </ScalarOperator>
  542. <ScalarOperator>
  543. <Identifier>
  544. <ColumnReference Column="Expr1052" />
  545. </Identifier>
  546. </ScalarOperator>
  547. </Arithmetic>
  548. </ScalarOperator>
  549. <ScalarOperator>
  550. <Const ConstValue="(8000)" />
  551. </ScalarOperator>
  552. </Intrinsic>
  553. </ScalarOperator>
  554. </Convert>
  555. </ScalarOperator>
  556. </Intrinsic>
  557. </ScalarOperator>
  558. </Convert>
  559. </ScalarOperator>
  560. </RangeExpressions>
  561. </Prefix>
  562. </SeekKeys>
  563. </SeekPredicateNew>
  564. </SeekPredicates>
  565. </IndexScan>
  566. </RelOp>
  567. </NestedLoops>
  568. </RelOp>
  569. </Sort>
  570. </RelOp>
  571. </Merge>
  572. </RelOp>
  573. </Top>
  574. </RelOp>
  575. <ParameterList>
  576. <ColumnReference Column="@Client_ID" ParameterRuntimeValue="'1072 '" />
  577. <ColumnReference Column="@Delimiter" ParameterRuntimeValue="'|'" />
  578. <ColumnReference Column="@FundID" ParameterRuntimeValue="'218|219|220|221|222|225|226|227|606|1002'" />
  579. </ParameterList>
  580. </QueryPlan>
  581. </StmtSimple>
  582. </Statements>
  583. </Batch>
  584. <Batch>
  585. <Statements>
  586. <StmtSimple StatementCompId="12" StatementEstRows="1" StatementId="2" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="120" StatementSubTreeCost="0.00328962" StatementText="IF NOT EXISTS (SELECT ID&#xD;&#xA; FROM NETIKDP..DP_CrossReference&#xD;&#xA; WHERE originator_id = 'GRRC_Client_Lookup'&#xD;&#xA; AND RTRIM(LTRIM(internal_value)) = RTRIM(LTRIM(@Client_ID)))" StatementType="COND WITH QUERY" QueryHash="0x89E9AAD971123F52" QueryPlanHash="0x17903DBFA710BA8A" RetrievedFromCache="false">
  587. <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
  588. <QueryPlan DegreeOfParallelism="1" CachedPlanSize="24" CompileTime="2" CompileCPU="2" CompileMemory="632">
  589. <MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" />
  590. <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="3145728" EstimatedPagesCached="3145728" EstimatedAvailableDegreeOfParallelism="8" />
  591. <RelOp AvgRowSize="11" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="0" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.00328962">
  592. <OutputList>
  593. <ColumnReference Column="Expr1002" />
  594. </OutputList>
  595. <ComputeScalar>
  596. <DefinedValues>
  597. <DefinedValue>
  598. <ColumnReference Column="Expr1002" />
  599. <ScalarOperator ScalarString="CASE WHEN [Expr1003] IS NULL THEN (1) ELSE (0) END">
  600. <IF>
  601. <Condition>
  602. <ScalarOperator>
  603. <Compare CompareOp="IS">
  604. <ScalarOperator>
  605. <Identifier>
  606. <ColumnReference Column="Expr1003" />
  607. </Identifier>
  608. </ScalarOperator>
  609. <ScalarOperator>
  610. <Const ConstValue="NULL" />
  611. </ScalarOperator>
  612. </Compare>
  613. </ScalarOperator>
  614. </Condition>
  615. <Then>
  616. <ScalarOperator>
  617. <Const ConstValue="(1)" />
  618. </ScalarOperator>
  619. </Then>
  620. <Else>
  621. <ScalarOperator>
  622. <Const ConstValue="(0)" />
  623. </ScalarOperator>
  624. </Else>
  625. </IF>
  626. </ScalarOperator>
  627. </DefinedValue>
  628. </DefinedValues>
  629. <RelOp AvgRowSize="9" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="1" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00328952">
  630. <OutputList>
  631. <ColumnReference Column="Expr1003" />
  632. </OutputList>
  633. <RunTimeInformation>
  634. <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
  635. </RunTimeInformation>
  636. <NestedLoops Optimized="false">
  637. <DefinedValues>
  638. <DefinedValue>
  639. <ColumnReference Column="Expr1003" />
  640. </DefinedValue>
  641. </DefinedValues>
  642. <ProbeColumn>
  643. <ColumnReference Column="Expr1003" />
  644. </ProbeColumn>
  645. <RelOp AvgRowSize="9" EstimateCPU="1.157E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Constant Scan" NodeId="2" Parallel="false" PhysicalOp="Constant Scan" EstimatedTotalSubtreeCost="1.157E-06">
  646. <OutputList />
  647. <RunTimeInformation>
  648. <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
  649. </RunTimeInformation>
  650. <ConstantScan />
  651. </RelOp>
  652. <RelOp AvgRowSize="34" EstimateCPU="0.000158104" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="4" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="929005">
  653. <OutputList />
  654. <RunTimeInformation>
  655. <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
  656. </RunTimeInformation>
  657. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  658. <DefinedValues />
  659. <Object Database="[NETIKDP]" Schema="[dbo]" Table="[DP_CrossReference]" Index="[NCI_DP_CrossReference_idx1]" IndexKind="NonClustered" Storage="RowStore" />
  660. <SeekPredicates>
  661. <SeekPredicateNew>
  662. <SeekKeys>
  663. <Prefix ScanType="EQ">
  664. <RangeColumns>
  665. <ColumnReference Database="[NETIKDP]" Schema="[dbo]" Table="[DP_CrossReference]" Column="originator_id" />
  666. </RangeColumns>
  667. <RangeExpressions>
  668. <ScalarOperator ScalarString="'GRRC_Client_Lookup'">
  669. <Const ConstValue="'GRRC_Client_Lookup'" />
  670. </ScalarOperator>
  671. </RangeExpressions>
  672. </Prefix>
  673. </SeekKeys>
  674. </SeekPredicateNew>
  675. </SeekPredicates>
  676. <Predicate>
  677. <ScalarOperator ScalarString="rtrim(ltrim([NETIKDP].[dbo].[DP_CrossReference].[internal_value]))=CONVERT_IMPLICIT(nvarchar(12),rtrim(ltrim([@Client_ID])),0)">
  678. <Compare CompareOp="EQ">
  679. <ScalarOperator>
  680. <Intrinsic FunctionName="rtrim">
  681. <ScalarOperator>
  682. <Intrinsic FunctionName="ltrim">
  683. <ScalarOperator>
  684. <Identifier>
  685. <ColumnReference Database="[NETIKDP]" Schema="[dbo]" Table="[DP_CrossReference]" Column="internal_value" />
  686. </Identifier>
  687. </ScalarOperator>
  688. </Intrinsic>
  689. </ScalarOperator>
  690. </Intrinsic>
  691. </ScalarOperator>
  692. <ScalarOperator>
  693. <Convert DataType="nvarchar" Length="24" Style="0" Implicit="true">
  694. <ScalarOperator>
  695. <Intrinsic FunctionName="rtrim">
  696. <ScalarOperator>
  697. <Intrinsic FunctionName="ltrim">
  698. <ScalarOperator>
  699. <Identifier>
  700. <ColumnReference Column="@Client_ID" />
  701. </Identifier>
  702. </ScalarOperator>
  703. </Intrinsic>
  704. </ScalarOperator>
  705. </Intrinsic>
  706. </ScalarOperator>
  707. </Convert>
  708. </ScalarOperator>
  709. </Compare>
  710. </ScalarOperator>
  711. </Predicate>
  712. </IndexScan>
  713. </RelOp>
  714. </NestedLoops>
  715. </RelOp>
  716. </ComputeScalar>
  717. </RelOp>
  718. <ParameterList>
  719. <ColumnReference Column="@Client_ID" ParameterRuntimeValue="'1072 '" />
  720. </ParameterList>
  721. </QueryPlan>
  722. </StmtSimple>
  723. </Statements>
  724. </Batch>
  725. <Batch>
  726. <Statements>
  727. <StmtSimple StatementCompId="32" StatementEstRows="1" StatementId="3" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="120" StatementSubTreeCost="0.0231412" StatementText="INSERT @tempFundID (FundID) &#xD;&#xA; SELECT distinct item &#xD;&#xA; FROM dbo.F_delimitedsplit8k(@FundID,@Delimiter)" StatementType="INSERT" QueryHash="0xD43005A211E3EDB5" QueryPlanHash="0xA21E6077CD4F9182" RetrievedFromCache="false">
  728. <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
  729. <QueryPlan DegreeOfParallelism="0" NonParallelPlanReason="CouldNotGenerateValidParallelPlan" MemoryGrant="1328" CachedPlanSize="40" CompileTime="4" CompileCPU="4" CompileMemory="1104">
  730. <Warnings>
  731. <PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(int,[Expr1057],0)" />
  732. </Warnings>
  733. <MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="1328" RequiredMemory="512" DesiredMemory="1328" RequestedMemory="1328" GrantWaitTime="0" GrantedMemory="1328" MaxUsedMemory="16" />
  734. <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="3145728" EstimatedPagesCached="3145728" EstimatedAvailableDegreeOfParallelism="8" />
  735. <RelOp AvgRowSize="9" EstimateCPU="1E-06" EstimateIO="0.01" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Insert" NodeId="0" Parallel="false" PhysicalOp="Clustered Index Insert" EstimatedTotalSubtreeCost="0.0231412">
  736. <OutputList />
  737. <RunTimeInformation>
  738. <RunTimeCountersPerThread Thread="0" ActualRows="10" ActualEndOfScans="1" ActualExecutions="1" />
  739. </RunTimeInformation>
  740. <Update DMLRequestSort="false">
  741. <Object Table="[@tempFundID]" Index="[PK__#A818986__830DFC7A5A6908F0]" Storage="RowStore" />
  742. <SetPredicate>
  743. <ScalarOperator ScalarString="[FundID] = RaiseIfNullInsert([Expr1058])">
  744. <ScalarExpressionList>
  745. <ScalarOperator>
  746. <MultipleAssign>
  747. <Assign>
  748. <ColumnReference Column="FundID" />
  749. <ScalarOperator>
  750. <Intrinsic FunctionName="RaiseIfNullInsert">
  751. <ScalarOperator>
  752. <Identifier>
  753. <ColumnReference Column="Expr1058" />
  754. </Identifier>
  755. </ScalarOperator>
  756. </Intrinsic>
  757. </ScalarOperator>
  758. </Assign>
  759. </MultipleAssign>
  760. </ScalarOperator>
  761. </ScalarExpressionList>
  762. </ScalarOperator>
  763. </SetPredicate>
  764. <RelOp AvgRowSize="11" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="1" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0131402">
  765. <OutputList>
  766. <ColumnReference Column="Expr1058" />
  767. </OutputList>
  768. <ComputeScalar>
  769. <DefinedValues>
  770. <DefinedValue>
  771. <ColumnReference Column="Expr1058" />
  772. <ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr1057],0)">
  773. <Convert DataType="int" Style="0" Implicit="true">
  774. <ScalarOperator>
  775. <Identifier>
  776. <ColumnReference Column="Expr1057" />
  777. </Identifier>
  778. </ScalarOperator>
  779. </Convert>
  780. </ScalarOperator>
  781. </DefinedValue>
  782. </DefinedValues>
  783. <RelOp AvgRowSize="4011" EstimateCPU="0.00115308" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Distinct Sort" NodeId="2" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.0131401">
  784. <OutputList>
  785. <ColumnReference Column="Expr1057" />
  786. </OutputList>
  787. <MemoryFractions Input="1" Output="1" />
  788. <RunTimeInformation>
  789. <RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="10" ActualEndOfScans="1" ActualExecutions="1" />
  790. </RunTimeInformation>
  791. <Sort Distinct="true">
  792. <OrderBy>
  793. <OrderByColumn Ascending="true">
  794. <ColumnReference Column="Expr1057" />
  795. </OrderByColumn>
  796. </OrderBy>
  797. <RelOp AvgRowSize="4011" EstimateCPU="1.01E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="101" LogicalOp="Compute Scalar" NodeId="3" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.000725747">
  798. <OutputList>
  799. <ColumnReference Column="Expr1057" />
  800. </OutputList>
  801. <ComputeScalar>
  802. <DefinedValues>
  803. <DefinedValue>
  804. <ColumnReference Column="Expr1057" />
  805. <ScalarOperator ScalarString="substring([@FundID],CONVERT_IMPLICIT(int,[Union1054],0),CONVERT_IMPLICIT(int,isnull(CONVERT_IMPLICIT(bigint,CASE WHEN charindex([@Delimiter],[@FundID],CONVERT_IMPLICIT(int,[Union1054],0))=(0) THEN NULL ELSE charindex([@Delimiter],[@FundID],CONVERT_IMPLICIT(int,[Union1054],0)) END,0)-[Union1054],(8000)),0))">
  806. <Intrinsic FunctionName="substring">
  807. <ScalarOperator>
  808. <Identifier>
  809. <ColumnReference Column="@FundID" />
  810. </Identifier>
  811. </ScalarOperator>
  812. <ScalarOperator>
  813. <Convert DataType="int" Style="0" Implicit="true">
  814. <ScalarOperator>
  815. <Identifier>
  816. <ColumnReference Column="Union1054" />
  817. </Identifier>
  818. </ScalarOperator>
  819. </Convert>
  820. </ScalarOperator>
  821. <ScalarOperator>
  822. <Convert DataType="int" Style="0" Implicit="true">
  823. <ScalarOperator>
  824. <Intrinsic FunctionName="isnull">
  825. <ScalarOperator>
  826. <Arithmetic Operation="SUB">
  827. <ScalarOperator>
  828. <Convert DataType="bigint" Style="0" Implicit="true">
  829. <ScalarOperator>
  830. <IF>
  831. <Condition>
  832. <ScalarOperator>
  833. <Compare CompareOp="EQ">
  834. <ScalarOperator>
  835. <Intrinsic FunctionName="charindex">
  836. <ScalarOperator>
  837. <Identifier>
  838. <ColumnReference Column="@Delimiter" />
  839. </Identifier>
  840. </ScalarOperator>
  841. <ScalarOperator>
  842. <Identifier>
  843. <ColumnReference Column="@FundID" />
  844. </Identifier>
  845. </ScalarOperator>
  846. <ScalarOperator>
  847. <Convert DataType="int" Style="0" Implicit="true">
  848. <ScalarOperator>
  849. <Identifier>
  850. <ColumnReference Column="Union1054" />
  851. </Identifier>
  852. </ScalarOperator>
  853. </Convert>
  854. </ScalarOperator>
  855. </Intrinsic>
  856. </ScalarOperator>
  857. <ScalarOperator>
  858. <Const ConstValue="(0)" />
  859. </ScalarOperator>
  860. </Compare>
  861. </ScalarOperator>
  862. </Condition>
  863. <Then>
  864. <ScalarOperator>
  865. <Const ConstValue="NULL" />
  866. </ScalarOperator>
  867. </Then>
  868. <Else>
  869. <ScalarOperator>
  870. <Intrinsic FunctionName="charindex">
  871. <ScalarOperator>
  872. <Identifier>
  873. <ColumnReference Column="@Delimiter" />
  874. </Identifier>
  875. </ScalarOperator>
  876. <ScalarOperator>
  877. <Identifier>
  878. <ColumnReference Column="@FundID" />
  879. </Identifier>
  880. </ScalarOperator>
  881. <ScalarOperator>
  882. <Convert DataType="int" Style="0" Implicit="true">
  883. <ScalarOperator>
  884. <Identifier>
  885. <ColumnReference Column="Union1054" />
  886. </Identifier>
  887. </ScalarOperator>
  888. </Convert>
  889. </ScalarOperator>
  890. </Intrinsic>
  891. </ScalarOperator>
  892. </Else>
  893. </IF>
  894. </ScalarOperator>
  895. </Convert>
  896. </ScalarOperator>
  897. <ScalarOperator>
  898. <Identifier>
  899. <ColumnReference Column="Union1054" />
  900. </Identifier>
  901. </ScalarOperator>
  902. </Arithmetic>
  903. </ScalarOperator>
  904. <ScalarOperator>
  905. <Const ConstValue="(8000)" />
  906. </ScalarOperator>
  907. </Intrinsic>
  908. </ScalarOperator>
  909. </Convert>
  910. </ScalarOperator>
  911. </Intrinsic>
  912. </ScalarOperator>
  913. </DefinedValue>
  914. </DefinedValues>
  915. <RelOp AvgRowSize="15" EstimateCPU="1.01E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="101" LogicalOp="Concatenation" NodeId="4" Parallel="false" PhysicalOp="Concatenation" EstimatedTotalSubtreeCost="0.000715647">
  916. <OutputList>
  917. <ColumnReference Column="Union1054" />
  918. </OutputList>
  919. <RunTimeInformation>
  920. <RunTimeCountersPerThread Thread="0" ActualRows="10" ActualEndOfScans="1" ActualExecutions="1" />
  921. </RunTimeInformation>
  922. <Concat>
  923. <DefinedValues>
  924. <DefinedValue>
  925. <ColumnReference Column="Union1054" />
  926. <ColumnReference Column="Expr1002" />
  927. <ColumnReference Column="Expr1053" />
  928. </DefinedValue>
  929. </DefinedValues>
  930. <RelOp AvgRowSize="15" EstimateCPU="1.157E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Constant Scan" NodeId="5" Parallel="false" PhysicalOp="Constant Scan" EstimatedTotalSubtreeCost="1.157E-06">
  931. <OutputList>
  932. <ColumnReference Column="Expr1002" />
  933. </OutputList>
  934. <RunTimeInformation>
  935. <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
  936. </RunTimeInformation>
  937. <ConstantScan>
  938. <Values>
  939. <Row>
  940. <ScalarOperator ScalarString="(1)">
  941. <Const ConstValue="(1)" />
  942. </ScalarOperator>
  943. </Row>
  944. </Values>
  945. </ConstantScan>
  946. </RelOp>
  947. <RelOp AvgRowSize="15" EstimateCPU="1E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="100" LogicalOp="Compute Scalar" NodeId="7" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.00070439">
  948. <OutputList>
  949. <ColumnReference Column="Expr1053" />
  950. </OutputList>
  951. <ComputeScalar>
  952. <DefinedValues>
  953. <DefinedValue>
  954. <ColumnReference Column="Expr1053" />
  955. <ScalarOperator ScalarString="[Expr1052]+(1)">
  956. <Arithmetic Operation="ADD">
  957. <ScalarOperator>
  958. <Identifier>
  959. <ColumnReference Column="Expr1052" />
  960. </Identifier>
  961. </ScalarOperator>
  962. <ScalarOperator>
  963. <Const ConstValue="(1)" />
  964. </ScalarOperator>
  965. </Arithmetic>
  966. </ScalarOperator>
  967. </DefinedValue>
  968. </DefinedValues>
  969. <RelOp AvgRowSize="15" EstimateCPU="8.8E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="100" LogicalOp="Filter" NodeId="8" Parallel="false" PhysicalOp="Filter" EstimatedTotalSubtreeCost="0.00069439">
  970. <OutputList>
  971. <ColumnReference Column="Expr1052" />
  972. </OutputList>
  973. <RunTimeInformation>
  974. <RunTimeCountersPerThread Thread="0" ActualRows="9" ActualEndOfScans="1" ActualExecutions="1" />
  975. </RunTimeInformation>
  976. <Filter StartupExpression="false">
  977. <RelOp AvgRowSize="15" EstimateCPU="1E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="100" LogicalOp="Top" NodeId="9" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="0.00060639">
  978. <OutputList>
  979. <ColumnReference Column="Expr1052" />
  980. </OutputList>
  981. <RunTimeInformation>
  982. <RunTimeCountersPerThread Thread="0" ActualRows="40" ActualEndOfScans="1" ActualExecutions="1" />
  983. </RunTimeInformation>
  984. <Top RowCount="false" IsPercent="false" WithTies="false">
  985. <TopExpression>
  986. <ScalarOperator ScalarString="CONVERT_IMPLICIT(bigint,isnull(datalength([@FundID]),(0)),0)">
  987. <Identifier>
  988. <ColumnReference Column="ConstExpr1059">
  989. <ScalarOperator>
  990. <Convert DataType="bigint" Style="0" Implicit="true">
  991. <ScalarOperator>
  992. <Intrinsic FunctionName="isnull">
  993. <ScalarOperator>
  994. <Intrinsic FunctionName="datalength">
  995. <ScalarOperator>
  996. <Identifier>
  997. <ColumnReference Column="@FundID" />
  998. </Identifier>
  999. </ScalarOperator>
  1000. </Intrinsic>
  1001. </ScalarOperator>
  1002. <ScalarOperator>
  1003. <Const ConstValue="(0)" />
  1004. </ScalarOperator>
  1005. </Intrinsic>
  1006. </ScalarOperator>
  1007. </Convert>
  1008. </ScalarOperator>
  1009. </ColumnReference>
  1010. </Identifier>
  1011. </ScalarOperator>
  1012. </TopExpression>
  1013. <RelOp AvgRowSize="15" EstimateCPU="0.0008" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="100" LogicalOp="Compute Scalar" NodeId="10" Parallel="false" PhysicalOp="Sequence Project" EstimatedTotalSubtreeCost="0.00059639">
  1014. <OutputList>
  1015. <ColumnReference Column="Expr1052" />
  1016. </OutputList>
  1017. <RunTimeInformation>
  1018. <RunTimeCountersPerThread Thread="0" ActualRows="40" ActualEndOfScans="0" ActualExecutions="1" />
  1019. </RunTimeInformation>
  1020. <SequenceProject>
  1021. <DefinedValues>
  1022. <DefinedValue>
  1023. <ColumnReference Column="Expr1052" />
  1024. <ScalarOperator ScalarString="row_number">
  1025. <Sequence FunctionName="row_number" />
  1026. </ScalarOperator>
  1027. </DefinedValue>
  1028. </DefinedValues>
  1029. <RelOp AvgRowSize="15" EstimateCPU="0.0002" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="100" LogicalOp="Segment" NodeId="11" Parallel="false" PhysicalOp="Segment" EstimatedTotalSubtreeCost="0.00058839">
  1030. <OutputList>
  1031. <ColumnReference Column="Segment1060" />
  1032. </OutputList>
  1033. <RunTimeInformation>
  1034. <RunTimeCountersPerThread Thread="0" ActualRows="40" ActualEndOfScans="0" ActualExecutions="1" />
  1035. </RunTimeInformation>
  1036. <Segment>
  1037. <GroupBy />
  1038. <SegmentColumn>
  1039. <ColumnReference Column="Segment1060" />
  1040. </SegmentColumn>
  1041. <RelOp AvgRowSize="9" EstimateCPU="0.0418" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="100" LogicalOp="Inner Join" NodeId="12" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00058639">
  1042. <OutputList />
  1043. <Warnings NoJoinPredicate="true" />
  1044. <RunTimeInformation>
  1045. <RunTimeCountersPerThread Thread="0" ActualRows="40" ActualEndOfScans="0" ActualExecutions="1" />
  1046. </RunTimeInformation>
  1047. <NestedLoops Optimized="false">
  1048. <RelOp AvgRowSize="9" EstimateCPU="0.00418" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="10" LogicalOp="Inner Join" NodeId="13" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="6.31521E-05">
  1049. <OutputList />
  1050. <Warnings NoJoinPredicate="true" />
  1051. <RunTimeInformation>
  1052. <RunTimeCountersPerThread Thread="0" ActualRows="4" ActualEndOfScans="0" ActualExecutions="1" />
  1053. </RunTimeInformation>
  1054. <NestedLoops Optimized="false">
  1055. <RelOp AvgRowSize="9" EstimateCPU="0.000418" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Inner Join" NodeId="14" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="6.494E-06">
  1056. <OutputList />
  1057. <Warnings NoJoinPredicate="true" />
  1058. <RunTimeInformation>
  1059. <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
  1060. </RunTimeInformation>
  1061. <NestedLoops Optimized="false">
  1062. <RelOp AvgRowSize="9" EstimateCPU="1.0157E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Constant Scan" NodeId="15" Parallel="false" PhysicalOp="Constant Scan" EstimatedTotalSubtreeCost="1.157E-06">
  1063. <OutputList />
  1064. <RunTimeInformation>
  1065. <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
  1066. </RunTimeInformation>
  1067. <ConstantScan />
  1068. </RelOp>
  1069. <RelOp AvgRowSize="9" EstimateCPU="1.0157E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Constant Scan" NodeId="16" Parallel="false" PhysicalOp="Constant Scan" EstimatedTotalSubtreeCost="1.157E-06">
  1070. <OutputList />
  1071. <RunTimeInformation>
  1072. <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
  1073. </RunTimeInformation>
  1074. <ConstantScan />
  1075. </RelOp>
  1076. </NestedLoops>
  1077. </RelOp>
  1078. <RelOp AvgRowSize="9" EstimateCPU="1.0157E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="10" LogicalOp="Constant Scan" NodeId="17" Parallel="false" PhysicalOp="Constant Scan" EstimatedTotalSubtreeCost="1.0157E-05">
  1079. <OutputList />
  1080. <RunTimeInformation>
  1081. <RunTimeCountersPerThread Thread="0" ActualRows="4" ActualEndOfScans="0" ActualExecutions="1" />
  1082. </RunTimeInformation>
  1083. <ConstantScan />
  1084. </RelOp>
  1085. </NestedLoops>
  1086. </RelOp>
  1087. <RelOp AvgRowSize="9" EstimateCPU="1.0157E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="9.99" EstimatedExecutionMode="Row" EstimateRows="10" LogicalOp="Constant Scan" NodeId="18" Parallel="false" PhysicalOp="Constant Scan" EstimatedTotalSubtreeCost="0.000110057">
  1088. <OutputList />
  1089. <RunTimeInformation>
  1090. <RunTimeCountersPerThread Thread="0" ActualRows="40" ActualEndOfScans="3" ActualExecutions="4" />
  1091. </RunTimeInformation>
  1092. <ConstantScan />
  1093. </RelOp>
  1094. </NestedLoops>
  1095. </RelOp>
  1096. </Segment>
  1097. </RelOp>
  1098. </SequenceProject>
  1099. </RelOp>
  1100. </Top>
  1101. </RelOp>
  1102. <Predicate>
  1103. <ScalarOperator ScalarString="substring([@FundID],CONVERT_IMPLICIT(int,[Expr1052],0),(1))=[@Delimiter]">
  1104. <Compare CompareOp="EQ">
  1105. <ScalarOperator>
  1106. <Intrinsic FunctionName="substring">
  1107. <ScalarOperator>
  1108. <Identifier>
  1109. <ColumnReference Column="@FundID" />
  1110. </Identifier>
  1111. </ScalarOperator>
  1112. <ScalarOperator>
  1113. <Convert DataType="int" Style="0" Implicit="true">
  1114. <ScalarOperator>
  1115. <Identifier>
  1116. <ColumnReference Column="Expr1052" />
  1117. </Identifier>
  1118. </ScalarOperator>
  1119. </Convert>
  1120. </ScalarOperator>
  1121. <ScalarOperator>
  1122. <Const ConstValue="(1)" />
  1123. </ScalarOperator>
  1124. </Intrinsic>
  1125. </ScalarOperator>
  1126. <ScalarOperator>
  1127. <Identifier>
  1128. <ColumnReference Column="@Delimiter" />
  1129. </Identifier>
  1130. </ScalarOperator>
  1131. </Compare>
  1132. </ScalarOperator>
  1133. </Predicate>
  1134. </Filter>
  1135. </RelOp>
  1136. </ComputeScalar>
  1137. </RelOp>
  1138. </Concat>
  1139. </RelOp>
  1140. </ComputeScalar>
  1141. </RelOp>
  1142. </Sort>
  1143. </RelOp>
  1144. </ComputeScalar>
  1145. </RelOp>
  1146. </Update>
  1147. </RelOp>
  1148. <ParameterList>
  1149. <ColumnReference Column="@Delimiter" ParameterRuntimeValue="'|'" />
  1150. <ColumnReference Column="@FundID" ParameterRuntimeValue="'218|219|220|221|222|225|226|227|606|1002'" />
  1151. </ParameterList>
  1152. </QueryPlan>
  1153. </StmtSimple>
  1154. </Statements>
  1155. </Batch>
  1156. <Batch>
  1157. <Statements>
  1158. <StmtSimple StatementCompId="33" StatementEstRows="7.41238" StatementId="4" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="120" StatementSubTreeCost="0.0633355" StatementText="INSERT INTO @ACCOUNTS &#xD;&#xA; (PORTFOLIO) &#xD;&#xA; SELECT DISTINCT FPFDM.PortfolioAccountID &#xD;&#xA; FROM dbo.formpfdatamapping FPFDM &#xD;&#xA; INNER JOIN dbo.formpffundmaintenance FPFM &#xD;&#xA; ON FPFDM.seiformpfdesc = FPFM.seiformpfdesc&#xD;&#xA; INNER JOIN @tempFundID fd &#xD;&#xA; ON fd.FundID = FPFM.id &#xD;&#xA; AND FPFM.IsFormPF = @IsFormPFflag" StatementType="INSERT" QueryHash="0xE34F6C808C1AEE7F" QueryPlanHash="0xC7FB181D33B698A4" RetrievedFromCache="false">
  1159. <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
  1160. <QueryPlan DegreeOfParallelism="0" NonParallelPlanReason="CouldNotGenerateValidParallelPlan" MemoryGrant="1624" CachedPlanSize="48" CompileTime="3" CompileCPU="3" CompileMemory="848">
  1161. <MemoryGrantInfo SerialRequiredMemory="1536" SerialDesiredMemory="1624" RequiredMemory="1536" DesiredMemory="1624" RequestedMemory="1624" GrantWaitTime="0" GrantedMemory="1624" MaxUsedMemory="328" />
  1162. <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="3145728" EstimatedPagesCached="3145728" EstimatedAvailableDegreeOfParallelism="8" />
  1163. <RelOp AvgRowSize="9" EstimateCPU="7.41238E-06" EstimateIO="0.01" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="7.41238" LogicalOp="Insert" NodeId="0" Parallel="false" PhysicalOp="Clustered Index Insert" EstimatedTotalSubtreeCost="0.0633355">
  1164. <OutputList />
  1165. <RunTimeInformation>
  1166. <RunTimeCountersPerThread Thread="0" ActualRows="31" ActualEndOfScans="1" ActualExecutions="1" />
  1167. </RunTimeInformation>
  1168. <Update DMLRequestSort="false">
  1169. <Object Table="[@ACCOUNTS]" Index="[PK__#A6304FF__31D13AAB75720ACF]" Storage="RowStore" />
  1170. <SetPredicate>
  1171. <ScalarOperator ScalarString="[PORTFOLIO] = [NETIKIP].[dbo].[FormPFDataMapping].[PortfolioAccountID] as [FPFDM].[PortfolioAccountID]">
  1172. <ScalarExpressionList>
  1173. <ScalarOperator>
  1174. <MultipleAssign>
  1175. <Assign>
  1176. <ColumnReference Column="PORTFOLIO" />
  1177. <ScalarOperator>
  1178. <Identifier>
  1179. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFDataMapping]" Alias="[FPFDM]" Column="PortfolioAccountID" />
  1180. </Identifier>
  1181. </ScalarOperator>
  1182. </Assign>
  1183. </MultipleAssign>
  1184. </ScalarOperator>
  1185. </ScalarExpressionList>
  1186. </ScalarOperator>
  1187. </SetPredicate>
  1188. <RelOp AvgRowSize="22" EstimateCPU="0.000148128" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="7.41238" LogicalOp="Distinct Sort" NodeId="1" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.0533281">
  1189. <OutputList>
  1190. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFDataMapping]" Alias="[FPFDM]" Column="PortfolioAccountID" />
  1191. </OutputList>
  1192. <MemoryFractions Input="0.363636" Output="1" />
  1193. <RunTimeInformation>
  1194. <RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="31" ActualEndOfScans="1" ActualExecutions="1" />
  1195. </RunTimeInformation>
  1196. <Sort Distinct="true">
  1197. <OrderBy>
  1198. <OrderByColumn Ascending="true">
  1199. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFDataMapping]" Alias="[FPFDM]" Column="PortfolioAccountID" />
  1200. </OrderByColumn>
  1201. </OrderBy>
  1202. <RelOp AvgRowSize="22" EstimateCPU="0.0262049" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="9.49619" LogicalOp="Inner Join" NodeId="2" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="0.0419187">
  1203. <OutputList>
  1204. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFDataMapping]" Alias="[FPFDM]" Column="PortfolioAccountID" />
  1205. </OutputList>
  1206. <MemoryFractions Input="1" Output="0.636364" />
  1207. <RunTimeInformation>
  1208. <RunTimeCountersPerThread Thread="0" ActualRows="31" ActualEndOfScans="1" ActualExecutions="1" />
  1209. </RunTimeInformation>
  1210. <Hash>
  1211. <DefinedValues />
  1212. <HashKeysBuild>
  1213. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFFundMaintenance]" Alias="[FPFM]" Column="SEIFormPFDesc" />
  1214. </HashKeysBuild>
  1215. <HashKeysProbe>
  1216. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFDataMapping]" Alias="[FPFDM]" Column="SEIFormPFDesc" />
  1217. </HashKeysProbe>
  1218. <ProbeResidual>
  1219. <ScalarOperator ScalarString="[NETIKIP].[dbo].[FormPFFundMaintenance].[SEIFormPFDesc] as [FPFM].[SEIFormPFDesc]=[NETIKIP].[dbo].[FormPFDataMapping].[SEIFormPFDesc] as [FPFDM].[SEIFormPFDesc]">
  1220. <Compare CompareOp="EQ">
  1221. <ScalarOperator>
  1222. <Identifier>
  1223. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFFundMaintenance]" Alias="[FPFM]" Column="SEIFormPFDesc" />
  1224. </Identifier>
  1225. </ScalarOperator>
  1226. <ScalarOperator>
  1227. <Identifier>
  1228. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFDataMapping]" Alias="[FPFDM]" Column="SEIFormPFDesc" />
  1229. </Identifier>
  1230. </ScalarOperator>
  1231. </Compare>
  1232. </ScalarOperator>
  1233. </ProbeResidual>
  1234. <RelOp AvgRowSize="22" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Inner Join" NodeId="3" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00657086">
  1235. <OutputList>
  1236. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFFundMaintenance]" Alias="[FPFM]" Column="SEIFormPFDesc" />
  1237. </OutputList>
  1238. <RunTimeInformation>
  1239. <RunTimeCountersPerThread Thread="0" ActualRows="10" ActualEndOfScans="1" ActualExecutions="1" />
  1240. </RunTimeInformation>
  1241. <NestedLoops Optimized="false">
  1242. <OuterReferences>
  1243. <ColumnReference Table="@tempFundID" Alias="[fd]" Column="FundID" />
  1244. </OuterReferences>
  1245. <RelOp AvgRowSize="11" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Scan" NodeId="4" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="0">
  1246. <OutputList>
  1247. <ColumnReference Table="@tempFundID" Alias="[fd]" Column="FundID" />
  1248. </OutputList>
  1249. <RunTimeInformation>
  1250. <RunTimeCountersPerThread Thread="0" ActualRows="10" ActualEndOfScans="1" ActualExecutions="1" />
  1251. </RunTimeInformation>
  1252. <IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  1253. <DefinedValues>
  1254. <DefinedValue>
  1255. <ColumnReference Table="@tempFundID" Alias="[fd]" Column="FundID" />
  1256. </DefinedValue>
  1257. </DefinedValues>
  1258. <Object Table="[@tempFundID]" Index="[PK__#A818986__830DFC7A5A6908F0]" Alias="[fd]" Storage="RowStore" />
  1259. </IndexScan>
  1260. </RelOp>
  1261. <RelOp AvgRowSize="23" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="5" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="779">
  1262. <OutputList>
  1263. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFFundMaintenance]" Alias="[FPFM]" Column="SEIFormPFDesc" />
  1264. </OutputList>
  1265. <RunTimeInformation>
  1266. <RunTimeCountersPerThread Thread="0" ActualRows="10" ActualEndOfScans="0" ActualExecutions="10" />
  1267. </RunTimeInformation>
  1268. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  1269. <DefinedValues>
  1270. <DefinedValue>
  1271. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFFundMaintenance]" Alias="[FPFM]" Column="SEIFormPFDesc" />
  1272. </DefinedValue>
  1273. </DefinedValues>
  1274. <Object Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFFundMaintenance]" Index="[PK_ID]" Alias="[FPFM]" IndexKind="Clustered" Storage="RowStore" />
  1275. <SeekPredicates>
  1276. <SeekPredicateNew>
  1277. <SeekKeys>
  1278. <Prefix ScanType="EQ">
  1279. <RangeColumns>
  1280. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFFundMaintenance]" Alias="[FPFM]" Column="ID" />
  1281. </RangeColumns>
  1282. <RangeExpressions>
  1283. <ScalarOperator ScalarString="@tempFundID.[FundID] as [fd].[FundID]">
  1284. <Identifier>
  1285. <ColumnReference Table="@tempFundID" Alias="[fd]" Column="FundID" />
  1286. </Identifier>
  1287. </ScalarOperator>
  1288. </RangeExpressions>
  1289. </Prefix>
  1290. </SeekKeys>
  1291. </SeekPredicateNew>
  1292. </SeekPredicates>
  1293. <Predicate>
  1294. <ScalarOperator ScalarString="[NETIKIP].[dbo].[FormPFFundMaintenance].[IsFormPF] as [FPFM].[IsFormPF]=[@IsFormPFflag]">
  1295. <Compare CompareOp="EQ">
  1296. <ScalarOperator>
  1297. <Identifier>
  1298. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFFundMaintenance]" Alias="[FPFM]" Column="IsFormPF" />
  1299. </Identifier>
  1300. </ScalarOperator>
  1301. <ScalarOperator>
  1302. <Identifier>
  1303. <ColumnReference Column="@IsFormPFflag" />
  1304. </Identifier>
  1305. </ScalarOperator>
  1306. </Compare>
  1307. </ScalarOperator>
  1308. </Predicate>
  1309. </IndexScan>
  1310. </RelOp>
  1311. </NestedLoops>
  1312. </RelOp>
  1313. <RelOp AvgRowSize="36" EstimateCPU="0.0015705" EstimateIO="0.00756944" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1285" LogicalOp="Clustered Index Scan" NodeId="6" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.00913994" TableCardinality="1285">
  1314. <OutputList>
  1315. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFDataMapping]" Alias="[FPFDM]" Column="PortfolioAccountID" />
  1316. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFDataMapping]" Alias="[FPFDM]" Column="SEIFormPFDesc" />
  1317. </OutputList>
  1318. <RunTimeInformation>
  1319. <RunTimeCountersPerThread Thread="0" ActualRows="1285" ActualEndOfScans="1" ActualExecutions="1" />
  1320. </RunTimeInformation>
  1321. <IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  1322. <DefinedValues>
  1323. <DefinedValue>
  1324. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFDataMapping]" Alias="[FPFDM]" Column="PortfolioAccountID" />
  1325. </DefinedValue>
  1326. <DefinedValue>
  1327. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFDataMapping]" Alias="[FPFDM]" Column="SEIFormPFDesc" />
  1328. </DefinedValue>
  1329. </DefinedValues>
  1330. <Object Database="[NETIKIP]" Schema="[dbo]" Table="[FormPFDataMapping]" Index="[PK_ID_Mapping]" Alias="[FPFDM]" IndexKind="Clustered" Storage="RowStore" />
  1331. </IndexScan>
  1332. </RelOp>
  1333. </Hash>
  1334. </RelOp>
  1335. </Sort>
  1336. </RelOp>
  1337. </Update>
  1338. </RelOp>
  1339. <ParameterList>
  1340. <ColumnReference Column="@IsFormPFflag" ParameterRuntimeValue="(1)" />
  1341. </ParameterList>
  1342. </QueryPlan>
  1343. </StmtSimple>
  1344. </Statements>
  1345. </Batch>
  1346. <Batch>
  1347. <Statements>
  1348. <StmtSimple StatementCompId="34" StatementEstRows="1.00339" StatementId="5" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="TimeOut" CardinalityEstimationModelVersion="120" StatementSubTreeCost="5.12696" StatementText="INSERT INTO #Temp1&#xD;&#xA; (PRCD_ALT_CMB_AMT, &#xD;&#xA; AGNT2_NME,&#xD;&#xA; ISS_FLD2_DESC,&#xD;&#xA; ISS_NME, &#xD;&#xA; Quantity,&#xD;&#xA; UT_PRC_ALT_CMB_AMT,&#xD;&#xA; FX_ALT_CMB_RTE,&#xD;&#xA; Point_Value_Amt,&#xD;&#xA; PRC_QUOTE_AMT,&#xD;&#xA; Delta,&#xD;&#xA; SYS_CURR_GROSS_AMT &#xD;&#xA; ) &#xD;&#xA; SELECT&#xD;&#xA; CAST(ROUND(ABS(TRANEVENT_DG.QUANTITY*TRANEVENT_DG.UT_PRC_CMB_AMT*TRANEVENT_DG.FX_ALT_CMB_RTE*ISSUE_DG.ISS_UT_AMT), 2) AS DECIMAL(18, 0)), &#xD;&#xA; ISSUE_DG.ISSUE_CLS1_NME,&#xD;&#xA; ISSUE_DG.FLD2_DESC as ISS_FLD2_DESC,&#xD;&#xA; ISSUE_DG.ISS_NME, &#xD;&#xA; TRANEVENT_DG.Quantity AS Quantity,&#xD;&#xA; Convert(varchar(255),TRANEVENT_DG.UT_PRC_ALT_CMB_AMT) as UT_PRC_ALT_CMB_AMT,&#xD;&#xA; Convert(varchar(255),TRANEVENT_DG.FX_ALT_CMB_RTE) as FX_ALT_CMB_RTE, &#xD;&#xA; Convert(varchar(255),SC.Point_Value_Amt) as Point_Value_Amt,&#xD;&#xA; Convert(varchar(255),Issue_Price.PRC_QUOTE_AMT) as PRC_QUOTE_AMT,&#xD;&#xA; Convert(varchar(255),REGPOS.Delta) as Delta, &#xD;&#xA; (CASE WHEN SYS_CURR_GROSS_AMT IS NOT NULL then ROUND(SYS_CURR_GROSS_AMT,-3) ELSE SYS_CURR_GROSS_AMT END) &#xD;&#xA; FROM dbo.TRANEVENT_DG TRANEVENT_DG&#xD;&#xA; INNER JOIN @ACCOUNTS A &#xD;&#xA; ON TRANEVENT_DG.ACCT_ID = A.PORTFOLIO&#xD;&#xA; INNER JOIN dbo.ISSUE_DG ISSUE_DG &#xD;&#xA; ON TRANEVENT_DG.INSTR_ID = ISSUE_DG.INSTR_ID&#xD;&#xA; LEFT OUTER JOIN EDW.V_SUPPLEMENTALSECURITYMASTER SC &#xD;&#xA; ON TRANEVENT_DG.INSTR_ID = SC.INSTR_ID &#xD;&#xA; LEFT OUTER JOIN DBO.REG_POSITION REGPOS &#xD;&#xA; ON TRANEVENT_DG.INSTR_ID= REGPOS.INSTR_ID &#xD;&#xA; AND (REGPOS.AS_OF_TMS = CASE @Month when 1 THEN @Month1_ToDate&#xD;&#xA; WHEN 2 then @Month2_ToDate &#xD;&#xA; ELSE @Month3_ToDate END)&#xD;&#xA; LEFT OUTER JOIN DBO.ISSUE_PRICE ISSUE_PRICE &#xD;&#xA; " StatementType="INSERT" QueryHash="0x311C1F0B9DCC2C33" QueryPlanHash="0xC5D906B24B348815" RetrievedFromCache="false">
  1349. <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
  1350. <QueryPlan DegreeOfParallelism="1" MemoryGrant="1104" CachedPlanSize="200" CompileTime="64" CompileCPU="64" CompileMemory="3640">
  1351. <MissingIndexes>
  1352. <MissingIndexGroup Impact="49.6287">
  1353. <MissingIndex Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]">
  1354. <ColumnGroup Usage="INEQUALITY">
  1355. <Column Name="[Futures_Category_Id]" ColumnId="2" />
  1356. </ColumnGroup>
  1357. <ColumnGroup Usage="INCLUDE">
  1358. <Column Name="[Underlying_Exchange_Code_Id]" ColumnId="3" />
  1359. <Column Name="[Instr_Id]" ColumnId="4" />
  1360. <Column Name="[Exchange_Code_Id]" ColumnId="5" />
  1361. <Column Name="[Deal_Type_Id]" ColumnId="6" />
  1362. <Column Name="[Regular_Reporting_Category_Id]" ColumnId="8" />
  1363. <Column Name="[Regular_Reporting_Group_Id]" ColumnId="9" />
  1364. <Column Name="[Point_Value_Amt]" ColumnId="10" />
  1365. </ColumnGroup>
  1366. </MissingIndex>
  1367. </MissingIndexGroup>
  1368. </MissingIndexes>
  1369. <Warnings>
  1370. <PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT(varchar(255),[TRANEVENT_DG].[UT_PRC_ALT_CMB_AMT],0)" />
  1371. <PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT(varchar(255),[TRANEVENT_DG].[FX_ALT_CMB_RTE],0)" />
  1372. <PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT(varchar(255),[s].[Point_Value_Amt],0)" />
  1373. <PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT(varchar(255),[ISSUE_PRICE].[PRC_QUOTE_AMT],0)" />
  1374. <PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT(varchar(255),[REGPOS].[delta],0)" />
  1375. </Warnings>
  1376. <MemoryGrantInfo SerialRequiredMemory="1024" SerialDesiredMemory="1104" RequiredMemory="1024" DesiredMemory="1104" RequestedMemory="1104" GrantWaitTime="0" GrantedMemory="1104" MaxUsedMemory="744" />
  1377. <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="3145728" EstimatedPagesCached="3145728" EstimatedAvailableDegreeOfParallelism="8" />
  1378. <RelOp AvgRowSize="9" EstimateCPU="1.00339E-06" EstimateIO="0.01" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.00339" LogicalOp="Insert" NodeId="0" Parallel="false" PhysicalOp="Clustered Index Insert" EstimatedTotalSubtreeCost="5.12696">
  1379. <OutputList />
  1380. <RunTimeInformation>
  1381. <RunTimeCountersPerThread Thread="0" ActualRows="12119" ActualEndOfScans="1" ActualExecutions="1" />
  1382. </RunTimeInformation>
  1383. <Update DMLRequestSort="false">
  1384. <Object Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Index="[PK__#Temp1____7D64573CCE1002E7]" IndexKind="Clustered" Storage="RowStore" />
  1385. <SetPredicate>
  1386. <ScalarOperator ScalarString="[tempdb].[dbo].[#Temp1].[PRCD_ALT_CMB_AMT] = [Expr1017],[tempdb].[dbo].[#Temp1].[AGNT2_NME] = [NETIKIP].[dbo].[ISSUE_DG].[ISSUE_CLS1_NME] as [ISSUE_DG].[ISSUE_CLS1_NME],[tempdb].[dbo].[#Temp1].[ISS_FLD2_DESC] = RaiseIfNullInsert([NETIKIP].[dbo].[ISSUE_DG].[FLD2_DESC] as [ISSUE_DG].[FLD2_DESC]),[tempdb].[dbo].[#Temp1].[ISS_NME] = RaiseIfNullInsert([NETIKIP].[dbo].[ISSUE_DG].[ISS_NME] as [ISSUE_DG].[ISS_NME]),[tempdb].[dbo].[#Temp1].[Quantity] = [Expr1018],[tempdb].[dbo].[#Temp1].[UT_PRC_ALT_CMB_AMT] = [Expr1019],[tempdb].[dbo].[#Temp1].[FX_ALT_CMB_RTE] = [Expr1020],[tempdb].[dbo].[#Temp1].[Point_Value_Amt] = [Expr1021],[tempdb].[dbo].[#Temp1].[PRC_QUOTE_AMT] = [Expr1022],[tempdb].[dbo].[#Temp1].[Delta] = [Expr1023],[tempdb].[dbo].[#Temp1].[SYS_CURR_GROSS_AMT] = [Expr1024],[tempdb].[dbo].[#Temp1].[ID] = [Expr1016]">
  1387. <ScalarExpressionList>
  1388. <ScalarOperator>
  1389. <MultipleAssign>
  1390. <Assign>
  1391. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="PRCD_ALT_CMB_AMT" />
  1392. <ScalarOperator>
  1393. <Identifier>
  1394. <ColumnReference Column="Expr1017" />
  1395. </Identifier>
  1396. </ScalarOperator>
  1397. </Assign>
  1398. <Assign>
  1399. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="AGNT2_NME" />
  1400. <ScalarOperator>
  1401. <Identifier>
  1402. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISSUE_CLS1_NME" />
  1403. </Identifier>
  1404. </ScalarOperator>
  1405. </Assign>
  1406. <Assign>
  1407. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="ISS_FLD2_DESC" />
  1408. <ScalarOperator>
  1409. <Intrinsic FunctionName="RaiseIfNullInsert">
  1410. <ScalarOperator>
  1411. <Identifier>
  1412. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="FLD2_DESC" />
  1413. </Identifier>
  1414. </ScalarOperator>
  1415. </Intrinsic>
  1416. </ScalarOperator>
  1417. </Assign>
  1418. <Assign>
  1419. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="ISS_NME" />
  1420. <ScalarOperator>
  1421. <Intrinsic FunctionName="RaiseIfNullInsert">
  1422. <ScalarOperator>
  1423. <Identifier>
  1424. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_NME" />
  1425. </Identifier>
  1426. </ScalarOperator>
  1427. </Intrinsic>
  1428. </ScalarOperator>
  1429. </Assign>
  1430. <Assign>
  1431. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="Quantity" />
  1432. <ScalarOperator>
  1433. <Identifier>
  1434. <ColumnReference Column="Expr1018" />
  1435. </Identifier>
  1436. </ScalarOperator>
  1437. </Assign>
  1438. <Assign>
  1439. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="UT_PRC_ALT_CMB_AMT" />
  1440. <ScalarOperator>
  1441. <Identifier>
  1442. <ColumnReference Column="Expr1019" />
  1443. </Identifier>
  1444. </ScalarOperator>
  1445. </Assign>
  1446. <Assign>
  1447. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="FX_ALT_CMB_RTE" />
  1448. <ScalarOperator>
  1449. <Identifier>
  1450. <ColumnReference Column="Expr1020" />
  1451. </Identifier>
  1452. </ScalarOperator>
  1453. </Assign>
  1454. <Assign>
  1455. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="Point_Value_Amt" />
  1456. <ScalarOperator>
  1457. <Identifier>
  1458. <ColumnReference Column="Expr1021" />
  1459. </Identifier>
  1460. </ScalarOperator>
  1461. </Assign>
  1462. <Assign>
  1463. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="PRC_QUOTE_AMT" />
  1464. <ScalarOperator>
  1465. <Identifier>
  1466. <ColumnReference Column="Expr1022" />
  1467. </Identifier>
  1468. </ScalarOperator>
  1469. </Assign>
  1470. <Assign>
  1471. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="Delta" />
  1472. <ScalarOperator>
  1473. <Identifier>
  1474. <ColumnReference Column="Expr1023" />
  1475. </Identifier>
  1476. </ScalarOperator>
  1477. </Assign>
  1478. <Assign>
  1479. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="SYS_CURR_GROSS_AMT" />
  1480. <ScalarOperator>
  1481. <Identifier>
  1482. <ColumnReference Column="Expr1024" />
  1483. </Identifier>
  1484. </ScalarOperator>
  1485. </Assign>
  1486. <Assign>
  1487. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="ID" />
  1488. <ScalarOperator>
  1489. <Identifier>
  1490. <ColumnReference Column="Expr1016" />
  1491. </Identifier>
  1492. </ScalarOperator>
  1493. </Assign>
  1494. </MultipleAssign>
  1495. </ScalarOperator>
  1496. </ScalarExpressionList>
  1497. </ScalarOperator>
  1498. </SetPredicate>
  1499. <RelOp AvgRowSize="937" EstimateCPU="1.00339E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.00339" LogicalOp="Compute Scalar" NodeId="1" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="5.11696">
  1500. <OutputList>
  1501. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_NME" />
  1502. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="FLD2_DESC" />
  1503. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISSUE_CLS1_NME" />
  1504. <ColumnReference Column="Expr1016" />
  1505. <ColumnReference Column="Expr1017" />
  1506. <ColumnReference Column="Expr1018" />
  1507. <ColumnReference Column="Expr1019" />
  1508. <ColumnReference Column="Expr1020" />
  1509. <ColumnReference Column="Expr1021" />
  1510. <ColumnReference Column="Expr1022" />
  1511. <ColumnReference Column="Expr1023" />
  1512. <ColumnReference Column="Expr1024" />
  1513. </OutputList>
  1514. <ComputeScalar>
  1515. <DefinedValues>
  1516. <DefinedValue>
  1517. <ColumnReference Column="Expr1017" />
  1518. <ScalarOperator ScalarString="CONVERT(decimal(18,0),round(abs([NETIKIP].[dbo].[TRANEVENT_DG].[QUANTITY] as [TRANEVENT_DG].[QUANTITY]*[NETIKIP].[dbo].[TRANEVENT_DG].[UT_PRC_CMB_AMT] as [TRANEVENT_DG].[UT_PRC_CMB_AMT]*[NETIKIP].[dbo].[TRANEVENT_DG].[FX_ALT_CMB_RTE] as [TRANEVENT_DG].[FX_ALT_CMB_RTE]*[NETIKIP].[dbo].[ISSUE_DG].[ISS_UT_AMT] as [ISSUE_DG].[ISS_UT_AMT]),(2)),0)">
  1519. <Convert DataType="decimal" Precision="18" Scale="0" Style="0" Implicit="false">
  1520. <ScalarOperator>
  1521. <Intrinsic FunctionName="round">
  1522. <ScalarOperator>
  1523. <Intrinsic FunctionName="abs">
  1524. <ScalarOperator>
  1525. <Arithmetic Operation="MULT">
  1526. <ScalarOperator>
  1527. <Arithmetic Operation="MULT">
  1528. <ScalarOperator>
  1529. <Arithmetic Operation="MULT">
  1530. <ScalarOperator>
  1531. <Identifier>
  1532. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="QUANTITY" />
  1533. </Identifier>
  1534. </ScalarOperator>
  1535. <ScalarOperator>
  1536. <Identifier>
  1537. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="UT_PRC_CMB_AMT" />
  1538. </Identifier>
  1539. </ScalarOperator>
  1540. </Arithmetic>
  1541. </ScalarOperator>
  1542. <ScalarOperator>
  1543. <Identifier>
  1544. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="FX_ALT_CMB_RTE" />
  1545. </Identifier>
  1546. </ScalarOperator>
  1547. </Arithmetic>
  1548. </ScalarOperator>
  1549. <ScalarOperator>
  1550. <Identifier>
  1551. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_UT_AMT" />
  1552. </Identifier>
  1553. </ScalarOperator>
  1554. </Arithmetic>
  1555. </ScalarOperator>
  1556. </Intrinsic>
  1557. </ScalarOperator>
  1558. <ScalarOperator>
  1559. <Const ConstValue="(2)" />
  1560. </ScalarOperator>
  1561. <ScalarOperator>
  1562. <Const ConstValue="" />
  1563. </ScalarOperator>
  1564. </Intrinsic>
  1565. </ScalarOperator>
  1566. </Convert>
  1567. </ScalarOperator>
  1568. </DefinedValue>
  1569. <DefinedValue>
  1570. <ColumnReference Column="Expr1018" />
  1571. <ScalarOperator ScalarString="CONVERT_IMPLICIT(decimal(18,0),[NETIKIP].[dbo].[TRANEVENT_DG].[QUANTITY] as [TRANEVENT_DG].[QUANTITY],0)">
  1572. <Convert DataType="decimal" Precision="18" Scale="0" Style="0" Implicit="true">
  1573. <ScalarOperator>
  1574. <Identifier>
  1575. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="QUANTITY" />
  1576. </Identifier>
  1577. </ScalarOperator>
  1578. </Convert>
  1579. </ScalarOperator>
  1580. </DefinedValue>
  1581. <DefinedValue>
  1582. <ColumnReference Column="Expr1019" />
  1583. <ScalarOperator ScalarString="CONVERT(varchar(255),[NETIKIP].[dbo].[TRANEVENT_DG].[UT_PRC_ALT_CMB_AMT] as [TRANEVENT_DG].[UT_PRC_ALT_CMB_AMT],0)">
  1584. <Convert DataType="varchar" Length="255" Style="0" Implicit="false">
  1585. <ScalarOperator>
  1586. <Identifier>
  1587. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="UT_PRC_ALT_CMB_AMT" />
  1588. </Identifier>
  1589. </ScalarOperator>
  1590. </Convert>
  1591. </ScalarOperator>
  1592. </DefinedValue>
  1593. <DefinedValue>
  1594. <ColumnReference Column="Expr1020" />
  1595. <ScalarOperator ScalarString="CONVERT(varchar(255),[NETIKIP].[dbo].[TRANEVENT_DG].[FX_ALT_CMB_RTE] as [TRANEVENT_DG].[FX_ALT_CMB_RTE],0)">
  1596. <Convert DataType="varchar" Length="255" Style="0" Implicit="false">
  1597. <ScalarOperator>
  1598. <Identifier>
  1599. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="FX_ALT_CMB_RTE" />
  1600. </Identifier>
  1601. </ScalarOperator>
  1602. </Convert>
  1603. </ScalarOperator>
  1604. </DefinedValue>
  1605. <DefinedValue>
  1606. <ColumnReference Column="Expr1021" />
  1607. <ScalarOperator ScalarString="CONVERT(varchar(255),[NETIKIP].[edw].[Supplemental_Security_Master].[Point_Value_Amt] as [s].[Point_Value_Amt],0)">
  1608. <Convert DataType="varchar" Length="255" Style="0" Implicit="false">
  1609. <ScalarOperator>
  1610. <Identifier>
  1611. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Point_Value_Amt" />
  1612. </Identifier>
  1613. </ScalarOperator>
  1614. </Convert>
  1615. </ScalarOperator>
  1616. </DefinedValue>
  1617. <DefinedValue>
  1618. <ColumnReference Column="Expr1022" />
  1619. <ScalarOperator ScalarString="CONVERT(varchar(255),[NETIKIP].[dbo].[ISSUE_PRICE].[PRC_QUOTE_AMT] as [ISSUE_PRICE].[PRC_QUOTE_AMT],0)">
  1620. <Convert DataType="varchar" Length="255" Style="0" Implicit="false">
  1621. <ScalarOperator>
  1622. <Identifier>
  1623. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_PRICE]" Alias="[ISSUE_PRICE]" Column="PRC_QUOTE_AMT" />
  1624. </Identifier>
  1625. </ScalarOperator>
  1626. </Convert>
  1627. </ScalarOperator>
  1628. </DefinedValue>
  1629. <DefinedValue>
  1630. <ColumnReference Column="Expr1023" />
  1631. <ScalarOperator ScalarString="CONVERT(varchar(255),[NETIKIP].[dbo].[reg_position].[delta] as [REGPOS].[delta],0)">
  1632. <Convert DataType="varchar" Length="255" Style="0" Implicit="false">
  1633. <ScalarOperator>
  1634. <Identifier>
  1635. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[reg_position]" Alias="[REGPOS]" Column="delta" />
  1636. </Identifier>
  1637. </ScalarOperator>
  1638. </Convert>
  1639. </ScalarOperator>
  1640. </DefinedValue>
  1641. <DefinedValue>
  1642. <ColumnReference Column="Expr1024" />
  1643. <ScalarOperator ScalarString="CONVERT_IMPLICIT(decimal(18,0),CASE WHEN [NETIKIP].[dbo].[TRANEVENT_DG].[Sys_Curr_Gross_Amt] as [TRANEVENT_DG].[Sys_Curr_Gross_Amt] IS NOT NULL THEN round([NETIKIP].[dbo].[TRANEVENT_DG].[Sys_Curr_Gross_Amt] as [TRANEVENT_DG].[Sys_Curr_Gross_Amt],(-3)) ELSE [NETIKIP].[dbo].[TRANEVENT_DG].[Sys_Curr_Gross_Amt] as [TRANEVENT_DG].[Sys_Curr_Gross_Amt] END,0)">
  1644. <Convert DataType="decimal" Precision="18" Scale="0" Style="0" Implicit="true">
  1645. <ScalarOperator>
  1646. <IF>
  1647. <Condition>
  1648. <ScalarOperator>
  1649. <Compare CompareOp="IS NOT">
  1650. <ScalarOperator>
  1651. <Identifier>
  1652. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="Sys_Curr_Gross_Amt" />
  1653. </Identifier>
  1654. </ScalarOperator>
  1655. <ScalarOperator>
  1656. <Const ConstValue="NULL" />
  1657. </ScalarOperator>
  1658. </Compare>
  1659. </ScalarOperator>
  1660. </Condition>
  1661. <Then>
  1662. <ScalarOperator>
  1663. <Intrinsic FunctionName="round">
  1664. <ScalarOperator>
  1665. <Identifier>
  1666. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="Sys_Curr_Gross_Amt" />
  1667. </Identifier>
  1668. </ScalarOperator>
  1669. <ScalarOperator>
  1670. <Const ConstValue="(-3)" />
  1671. </ScalarOperator>
  1672. <ScalarOperator>
  1673. <Const ConstValue="" />
  1674. </ScalarOperator>
  1675. </Intrinsic>
  1676. </ScalarOperator>
  1677. </Then>
  1678. <Else>
  1679. <ScalarOperator>
  1680. <Identifier>
  1681. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="Sys_Curr_Gross_Amt" />
  1682. </Identifier>
  1683. </ScalarOperator>
  1684. </Else>
  1685. </IF>
  1686. </ScalarOperator>
  1687. </Convert>
  1688. </ScalarOperator>
  1689. </DefinedValue>
  1690. </DefinedValues>
  1691. <RelOp AvgRowSize="337" EstimateCPU="1.00339E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.00339" LogicalOp="Compute Scalar" NodeId="2" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="5.11696">
  1692. <OutputList>
  1693. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="FX_ALT_CMB_RTE" />
  1694. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="QUANTITY" />
  1695. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="UT_PRC_CMB_AMT" />
  1696. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="UT_PRC_ALT_CMB_AMT" />
  1697. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="Sys_Curr_Gross_Amt" />
  1698. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_NME" />
  1699. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_UT_AMT" />
  1700. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="FLD2_DESC" />
  1701. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISSUE_CLS1_NME" />
  1702. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Point_Value_Amt" />
  1703. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[reg_position]" Alias="[REGPOS]" Column="delta" />
  1704. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_PRICE]" Alias="[ISSUE_PRICE]" Column="PRC_QUOTE_AMT" />
  1705. <ColumnReference Column="Expr1016" />
  1706. </OutputList>
  1707. <RunTimeInformation>
  1708. <RunTimeCountersPerThread Thread="0" ActualRows="12119" ActualEndOfScans="1" ActualExecutions="1" />
  1709. </RunTimeInformation>
  1710. <ComputeScalar ComputeSequence="true">
  1711. <DefinedValues>
  1712. <DefinedValue>
  1713. <ColumnReference Column="Expr1016" />
  1714. <ScalarOperator ScalarString="getidentity((-1346782666),(2),NULL)">
  1715. <Intrinsic FunctionName="getidentity">
  1716. <ScalarOperator>
  1717. <Const ConstValue="(-1346782666)" />
  1718. </ScalarOperator>
  1719. <ScalarOperator>
  1720. <Const ConstValue="(2)" />
  1721. </ScalarOperator>
  1722. <ScalarOperator>
  1723. <Const ConstValue="NULL" />
  1724. </ScalarOperator>
  1725. </Intrinsic>
  1726. </ScalarOperator>
  1727. </DefinedValue>
  1728. </DefinedValues>
  1729. <RelOp AvgRowSize="333" EstimateCPU="4.1939E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.00339" LogicalOp="Left Outer Join" NodeId="3" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="5.11696">
  1730. <OutputList>
  1731. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="FX_ALT_CMB_RTE" />
  1732. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="QUANTITY" />
  1733. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="UT_PRC_CMB_AMT" />
  1734. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="UT_PRC_ALT_CMB_AMT" />
  1735. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="Sys_Curr_Gross_Amt" />
  1736. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_NME" />
  1737. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_UT_AMT" />
  1738. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="FLD2_DESC" />
  1739. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISSUE_CLS1_NME" />
  1740. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Point_Value_Amt" />
  1741. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[reg_position]" Alias="[REGPOS]" Column="delta" />
  1742. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_PRICE]" Alias="[ISSUE_PRICE]" Column="PRC_QUOTE_AMT" />
  1743. </OutputList>
  1744. <RunTimeInformation>
  1745. <RunTimeCountersPerThread Thread="0" ActualRows="12119" ActualEndOfScans="1" ActualExecutions="1" />
  1746. </RunTimeInformation>
  1747. <NestedLoops Optimized="false">
  1748. <OuterReferences>
  1749. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="UNDLY_ISS_ID" />
  1750. </OuterReferences>
  1751. <RelOp AvgRowSize="332" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.00333" LogicalOp="Left Outer Join" NodeId="4" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="5.11367">
  1752. <OutputList>
  1753. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="FX_ALT_CMB_RTE" />
  1754. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="QUANTITY" />
  1755. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="UT_PRC_CMB_AMT" />
  1756. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="UT_PRC_ALT_CMB_AMT" />
  1757. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="Sys_Curr_Gross_Amt" />
  1758. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_NME" />
  1759. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_UT_AMT" />
  1760. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="UNDLY_ISS_ID" />
  1761. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="FLD2_DESC" />
  1762. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISSUE_CLS1_NME" />
  1763. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Point_Value_Amt" />
  1764. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[reg_position]" Alias="[REGPOS]" Column="delta" />
  1765. </OutputList>
  1766. <RunTimeInformation>
  1767. <RunTimeCountersPerThread Thread="0" ActualRows="12119" ActualEndOfScans="1" ActualExecutions="1" />
  1768. </RunTimeInformation>
  1769. <NestedLoops Optimized="false">
  1770. <OuterReferences>
  1771. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="INSTR_ID" />
  1772. </OuterReferences>
  1773. <RelOp AvgRowSize="340" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Inner Join" NodeId="5" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="5.11038">
  1774. <OutputList>
  1775. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="FX_ALT_CMB_RTE" />
  1776. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="INSTR_ID" />
  1777. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="QUANTITY" />
  1778. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="UT_PRC_CMB_AMT" />
  1779. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="UT_PRC_ALT_CMB_AMT" />
  1780. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="Sys_Curr_Gross_Amt" />
  1781. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_NME" />
  1782. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_UT_AMT" />
  1783. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="UNDLY_ISS_ID" />
  1784. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="FLD2_DESC" />
  1785. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISSUE_CLS1_NME" />
  1786. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Point_Value_Amt" />
  1787. </OutputList>
  1788. <RunTimeInformation>
  1789. <RunTimeCountersPerThread Thread="0" ActualRows="12108" ActualEndOfScans="1" ActualExecutions="1" />
  1790. </RunTimeInformation>
  1791. <NestedLoops Optimized="false">
  1792. <OuterReferences>
  1793. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Regular_Reporting_Group_Id" />
  1794. </OuterReferences>
  1795. <RelOp AvgRowSize="344" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Inner Join" NodeId="6" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="5.10709">
  1796. <OutputList>
  1797. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="FX_ALT_CMB_RTE" />
  1798. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="INSTR_ID" />
  1799. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="QUANTITY" />
  1800. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="UT_PRC_CMB_AMT" />
  1801. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="UT_PRC_ALT_CMB_AMT" />
  1802. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="Sys_Curr_Gross_Amt" />
  1803. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_NME" />
  1804. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_UT_AMT" />
  1805. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="UNDLY_ISS_ID" />
  1806. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="FLD2_DESC" />
  1807. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISSUE_CLS1_NME" />
  1808. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Regular_Reporting_Group_Id" />
  1809. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Point_Value_Amt" />
  1810. </OutputList>
  1811. <RunTimeInformation>
  1812. <RunTimeCountersPerThread Thread="0" ActualRows="12108" ActualEndOfScans="1" ActualExecutions="1" />
  1813. </RunTimeInformation>
  1814. <NestedLoops Optimized="false">
  1815. <OuterReferences>
  1816. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ACCT_ID" />
  1817. </OuterReferences>
  1818. <RelOp AvgRowSize="356" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Inner Join" NodeId="7" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="5.10381">
  1819. <OutputList>
  1820. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ACCT_ID" />
  1821. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="FX_ALT_CMB_RTE" />
  1822. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="INSTR_ID" />
  1823. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="QUANTITY" />
  1824. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="UT_PRC_CMB_AMT" />
  1825. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="UT_PRC_ALT_CMB_AMT" />
  1826. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="Sys_Curr_Gross_Amt" />
  1827. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_NME" />
  1828. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_UT_AMT" />
  1829. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="UNDLY_ISS_ID" />
  1830. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="FLD2_DESC" />
  1831. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISSUE_CLS1_NME" />
  1832. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Regular_Reporting_Group_Id" />
  1833. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Point_Value_Amt" />
  1834. </OutputList>
  1835. <RunTimeInformation>
  1836. <RunTimeCountersPerThread Thread="0" ActualRows="161440" ActualEndOfScans="1" ActualExecutions="1" />
  1837. </RunTimeInformation>
  1838. <NestedLoops Optimized="false">
  1839. <OuterReferences>
  1840. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Regular_Reporting_Category_Id" />
  1841. </OuterReferences>
  1842. <RelOp AvgRowSize="360" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Inner Join" NodeId="8" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="5.10052">
  1843. <OutputList>
  1844. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ACCT_ID" />
  1845. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="FX_ALT_CMB_RTE" />
  1846. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="INSTR_ID" />
  1847. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="QUANTITY" />
  1848. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="UT_PRC_CMB_AMT" />
  1849. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="UT_PRC_ALT_CMB_AMT" />
  1850. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="Sys_Curr_Gross_Amt" />
  1851. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_NME" />
  1852. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_UT_AMT" />
  1853. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="UNDLY_ISS_ID" />
  1854. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="FLD2_DESC" />
  1855. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISSUE_CLS1_NME" />
  1856. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Regular_Reporting_Category_Id" />
  1857. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Regular_Reporting_Group_Id" />
  1858. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Point_Value_Amt" />
  1859. </OutputList>
  1860. <RunTimeInformation>
  1861. <RunTimeCountersPerThread Thread="0" ActualRows="161440" ActualEndOfScans="1" ActualExecutions="1" />
  1862. </RunTimeInformation>
  1863. <NestedLoops Optimized="false">
  1864. <OuterReferences>
  1865. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Deal_Type_Id" />
  1866. </OuterReferences>
  1867. <RelOp AvgRowSize="364" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Inner Join" NodeId="9" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="5.09723">
  1868. <OutputList>
  1869. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ACCT_ID" />
  1870. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="FX_ALT_CMB_RTE" />
  1871. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="INSTR_ID" />
  1872. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="QUANTITY" />
  1873. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="UT_PRC_CMB_AMT" />
  1874. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="UT_PRC_ALT_CMB_AMT" />
  1875. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="Sys_Curr_Gross_Amt" />
  1876. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_NME" />
  1877. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_UT_AMT" />
  1878. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="UNDLY_ISS_ID" />
  1879. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="FLD2_DESC" />
  1880. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISSUE_CLS1_NME" />
  1881. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Deal_Type_Id" />
  1882. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Regular_Reporting_Category_Id" />
  1883. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Regular_Reporting_Group_Id" />
  1884. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Point_Value_Amt" />
  1885. </OutputList>
  1886. <RunTimeInformation>
  1887. <RunTimeCountersPerThread Thread="0" ActualRows="161440" ActualEndOfScans="1" ActualExecutions="1" />
  1888. </RunTimeInformation>
  1889. <NestedLoops Optimized="false">
  1890. <OuterReferences>
  1891. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Exchange_Code_Id" />
  1892. </OuterReferences>
  1893. <RelOp AvgRowSize="369" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Inner Join" NodeId="10" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="5.09394">
  1894. <OutputList>
  1895. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ACCT_ID" />
  1896. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="FX_ALT_CMB_RTE" />
  1897. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="INSTR_ID" />
  1898. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="QUANTITY" />
  1899. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="UT_PRC_CMB_AMT" />
  1900. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="UT_PRC_ALT_CMB_AMT" />
  1901. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="Sys_Curr_Gross_Amt" />
  1902. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_NME" />
  1903. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_UT_AMT" />
  1904. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="UNDLY_ISS_ID" />
  1905. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="FLD2_DESC" />
  1906. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISSUE_CLS1_NME" />
  1907. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Exchange_Code_Id" />
  1908. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Deal_Type_Id" />
  1909. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Regular_Reporting_Category_Id" />
  1910. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Regular_Reporting_Group_Id" />
  1911. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Point_Value_Amt" />
  1912. </OutputList>
  1913. <RunTimeInformation>
  1914. <RunTimeCountersPerThread Thread="0" ActualRows="161440" ActualEndOfScans="1" ActualExecutions="1" />
  1915. </RunTimeInformation>
  1916. <NestedLoops Optimized="false">
  1917. <OuterReferences>
  1918. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Underlying_Exchange_Code_Id" />
  1919. </OuterReferences>
  1920. <RelOp AvgRowSize="392" EstimateCPU="0.00010306" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="24.6554" LogicalOp="Inner Join" NodeId="11" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="5.0906">
  1921. <OutputList>
  1922. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ACCT_ID" />
  1923. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="FX_ALT_CMB_RTE" />
  1924. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="INSTR_ID" />
  1925. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="QUANTITY" />
  1926. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="UT_PRC_CMB_AMT" />
  1927. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="UT_PRC_ALT_CMB_AMT" />
  1928. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="Sys_Curr_Gross_Amt" />
  1929. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_NME" />
  1930. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_UT_AMT" />
  1931. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="UNDLY_ISS_ID" />
  1932. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="FLD2_DESC" />
  1933. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISSUE_CLS1_NME" />
  1934. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Underlying_Exchange_Code_Id" />
  1935. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Exchange_Code_Id" />
  1936. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Deal_Type_Id" />
  1937. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Regular_Reporting_Category_Id" />
  1938. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Regular_Reporting_Group_Id" />
  1939. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Point_Value_Amt" />
  1940. </OutputList>
  1941. <RunTimeInformation>
  1942. <RunTimeCountersPerThread Thread="0" ActualRows="161440" ActualEndOfScans="1" ActualExecutions="1" />
  1943. </RunTimeInformation>
  1944. <NestedLoops Optimized="true">
  1945. <OuterReferences>
  1946. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ACCT_ID" />
  1947. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ACTG_TRN_EV_ID" />
  1948. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ACTG_TRN_ID" />
  1949. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="BK_ID" />
  1950. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="INQ_BASIS_NUM" />
  1951. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ORG_ID" />
  1952. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="RPT_TMS" />
  1953. </OuterReferences>
  1954. <RelOp AvgRowSize="373" EstimateCPU="0.00010306" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="24.6554" LogicalOp="Inner Join" NodeId="13" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="5.08348">
  1955. <OutputList>
  1956. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ACCT_ID" />
  1957. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ACTG_TRN_EV_ID" />
  1958. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ACTG_TRN_ID" />
  1959. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="BK_ID" />
  1960. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="INQ_BASIS_NUM" />
  1961. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="INSTR_ID" />
  1962. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ORG_ID" />
  1963. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="RPT_TMS" />
  1964. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_NME" />
  1965. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_UT_AMT" />
  1966. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="UNDLY_ISS_ID" />
  1967. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="FLD2_DESC" />
  1968. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISSUE_CLS1_NME" />
  1969. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Underlying_Exchange_Code_Id" />
  1970. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Exchange_Code_Id" />
  1971. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Deal_Type_Id" />
  1972. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Regular_Reporting_Category_Id" />
  1973. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Regular_Reporting_Group_Id" />
  1974. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Point_Value_Amt" />
  1975. </OutputList>
  1976. <RunTimeInformation>
  1977. <RunTimeCountersPerThread Thread="0" ActualRows="2217376" ActualEndOfScans="1" ActualExecutions="1" />
  1978. </RunTimeInformation>
  1979. <NestedLoops Optimized="true">
  1980. <OuterReferences>
  1981. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Instr_Id" />
  1982. </OuterReferences>
  1983. <RelOp AvgRowSize="314" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Inner Join" NodeId="15" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="5.07874">
  1984. <OutputList>
  1985. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_NME" />
  1986. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_UT_AMT" />
  1987. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="UNDLY_ISS_ID" />
  1988. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="FLD2_DESC" />
  1989. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISSUE_CLS1_NME" />
  1990. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Underlying_Exchange_Code_Id" />
  1991. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Instr_Id" />
  1992. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Exchange_Code_Id" />
  1993. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Deal_Type_Id" />
  1994. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Regular_Reporting_Category_Id" />
  1995. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Regular_Reporting_Group_Id" />
  1996. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Point_Value_Amt" />
  1997. </OutputList>
  1998. <RunTimeInformation>
  1999. <RunTimeCountersPerThread Thread="0" ActualRows="4045" ActualEndOfScans="1" ActualExecutions="1" />
  2000. </RunTimeInformation>
  2001. <NestedLoops Optimized="false">
  2002. <OuterReferences>
  2003. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="INSTR_ID" />
  2004. </OuterReferences>
  2005. <RelOp AvgRowSize="178" EstimateCPU="0.0325204" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Inner Join" NodeId="16" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="5.07545">
  2006. <OutputList>
  2007. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="INSTR_ID" />
  2008. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_NME" />
  2009. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Underlying_Exchange_Code_Id" />
  2010. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Instr_Id" />
  2011. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Exchange_Code_Id" />
  2012. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Deal_Type_Id" />
  2013. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Regular_Reporting_Category_Id" />
  2014. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Regular_Reporting_Group_Id" />
  2015. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Point_Value_Amt" />
  2016. </OutputList>
  2017. <RunTimeInformation>
  2018. <RunTimeCountersPerThread Thread="0" ActualRows="7780" ActualEndOfScans="1" ActualExecutions="1" />
  2019. </RunTimeInformation>
  2020. <NestedLoops Optimized="false" WithUnorderedPrefetch="true">
  2021. <OuterReferences>
  2022. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Instr_Id" />
  2023. <ColumnReference Column="Expr1030" />
  2024. </OuterReferences>
  2025. <RelOp AvgRowSize="51" EstimateCPU="0.752382" EstimateIO="2.72913" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="7780" LogicalOp="Clustered Index Scan" NodeId="18" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="3.48151" TableCardinality="683912">
  2026. <OutputList>
  2027. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Underlying_Exchange_Code_Id" />
  2028. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Instr_Id" />
  2029. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Exchange_Code_Id" />
  2030. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Deal_Type_Id" />
  2031. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Regular_Reporting_Category_Id" />
  2032. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Regular_Reporting_Group_Id" />
  2033. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Point_Value_Amt" />
  2034. </OutputList>
  2035. <RunTimeInformation>
  2036. <RunTimeCountersPerThread Thread="0" ActualRows="7780" ActualEndOfScans="1" ActualExecutions="1" />
  2037. </RunTimeInformation>
  2038. <IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  2039. <DefinedValues>
  2040. <DefinedValue>
  2041. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Underlying_Exchange_Code_Id" />
  2042. </DefinedValue>
  2043. <DefinedValue>
  2044. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Instr_Id" />
  2045. </DefinedValue>
  2046. <DefinedValue>
  2047. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Exchange_Code_Id" />
  2048. </DefinedValue>
  2049. <DefinedValue>
  2050. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Deal_Type_Id" />
  2051. </DefinedValue>
  2052. <DefinedValue>
  2053. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Regular_Reporting_Category_Id" />
  2054. </DefinedValue>
  2055. <DefinedValue>
  2056. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Regular_Reporting_Group_Id" />
  2057. </DefinedValue>
  2058. <DefinedValue>
  2059. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Point_Value_Amt" />
  2060. </DefinedValue>
  2061. </DefinedValues>
  2062. <Object Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Index="[PK__Supplemental_Security_Master]" Alias="[s]" IndexKind="Clustered" Storage="RowStore" />
  2063. <Predicate>
  2064. <ScalarOperator ScalarString="[NETIKIP].[edw].[Supplemental_Security_Master].[Futures_Category_Id] as [s].[Futures_Category_Id]&lt;&gt;(0)">
  2065. <Compare CompareOp="NE">
  2066. <ScalarOperator>
  2067. <Identifier>
  2068. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Futures_Category_Id" />
  2069. </Identifier>
  2070. </ScalarOperator>
  2071. <ScalarOperator>
  2072. <Const ConstValue="(0)" />
  2073. </ScalarOperator>
  2074. </Compare>
  2075. </ScalarOperator>
  2076. </Predicate>
  2077. </IndexScan>
  2078. </RelOp>
  2079. <RelOp AvgRowSize="139" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="7779" EstimateRewinds="0.000166966" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="19" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="1.23314" TableCardinality="847888">
  2080. <OutputList>
  2081. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="INSTR_ID" />
  2082. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_NME" />
  2083. </OutputList>
  2084. <RunTimeInformation>
  2085. <RunTimeCountersPerThread Thread="0" ActualRows="7780" ActualEndOfScans="0" ActualExecutions="7780" />
  2086. </RunTimeInformation>
  2087. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  2088. <DefinedValues>
  2089. <DefinedValue>
  2090. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="INSTR_ID" />
  2091. </DefinedValue>
  2092. <DefinedValue>
  2093. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_NME" />
  2094. </DefinedValue>
  2095. </DefinedValues>
  2096. <Object Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Index="[ISSUE_DG16]" Alias="[ISSUE_DG]" IndexKind="NonClustered" Storage="RowStore" />
  2097. <SeekPredicates>
  2098. <SeekPredicateNew>
  2099. <SeekKeys>
  2100. <Prefix ScanType="EQ">
  2101. <RangeColumns>
  2102. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="INSTR_ID" />
  2103. </RangeColumns>
  2104. <RangeExpressions>
  2105. <ScalarOperator ScalarString="[NETIKIP].[edw].[Supplemental_Security_Master].[Instr_Id] as [s].[Instr_Id]">
  2106. <Identifier>
  2107. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Instr_Id" />
  2108. </Identifier>
  2109. </ScalarOperator>
  2110. </RangeExpressions>
  2111. </Prefix>
  2112. </SeekKeys>
  2113. </SeekPredicateNew>
  2114. </SeekPredicates>
  2115. </IndexScan>
  2116. </RelOp>
  2117. </NestedLoops>
  2118. </RelOp>
  2119. <RelOp AvgRowSize="182" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="21" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="847888">
  2120. <OutputList>
  2121. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_UT_AMT" />
  2122. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="UNDLY_ISS_ID" />
  2123. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="FLD2_DESC" />
  2124. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISSUE_CLS1_NME" />
  2125. </OutputList>
  2126. <RunTimeInformation>
  2127. <RunTimeCountersPerThread Thread="0" ActualRows="4045" ActualEndOfScans="3735" ActualExecutions="7780" />
  2128. </RunTimeInformation>
  2129. <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  2130. <DefinedValues>
  2131. <DefinedValue>
  2132. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISS_UT_AMT" />
  2133. </DefinedValue>
  2134. <DefinedValue>
  2135. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="UNDLY_ISS_ID" />
  2136. </DefinedValue>
  2137. <DefinedValue>
  2138. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="FLD2_DESC" />
  2139. </DefinedValue>
  2140. <DefinedValue>
  2141. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISSUE_CLS1_NME" />
  2142. </DefinedValue>
  2143. </DefinedValues>
  2144. <Object Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Index="[PK_ISSUE_DG]" Alias="[ISSUE_DG]" TableReferenceId="-1" IndexKind="Clustered" Storage="RowStore" />
  2145. <SeekPredicates>
  2146. <SeekPredicateNew>
  2147. <SeekKeys>
  2148. <Prefix ScanType="EQ">
  2149. <RangeColumns>
  2150. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="INSTR_ID" />
  2151. </RangeColumns>
  2152. <RangeExpressions>
  2153. <ScalarOperator ScalarString="[NETIKIP].[dbo].[ISSUE_DG].[INSTR_ID] as [ISSUE_DG].[INSTR_ID]">
  2154. <Identifier>
  2155. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="INSTR_ID" />
  2156. </Identifier>
  2157. </ScalarOperator>
  2158. </RangeExpressions>
  2159. </Prefix>
  2160. </SeekKeys>
  2161. </SeekPredicateNew>
  2162. </SeekPredicates>
  2163. <Predicate>
  2164. <ScalarOperator ScalarString="[NETIKIP].[dbo].[ISSUE_DG].[ISSUE_CLS1_NME] as [ISSUE_DG].[ISSUE_CLS1_NME]=[@FUTURE]">
  2165. <Compare CompareOp="EQ">
  2166. <ScalarOperator>
  2167. <Identifier>
  2168. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="ISSUE_CLS1_NME" />
  2169. </Identifier>
  2170. </ScalarOperator>
  2171. <ScalarOperator>
  2172. <Identifier>
  2173. <ColumnReference Column="@FUTURE" />
  2174. </Identifier>
  2175. </ScalarOperator>
  2176. </Compare>
  2177. </ScalarOperator>
  2178. </Predicate>
  2179. </IndexScan>
  2180. </RelOp>
  2181. </NestedLoops>
  2182. </RelOp>
  2183. <RelOp AvgRowSize="75" EstimateCPU="0.00042821" EstimateIO="0.00386574" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="24.6554" LogicalOp="Index Seek" NodeId="31" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00429395" TableCardinality="97576100">
  2184. <OutputList>
  2185. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ACCT_ID" />
  2186. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ACTG_TRN_EV_ID" />
  2187. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ACTG_TRN_ID" />
  2188. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="BK_ID" />
  2189. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="INQ_BASIS_NUM" />
  2190. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="INSTR_ID" />
  2191. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ORG_ID" />
  2192. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="RPT_TMS" />
  2193. </OutputList>
  2194. <RunTimeInformation>
  2195. <RunTimeCountersPerThread Thread="0" ActualRows="2217376" ActualEndOfScans="4045" ActualExecutions="4045" />
  2196. </RunTimeInformation>
  2197. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  2198. <DefinedValues>
  2199. <DefinedValue>
  2200. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ACCT_ID" />
  2201. </DefinedValue>
  2202. <DefinedValue>
  2203. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ACTG_TRN_EV_ID" />
  2204. </DefinedValue>
  2205. <DefinedValue>
  2206. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ACTG_TRN_ID" />
  2207. </DefinedValue>
  2208. <DefinedValue>
  2209. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="BK_ID" />
  2210. </DefinedValue>
  2211. <DefinedValue>
  2212. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="INQ_BASIS_NUM" />
  2213. </DefinedValue>
  2214. <DefinedValue>
  2215. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="INSTR_ID" />
  2216. </DefinedValue>
  2217. <DefinedValue>
  2218. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ORG_ID" />
  2219. </DefinedValue>
  2220. <DefinedValue>
  2221. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="RPT_TMS" />
  2222. </DefinedValue>
  2223. </DefinedValues>
  2224. <Object Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Index="[IDX__TRANEVENT_DG__INSTR_ID_ACCT_ID]" Alias="[TRANEVENT_DG]" IndexKind="NonClustered" Storage="RowStore" />
  2225. <SeekPredicates>
  2226. <SeekPredicateNew>
  2227. <SeekKeys>
  2228. <Prefix ScanType="EQ">
  2229. <RangeColumns>
  2230. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="INSTR_ID" />
  2231. </RangeColumns>
  2232. <RangeExpressions>
  2233. <ScalarOperator ScalarString="[NETIKIP].[edw].[Supplemental_Security_Master].[Instr_Id] as [s].[Instr_Id]">
  2234. <Identifier>
  2235. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Instr_Id" />
  2236. </Identifier>
  2237. </ScalarOperator>
  2238. </RangeExpressions>
  2239. </Prefix>
  2240. </SeekKeys>
  2241. </SeekPredicateNew>
  2242. </SeekPredicates>
  2243. <Predicate>
  2244. <ScalarOperator ScalarString="[NETIKIP].[dbo].[TRANEVENT_DG].[ORG_ID] as [TRANEVENT_DG].[ORG_ID]='SEI' AND [NETIKIP].[dbo].[TRANEVENT_DG].[INQ_BASIS_NUM] as [TRANEVENT_DG].[INQ_BASIS_NUM]=CASE WHEN [NETIKIP].[dbo].[TRANEVENT_DG].[BK_ID] as [TRANEVENT_DG].[BK_ID]=[@BK_ID] THEN (1) ELSE (5) END">
  2245. <Logical Operation="AND">
  2246. <ScalarOperator>
  2247. <Compare CompareOp="EQ">
  2248. <ScalarOperator>
  2249. <Identifier>
  2250. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ORG_ID" />
  2251. </Identifier>
  2252. </ScalarOperator>
  2253. <ScalarOperator>
  2254. <Const ConstValue="'SEI'" />
  2255. </ScalarOperator>
  2256. </Compare>
  2257. </ScalarOperator>
  2258. <ScalarOperator>
  2259. <Compare CompareOp="EQ">
  2260. <ScalarOperator>
  2261. <Identifier>
  2262. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="INQ_BASIS_NUM" />
  2263. </Identifier>
  2264. </ScalarOperator>
  2265. <ScalarOperator>
  2266. <IF>
  2267. <Condition>
  2268. <ScalarOperator>
  2269. <Compare CompareOp="EQ">
  2270. <ScalarOperator>
  2271. <Identifier>
  2272. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="BK_ID" />
  2273. </Identifier>
  2274. </ScalarOperator>
  2275. <ScalarOperator>
  2276. <Identifier>
  2277. <ColumnReference Column="@BK_ID" />
  2278. </Identifier>
  2279. </ScalarOperator>
  2280. </Compare>
  2281. </ScalarOperator>
  2282. </Condition>
  2283. <Then>
  2284. <ScalarOperator>
  2285. <Const ConstValue="(1)" />
  2286. </ScalarOperator>
  2287. </Then>
  2288. <Else>
  2289. <ScalarOperator>
  2290. <Const ConstValue="(5)" />
  2291. </ScalarOperator>
  2292. </Else>
  2293. </IF>
  2294. </ScalarOperator>
  2295. </Compare>
  2296. </ScalarOperator>
  2297. </Logical>
  2298. </ScalarOperator>
  2299. </Predicate>
  2300. </IndexScan>
  2301. </RelOp>
  2302. </NestedLoops>
  2303. </RelOp>
  2304. <RelOp AvgRowSize="79" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="23.6554" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="33" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00702302" TableCardinality="97576100">
  2305. <OutputList>
  2306. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="FX_ALT_CMB_RTE" />
  2307. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="QUANTITY" />
  2308. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="UT_PRC_CMB_AMT" />
  2309. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="UT_PRC_ALT_CMB_AMT" />
  2310. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="Sys_Curr_Gross_Amt" />
  2311. </OutputList>
  2312. <RunTimeInformation>
  2313. <RunTimeCountersPerThread Thread="0" ActualRows="161440" ActualEndOfScans="2055936" ActualExecutions="2217376" />
  2314. </RunTimeInformation>
  2315. <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  2316. <DefinedValues>
  2317. <DefinedValue>
  2318. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="FX_ALT_CMB_RTE" />
  2319. </DefinedValue>
  2320. <DefinedValue>
  2321. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="QUANTITY" />
  2322. </DefinedValue>
  2323. <DefinedValue>
  2324. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="UT_PRC_CMB_AMT" />
  2325. </DefinedValue>
  2326. <DefinedValue>
  2327. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="UT_PRC_ALT_CMB_AMT" />
  2328. </DefinedValue>
  2329. <DefinedValue>
  2330. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="Sys_Curr_Gross_Amt" />
  2331. </DefinedValue>
  2332. </DefinedValues>
  2333. <Object Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Index="[TEDG_AcctBkOrgTrnEvIdIbnRptms_pcu]" Alias="[TRANEVENT_DG]" TableReferenceId="-1" IndexKind="Clustered" Storage="RowStore" />
  2334. <SeekPredicates>
  2335. <SeekPredicateNew>
  2336. <SeekKeys>
  2337. <Prefix ScanType="EQ">
  2338. <RangeColumns>
  2339. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ACCT_ID" />
  2340. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="BK_ID" />
  2341. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ORG_ID" />
  2342. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ACTG_TRN_EV_ID" />
  2343. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ACTG_TRN_ID" />
  2344. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="INQ_BASIS_NUM" />
  2345. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="RPT_TMS" />
  2346. </RangeColumns>
  2347. <RangeExpressions>
  2348. <ScalarOperator ScalarString="[NETIKIP].[dbo].[TRANEVENT_DG].[ACCT_ID] as [TRANEVENT_DG].[ACCT_ID]">
  2349. <Identifier>
  2350. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ACCT_ID" />
  2351. </Identifier>
  2352. </ScalarOperator>
  2353. <ScalarOperator ScalarString="[NETIKIP].[dbo].[TRANEVENT_DG].[BK_ID] as [TRANEVENT_DG].[BK_ID]">
  2354. <Identifier>
  2355. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="BK_ID" />
  2356. </Identifier>
  2357. </ScalarOperator>
  2358. <ScalarOperator ScalarString="[NETIKIP].[dbo].[TRANEVENT_DG].[ORG_ID] as [TRANEVENT_DG].[ORG_ID]">
  2359. <Identifier>
  2360. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ORG_ID" />
  2361. </Identifier>
  2362. </ScalarOperator>
  2363. <ScalarOperator ScalarString="[NETIKIP].[dbo].[TRANEVENT_DG].[ACTG_TRN_EV_ID] as [TRANEVENT_DG].[ACTG_TRN_EV_ID]">
  2364. <Identifier>
  2365. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ACTG_TRN_EV_ID" />
  2366. </Identifier>
  2367. </ScalarOperator>
  2368. <ScalarOperator ScalarString="[NETIKIP].[dbo].[TRANEVENT_DG].[ACTG_TRN_ID] as [TRANEVENT_DG].[ACTG_TRN_ID]">
  2369. <Identifier>
  2370. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ACTG_TRN_ID" />
  2371. </Identifier>
  2372. </ScalarOperator>
  2373. <ScalarOperator ScalarString="[NETIKIP].[dbo].[TRANEVENT_DG].[INQ_BASIS_NUM] as [TRANEVENT_DG].[INQ_BASIS_NUM]">
  2374. <Identifier>
  2375. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="INQ_BASIS_NUM" />
  2376. </Identifier>
  2377. </ScalarOperator>
  2378. <ScalarOperator ScalarString="[NETIKIP].[dbo].[TRANEVENT_DG].[RPT_TMS] as [TRANEVENT_DG].[RPT_TMS]">
  2379. <Identifier>
  2380. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="RPT_TMS" />
  2381. </Identifier>
  2382. </ScalarOperator>
  2383. </RangeExpressions>
  2384. </Prefix>
  2385. </SeekKeys>
  2386. </SeekPredicateNew>
  2387. </SeekPredicates>
  2388. <Predicate>
  2389. <ScalarOperator ScalarString="[NETIKIP].[dbo].[TRANEVENT_DG].[TRD_EX_EFF_TMS] as [TRANEVENT_DG].[TRD_EX_EFF_TMS]&gt;=[@Month_FromDate] AND [NETIKIP].[dbo].[TRANEVENT_DG].[TRD_EX_EFF_TMS] as [TRANEVENT_DG].[TRD_EX_EFF_TMS]&lt;=[@Month_ToDate] AND ([NETIKIP].[dbo].[TRANEVENT_DG].[TRN_DESC] as [TRANEVENT_DG].[TRN_DESC]=[@SellShort] OR [NETIKIP].[dbo].[TRANEVENT_DG].[TRN_DESC] as [TRANEVENT_DG].[TRN_DESC]=[@Sell] OR [NETIKIP].[dbo].[TRANEVENT_DG].[TRN_DESC] as [TRANEVENT_DG].[TRN_DESC]=[@CoverShort] OR [NETIKIP].[dbo].[TRANEVENT_DG].[TRN_DESC] as [TRANEVENT_DG].[TRN_DESC]=[@Buy])">
  2390. <Logical Operation="AND">
  2391. <ScalarOperator>
  2392. <Compare CompareOp="GE">
  2393. <ScalarOperator>
  2394. <Identifier>
  2395. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="TRD_EX_EFF_TMS" />
  2396. </Identifier>
  2397. </ScalarOperator>
  2398. <ScalarOperator>
  2399. <Identifier>
  2400. <ColumnReference Column="@Month_FromDate" />
  2401. </Identifier>
  2402. </ScalarOperator>
  2403. </Compare>
  2404. </ScalarOperator>
  2405. <ScalarOperator>
  2406. <Compare CompareOp="LE">
  2407. <ScalarOperator>
  2408. <Identifier>
  2409. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="TRD_EX_EFF_TMS" />
  2410. </Identifier>
  2411. </ScalarOperator>
  2412. <ScalarOperator>
  2413. <Identifier>
  2414. <ColumnReference Column="@Month_ToDate" />
  2415. </Identifier>
  2416. </ScalarOperator>
  2417. </Compare>
  2418. </ScalarOperator>
  2419. <ScalarOperator>
  2420. <Logical Operation="OR">
  2421. <ScalarOperator>
  2422. <Compare CompareOp="EQ">
  2423. <ScalarOperator>
  2424. <Identifier>
  2425. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="TRN_DESC" />
  2426. </Identifier>
  2427. </ScalarOperator>
  2428. <ScalarOperator>
  2429. <Identifier>
  2430. <ColumnReference Column="@SellShort" />
  2431. </Identifier>
  2432. </ScalarOperator>
  2433. </Compare>
  2434. </ScalarOperator>
  2435. <ScalarOperator>
  2436. <Compare CompareOp="EQ">
  2437. <ScalarOperator>
  2438. <Identifier>
  2439. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="TRN_DESC" />
  2440. </Identifier>
  2441. </ScalarOperator>
  2442. <ScalarOperator>
  2443. <Identifier>
  2444. <ColumnReference Column="@Sell" />
  2445. </Identifier>
  2446. </ScalarOperator>
  2447. </Compare>
  2448. </ScalarOperator>
  2449. <ScalarOperator>
  2450. <Compare CompareOp="EQ">
  2451. <ScalarOperator>
  2452. <Identifier>
  2453. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="TRN_DESC" />
  2454. </Identifier>
  2455. </ScalarOperator>
  2456. <ScalarOperator>
  2457. <Identifier>
  2458. <ColumnReference Column="@CoverShort" />
  2459. </Identifier>
  2460. </ScalarOperator>
  2461. </Compare>
  2462. </ScalarOperator>
  2463. <ScalarOperator>
  2464. <Compare CompareOp="EQ">
  2465. <ScalarOperator>
  2466. <Identifier>
  2467. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="TRN_DESC" />
  2468. </Identifier>
  2469. </ScalarOperator>
  2470. <ScalarOperator>
  2471. <Identifier>
  2472. <ColumnReference Column="@Buy" />
  2473. </Identifier>
  2474. </ScalarOperator>
  2475. </Compare>
  2476. </ScalarOperator>
  2477. </Logical>
  2478. </ScalarOperator>
  2479. </Logical>
  2480. </ScalarOperator>
  2481. </Predicate>
  2482. </IndexScan>
  2483. </RelOp>
  2484. </NestedLoops>
  2485. </RelOp>
  2486. <RelOp AvgRowSize="9" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="45" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="777">
  2487. <OutputList />
  2488. <RunTimeInformation>
  2489. <RunTimeCountersPerThread Thread="0" ActualRows="161440" ActualEndOfScans="0" ActualExecutions="161440" />
  2490. </RunTimeInformation>
  2491. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  2492. <DefinedValues />
  2493. <Object Database="[NETIKIP]" Schema="[edw]" Table="[Exchange_Code]" Index="[UQ__Exchange_Code]" Alias="[UE]" IndexKind="NonClustered" Storage="RowStore" />
  2494. <SeekPredicates>
  2495. <SeekPredicateNew>
  2496. <SeekKeys>
  2497. <Prefix ScanType="EQ">
  2498. <RangeColumns>
  2499. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Exchange_Code]" Alias="[UE]" Column="Exchange_Code_Id" />
  2500. </RangeColumns>
  2501. <RangeExpressions>
  2502. <ScalarOperator ScalarString="[NETIKIP].[edw].[Supplemental_Security_Master].[Underlying_Exchange_Code_Id] as [s].[Underlying_Exchange_Code_Id]">
  2503. <Identifier>
  2504. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Underlying_Exchange_Code_Id" />
  2505. </Identifier>
  2506. </ScalarOperator>
  2507. </RangeExpressions>
  2508. </Prefix>
  2509. </SeekKeys>
  2510. </SeekPredicateNew>
  2511. </SeekPredicates>
  2512. </IndexScan>
  2513. </RelOp>
  2514. </NestedLoops>
  2515. </RelOp>
  2516. <RelOp AvgRowSize="9" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="46" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="777">
  2517. <OutputList />
  2518. <RunTimeInformation>
  2519. <RunTimeCountersPerThread Thread="0" ActualRows="161440" ActualEndOfScans="0" ActualExecutions="161440" />
  2520. </RunTimeInformation>
  2521. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  2522. <DefinedValues />
  2523. <Object Database="[NETIKIP]" Schema="[edw]" Table="[Exchange_Code]" Index="[UQ__Exchange_Code]" Alias="[E]" IndexKind="NonClustered" Storage="RowStore" />
  2524. <SeekPredicates>
  2525. <SeekPredicateNew>
  2526. <SeekKeys>
  2527. <Prefix ScanType="EQ">
  2528. <RangeColumns>
  2529. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Exchange_Code]" Alias="[E]" Column="Exchange_Code_Id" />
  2530. </RangeColumns>
  2531. <RangeExpressions>
  2532. <ScalarOperator ScalarString="[NETIKIP].[edw].[Supplemental_Security_Master].[Exchange_Code_Id] as [s].[Exchange_Code_Id]">
  2533. <Identifier>
  2534. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Exchange_Code_Id" />
  2535. </Identifier>
  2536. </ScalarOperator>
  2537. </RangeExpressions>
  2538. </Prefix>
  2539. </SeekKeys>
  2540. </SeekPredicateNew>
  2541. </SeekPredicates>
  2542. </IndexScan>
  2543. </RelOp>
  2544. </NestedLoops>
  2545. </RelOp>
  2546. <RelOp AvgRowSize="9" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="47" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="51">
  2547. <OutputList />
  2548. <RunTimeInformation>
  2549. <RunTimeCountersPerThread Thread="0" ActualRows="161440" ActualEndOfScans="0" ActualExecutions="161440" />
  2550. </RunTimeInformation>
  2551. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  2552. <DefinedValues />
  2553. <Object Database="[NETIKIP]" Schema="[edw]" Table="[Deal_Type]" Index="[UQ__Deal_Type]" Alias="[D]" IndexKind="NonClustered" Storage="RowStore" />
  2554. <SeekPredicates>
  2555. <SeekPredicateNew>
  2556. <SeekKeys>
  2557. <Prefix ScanType="EQ">
  2558. <RangeColumns>
  2559. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Deal_Type]" Alias="[D]" Column="Deal_Type_Id" />
  2560. </RangeColumns>
  2561. <RangeExpressions>
  2562. <ScalarOperator ScalarString="[NETIKIP].[edw].[Supplemental_Security_Master].[Deal_Type_Id] as [s].[Deal_Type_Id]">
  2563. <Identifier>
  2564. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Deal_Type_Id" />
  2565. </Identifier>
  2566. </ScalarOperator>
  2567. </RangeExpressions>
  2568. </Prefix>
  2569. </SeekKeys>
  2570. </SeekPredicateNew>
  2571. </SeekPredicates>
  2572. </IndexScan>
  2573. </RelOp>
  2574. </NestedLoops>
  2575. </RelOp>
  2576. <RelOp AvgRowSize="9" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="48" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="43">
  2577. <OutputList />
  2578. <RunTimeInformation>
  2579. <RunTimeCountersPerThread Thread="0" ActualRows="161440" ActualEndOfScans="0" ActualExecutions="161440" />
  2580. </RunTimeInformation>
  2581. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  2582. <DefinedValues />
  2583. <Object Database="[NETIKIP]" Schema="[edw]" Table="[Regular_Reporting_Category]" Index="[UQ__Regular_Reporting_Category]" Alias="[R]" IndexKind="NonClustered" Storage="RowStore" />
  2584. <SeekPredicates>
  2585. <SeekPredicateNew>
  2586. <SeekKeys>
  2587. <Prefix ScanType="EQ">
  2588. <RangeColumns>
  2589. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Regular_Reporting_Category]" Alias="[R]" Column="Regular_Reporting_Category_Id" />
  2590. </RangeColumns>
  2591. <RangeExpressions>
  2592. <ScalarOperator ScalarString="[NETIKIP].[edw].[Supplemental_Security_Master].[Regular_Reporting_Category_Id] as [s].[Regular_Reporting_Category_Id]">
  2593. <Identifier>
  2594. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Regular_Reporting_Category_Id" />
  2595. </Identifier>
  2596. </ScalarOperator>
  2597. </RangeExpressions>
  2598. </Prefix>
  2599. </SeekKeys>
  2600. </SeekPredicateNew>
  2601. </SeekPredicates>
  2602. </IndexScan>
  2603. </RelOp>
  2604. </NestedLoops>
  2605. </RelOp>
  2606. <RelOp AvgRowSize="9" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="49" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="31">
  2607. <OutputList />
  2608. <RunTimeInformation>
  2609. <RunTimeCountersPerThread Thread="0" ActualRows="12108" ActualEndOfScans="149332" ActualExecutions="161440" />
  2610. </RunTimeInformation>
  2611. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  2612. <DefinedValues />
  2613. <Object Table="[@ACCOUNTS]" Index="[PK__#ABE9295__31D13AAB96936029]" Alias="[A]" Storage="RowStore" />
  2614. <SeekPredicates>
  2615. <SeekPredicateNew>
  2616. <SeekKeys>
  2617. <Prefix ScanType="EQ">
  2618. <RangeColumns>
  2619. <ColumnReference Table="@ACCOUNTS" Alias="[A]" Column="PORTFOLIO" />
  2620. </RangeColumns>
  2621. <RangeExpressions>
  2622. <ScalarOperator ScalarString="[NETIKIP].[dbo].[TRANEVENT_DG].[ACCT_ID] as [TRANEVENT_DG].[ACCT_ID]">
  2623. <Identifier>
  2624. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="ACCT_ID" />
  2625. </Identifier>
  2626. </ScalarOperator>
  2627. </RangeExpressions>
  2628. </Prefix>
  2629. </SeekKeys>
  2630. </SeekPredicateNew>
  2631. </SeekPredicates>
  2632. </IndexScan>
  2633. </RelOp>
  2634. </NestedLoops>
  2635. </RelOp>
  2636. <RelOp AvgRowSize="9" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="50" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="17">
  2637. <OutputList />
  2638. <RunTimeInformation>
  2639. <RunTimeCountersPerThread Thread="0" ActualRows="12108" ActualEndOfScans="0" ActualExecutions="12108" />
  2640. </RunTimeInformation>
  2641. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  2642. <DefinedValues />
  2643. <Object Database="[NETIKIP]" Schema="[edw]" Table="[Regular_Reporting_Group]" Index="[UQ__Regular_Reporting_Group]" Alias="[RG]" IndexKind="NonClustered" Storage="RowStore" />
  2644. <SeekPredicates>
  2645. <SeekPredicateNew>
  2646. <SeekKeys>
  2647. <Prefix ScanType="EQ">
  2648. <RangeColumns>
  2649. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Regular_Reporting_Group]" Alias="[RG]" Column="Regular_Reporting_Group_Id" />
  2650. </RangeColumns>
  2651. <RangeExpressions>
  2652. <ScalarOperator ScalarString="[NETIKIP].[edw].[Supplemental_Security_Master].[Regular_Reporting_Group_Id] as [s].[Regular_Reporting_Group_Id]">
  2653. <Identifier>
  2654. <ColumnReference Database="[NETIKIP]" Schema="[edw]" Table="[Supplemental_Security_Master]" Alias="[s]" Column="Regular_Reporting_Group_Id" />
  2655. </Identifier>
  2656. </ScalarOperator>
  2657. </RangeExpressions>
  2658. </Prefix>
  2659. </SeekKeys>
  2660. </SeekPredicateNew>
  2661. </SeekPredicates>
  2662. </IndexScan>
  2663. </RelOp>
  2664. </NestedLoops>
  2665. </RelOp>
  2666. <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="51" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="35610">
  2667. <OutputList>
  2668. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[reg_position]" Alias="[REGPOS]" Column="delta" />
  2669. </OutputList>
  2670. <RunTimeInformation>
  2671. <RunTimeCountersPerThread Thread="0" ActualRows="22" ActualEndOfScans="12108" ActualExecutions="12108" />
  2672. </RunTimeInformation>
  2673. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  2674. <DefinedValues>
  2675. <DefinedValue>
  2676. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[reg_position]" Alias="[REGPOS]" Column="delta" />
  2677. </DefinedValue>
  2678. </DefinedValues>
  2679. <Object Database="[NETIKIP]" Schema="[dbo]" Table="[reg_position]" Index="[reg_position_IDX2]" Alias="[REGPOS]" IndexKind="NonClustered" Storage="RowStore" />
  2680. <SeekPredicates>
  2681. <SeekPredicateNew>
  2682. <SeekKeys>
  2683. <Prefix ScanType="EQ">
  2684. <RangeColumns>
  2685. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[reg_position]" Alias="[REGPOS]" Column="as_of_tms" />
  2686. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[reg_position]" Alias="[REGPOS]" Column="instr_id" />
  2687. </RangeColumns>
  2688. <RangeExpressions>
  2689. <ScalarOperator ScalarString="CASE WHEN [@Month]=(1) THEN [@Month1_ToDate] ELSE CASE WHEN [@Month]=(2) THEN [@Month2_ToDate] ELSE [@Month3_ToDate] END END">
  2690. <Identifier>
  2691. <ColumnReference Column="ConstExpr1025">
  2692. <ScalarOperator>
  2693. <IF>
  2694. <Condition>
  2695. <ScalarOperator>
  2696. <Compare CompareOp="EQ">
  2697. <ScalarOperator>
  2698. <Identifier>
  2699. <ColumnReference Column="@Month" />
  2700. </Identifier>
  2701. </ScalarOperator>
  2702. <ScalarOperator>
  2703. <Const ConstValue="(1)" />
  2704. </ScalarOperator>
  2705. </Compare>
  2706. </ScalarOperator>
  2707. </Condition>
  2708. <Then>
  2709. <ScalarOperator>
  2710. <Identifier>
  2711. <ColumnReference Column="@Month1_ToDate" />
  2712. </Identifier>
  2713. </ScalarOperator>
  2714. </Then>
  2715. <Else>
  2716. <ScalarOperator>
  2717. <IF>
  2718. <Condition>
  2719. <ScalarOperator>
  2720. <Compare CompareOp="EQ">
  2721. <ScalarOperator>
  2722. <Identifier>
  2723. <ColumnReference Column="@Month" />
  2724. </Identifier>
  2725. </ScalarOperator>
  2726. <ScalarOperator>
  2727. <Const ConstValue="(2)" />
  2728. </ScalarOperator>
  2729. </Compare>
  2730. </ScalarOperator>
  2731. </Condition>
  2732. <Then>
  2733. <ScalarOperator>
  2734. <Identifier>
  2735. <ColumnReference Column="@Month2_ToDate" />
  2736. </Identifier>
  2737. </ScalarOperator>
  2738. </Then>
  2739. <Else>
  2740. <ScalarOperator>
  2741. <Identifier>
  2742. <ColumnReference Column="@Month3_ToDate" />
  2743. </Identifier>
  2744. </ScalarOperator>
  2745. </Else>
  2746. </IF>
  2747. </ScalarOperator>
  2748. </Else>
  2749. </IF>
  2750. </ScalarOperator>
  2751. </ColumnReference>
  2752. </Identifier>
  2753. </ScalarOperator>
  2754. <ScalarOperator ScalarString="[NETIKIP].[dbo].[TRANEVENT_DG].[INSTR_ID] as [TRANEVENT_DG].[INSTR_ID]">
  2755. <Identifier>
  2756. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[TRANEVENT_DG]" Alias="[TRANEVENT_DG]" Column="INSTR_ID" />
  2757. </Identifier>
  2758. </ScalarOperator>
  2759. </RangeExpressions>
  2760. </Prefix>
  2761. </SeekKeys>
  2762. </SeekPredicateNew>
  2763. </SeekPredicates>
  2764. </IndexScan>
  2765. </RelOp>
  2766. </NestedLoops>
  2767. </RelOp>
  2768. <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0.00332582" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="52" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00328363" TableCardinality="937058">
  2769. <OutputList>
  2770. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_PRICE]" Alias="[ISSUE_PRICE]" Column="PRC_QUOTE_AMT" />
  2771. </OutputList>
  2772. <RunTimeInformation>
  2773. <RunTimeCountersPerThread Thread="0" ActualRows="1777" ActualEndOfScans="10342" ActualExecutions="12119" />
  2774. </RunTimeInformation>
  2775. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  2776. <DefinedValues>
  2777. <DefinedValue>
  2778. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_PRICE]" Alias="[ISSUE_PRICE]" Column="PRC_QUOTE_AMT" />
  2779. </DefinedValue>
  2780. </DefinedValues>
  2781. <Object Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_PRICE]" Index="[UQ_IDX__ISSUE_PRICE_INSTR_ID_PRC_TMS]" Alias="[ISSUE_PRICE]" IndexKind="Clustered" Storage="RowStore" />
  2782. <SeekPredicates>
  2783. <SeekPredicateNew>
  2784. <SeekKeys>
  2785. <Prefix ScanType="EQ">
  2786. <RangeColumns>
  2787. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_PRICE]" Alias="[ISSUE_PRICE]" Column="INSTR_ID" />
  2788. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_PRICE]" Alias="[ISSUE_PRICE]" Column="PRC_TMS" />
  2789. </RangeColumns>
  2790. <RangeExpressions>
  2791. <ScalarOperator ScalarString="[NETIKIP].[dbo].[ISSUE_DG].[UNDLY_ISS_ID] as [ISSUE_DG].[UNDLY_ISS_ID]">
  2792. <Identifier>
  2793. <ColumnReference Database="[NETIKIP]" Schema="[dbo]" Table="[ISSUE_DG]" Alias="[ISSUE_DG]" Column="UNDLY_ISS_ID" />
  2794. </Identifier>
  2795. </ScalarOperator>
  2796. <ScalarOperator ScalarString="CASE WHEN [@Month]=(1) THEN [@Month1_ToDate] ELSE CASE WHEN [@Month]=(2) THEN [@Month2_ToDate] ELSE [@Month3_ToDate] END END">
  2797. <Identifier>
  2798. <ColumnReference Column="ConstExpr1026">
  2799. <ScalarOperator>
  2800. <IF>
  2801. <Condition>
  2802. <ScalarOperator>
  2803. <Compare CompareOp="EQ">
  2804. <ScalarOperator>
  2805. <Identifier>
  2806. <ColumnReference Column="@Month" />
  2807. </Identifier>
  2808. </ScalarOperator>
  2809. <ScalarOperator>
  2810. <Const ConstValue="(1)" />
  2811. </ScalarOperator>
  2812. </Compare>
  2813. </ScalarOperator>
  2814. </Condition>
  2815. <Then>
  2816. <ScalarOperator>
  2817. <Identifier>
  2818. <ColumnReference Column="@Month1_ToDate" />
  2819. </Identifier>
  2820. </ScalarOperator>
  2821. </Then>
  2822. <Else>
  2823. <ScalarOperator>
  2824. <IF>
  2825. <Condition>
  2826. <ScalarOperator>
  2827. <Compare CompareOp="EQ">
  2828. <ScalarOperator>
  2829. <Identifier>
  2830. <ColumnReference Column="@Month" />
  2831. </Identifier>
  2832. </ScalarOperator>
  2833. <ScalarOperator>
  2834. <Const ConstValue="(2)" />
  2835. </ScalarOperator>
  2836. </Compare>
  2837. </ScalarOperator>
  2838. </Condition>
  2839. <Then>
  2840. <ScalarOperator>
  2841. <Identifier>
  2842. <ColumnReference Column="@Month2_ToDate" />
  2843. </Identifier>
  2844. </ScalarOperator>
  2845. </Then>
  2846. <Else>
  2847. <ScalarOperator>
  2848. <Identifier>
  2849. <ColumnReference Column="@Month3_ToDate" />
  2850. </Identifier>
  2851. </ScalarOperator>
  2852. </Else>
  2853. </IF>
  2854. </ScalarOperator>
  2855. </Else>
  2856. </IF>
  2857. </ScalarOperator>
  2858. </ColumnReference>
  2859. </Identifier>
  2860. </ScalarOperator>
  2861. </RangeExpressions>
  2862. </Prefix>
  2863. </SeekKeys>
  2864. </SeekPredicateNew>
  2865. </SeekPredicates>
  2866. </IndexScan>
  2867. </RelOp>
  2868. </NestedLoops>
  2869. </RelOp>
  2870. </ComputeScalar>
  2871. </RelOp>
  2872. </ComputeScalar>
  2873. </RelOp>
  2874. </Update>
  2875. </RelOp>
  2876. <ParameterList>
  2877. <ColumnReference Column="@BK_ID" ParameterRuntimeValue="'MF'" />
  2878. <ColumnReference Column="@Buy" ParameterRuntimeValue="'Buy'" />
  2879. <ColumnReference Column="@CoverShort" ParameterRuntimeValue="'Cover Short'" />
  2880. <ColumnReference Column="@Sell" ParameterRuntimeValue="'Sell'" />
  2881. <ColumnReference Column="@SellShort" ParameterRuntimeValue="'Sell Short'" />
  2882. <ColumnReference Column="@FUTURE" ParameterRuntimeValue="'FUTURE'" />
  2883. <ColumnReference Column="@Month_ToDate" ParameterRuntimeValue="'2016-01-31 23:59:59.997'" />
  2884. <ColumnReference Column="@Month_FromDate" ParameterRuntimeValue="'2016-01-01 00:00:00.000'" />
  2885. <ColumnReference Column="@Month3_ToDate" ParameterRuntimeValue="'2016-03-31 23:59:59.000'" />
  2886. <ColumnReference Column="@Month2_ToDate" ParameterRuntimeValue="'2016-02-29 23:59:59.000'" />
  2887. <ColumnReference Column="@Month1_ToDate" ParameterRuntimeValue="'2016-01-31 23:59:59.000'" />
  2888. <ColumnReference Column="@Month" ParameterRuntimeValue="(1)" />
  2889. </ParameterList>
  2890. </QueryPlan>
  2891. </StmtSimple>
  2892. </Statements>
  2893. </Batch>
  2894. <Batch>
  2895. <Statements>
  2896. <StmtSimple StatementCompId="35" StatementEstRows="12119" StatementId="6" StatementOptmLevel="TRIVIAL" CardinalityEstimationModelVersion="120" StatementSubTreeCost="0.129946" StatementText="SELECT PRCD_ALT_CMB_AMT,&#xD;&#xA; AGNT2_NME,&#xD;&#xA; ISS_FLD2_DESC,&#xD;&#xA; ISS_NME, &#xD;&#xA; Quantity,&#xD;&#xA; UT_PRC_ALT_CMB_AMT,&#xD;&#xA; FX_ALT_CMB_RTE,&#xD;&#xA; Point_Value_Amt,&#xD;&#xA; PRC_QUOTE_AMT,&#xD;&#xA; Delta,&#xD;&#xA; SYS_CURR_GROSS_AMT &#xD;&#xA; FROM #Temp1" StatementType="SELECT" QueryHash="0x608D4E8C1E188BBC" QueryPlanHash="0x460F553319217D68" RetrievedFromCache="false">
  2897. <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
  2898. <QueryPlan DegreeOfParallelism="1" CachedPlanSize="16" CompileTime="0" CompileCPU="0" CompileMemory="96">
  2899. <MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" />
  2900. <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="3145728" EstimatedPagesCached="3145728" EstimatedAvailableDegreeOfParallelism="8" />
  2901. <RelOp AvgRowSize="947" EstimateCPU="0.0134879" EstimateIO="0.116458" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="12119" LogicalOp="Clustered Index Scan" NodeId="0" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.129946" TableCardinality="12119">
  2902. <OutputList>
  2903. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="PRCD_ALT_CMB_AMT" />
  2904. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="AGNT2_NME" />
  2905. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="ISS_FLD2_DESC" />
  2906. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="ISS_NME" />
  2907. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="Quantity" />
  2908. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="UT_PRC_ALT_CMB_AMT" />
  2909. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="FX_ALT_CMB_RTE" />
  2910. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="Point_Value_Amt" />
  2911. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="PRC_QUOTE_AMT" />
  2912. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="Delta" />
  2913. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="SYS_CURR_GROSS_AMT" />
  2914. </OutputList>
  2915. <RunTimeInformation>
  2916. <RunTimeCountersPerThread Thread="0" ActualRows="12119" ActualEndOfScans="1" ActualExecutions="1" />
  2917. </RunTimeInformation>
  2918. <IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  2919. <DefinedValues>
  2920. <DefinedValue>
  2921. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="PRCD_ALT_CMB_AMT" />
  2922. </DefinedValue>
  2923. <DefinedValue>
  2924. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="AGNT2_NME" />
  2925. </DefinedValue>
  2926. <DefinedValue>
  2927. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="ISS_FLD2_DESC" />
  2928. </DefinedValue>
  2929. <DefinedValue>
  2930. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="ISS_NME" />
  2931. </DefinedValue>
  2932. <DefinedValue>
  2933. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="Quantity" />
  2934. </DefinedValue>
  2935. <DefinedValue>
  2936. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="UT_PRC_ALT_CMB_AMT" />
  2937. </DefinedValue>
  2938. <DefinedValue>
  2939. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="FX_ALT_CMB_RTE" />
  2940. </DefinedValue>
  2941. <DefinedValue>
  2942. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="Point_Value_Amt" />
  2943. </DefinedValue>
  2944. <DefinedValue>
  2945. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="PRC_QUOTE_AMT" />
  2946. </DefinedValue>
  2947. <DefinedValue>
  2948. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="Delta" />
  2949. </DefinedValue>
  2950. <DefinedValue>
  2951. <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Column="SYS_CURR_GROSS_AMT" />
  2952. </DefinedValue>
  2953. </DefinedValues>
  2954. <Object Database="[tempdb]" Schema="[dbo]" Table="[#Temp1]" Index="[PK__#Temp1____7D64573CCE1002E7]" IndexKind="Clustered" Storage="RowStore" />
  2955. </IndexScan>
  2956. </RelOp>
  2957. </QueryPlan>
  2958. </StmtSimple>
  2959. </Statements>
  2960. </Batch>
  2961. </BatchSequence>
  2962. </ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!