API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 13th, 2019
200
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 140.28 KB | None | 0 0
raw download clone embed print report
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.481" Build="14.0.3026.27" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
  3. <BatchSequence>
  4. <Batch>
  5. <Statements>
  6. <StmtSimple StatementCompId="1" StatementEstRows="1" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" StatementSubTreeCost="0.065496" StatementText="select institutions . inst_id , institutions . inst_nr , inst_name , translations1 . trans_to as trans_to , translations2 . trans_to as trans_to2 , translations3 . trans_to as trans_to3 , translations4 . trans_to as trans_to4 from institutions left join translations translations1 on institutions . inst_nr = translations1 . trans_from and translations1 . lang_locale = @0 and translations1 . org_id = @1 left join translations translations2 on institutions . inst_nr = translations2 . trans_from and translations2 . lang_locale = @2 and translations2 . org_id = @3 left join translations translations3 on institutions . inst_name = translations3 . trans_from and translations3 . lang_locale = @4 and translations3 . org_id = @5 left join translations translations4 on institutions . inst_name = translations4 . trans_from and translations4 . lang_locale = @6 and translations4 . org_id = @7 where ( ( institutions . org_id = @8 and institutions . app_id = @9 ) or ( institutions . org_id = @10 and institutions . app_id = @11 ) ) and lcd_id = @12 and exists ( select inst_id_partner from agreements where agreements . inst_id_partner = institutions . inst_id and org_id = @13 and agree_id in ( select agree_id from agreements where org_id = @14 and kz_bew_pers in ( @15 , @16 ) and kz_bew_art in ( @17 , @18 ) and aust_prog_id not in ( select aust_prog_id from aust_programme where org_id = @19 and is_not_part_of_all_prog = @20 ) and agree_id in ( select agree_id from zu_studj_agree where studj_id = @21 and sem_id = @22 ) and ( agree_id not in ( select agree_id from agree_stat where org_id = @23 ) or agree_id in ( select agree_id from agree_stat where org_id = @24 and agree_stat . studj_id = @25 and agree_stat . sem_id = @26 and agree_stat . anz_zut_out &lt; agreements . anz_gesamt ) ) and inst_id in ( @27 ) ) ) order by translations1 . trans_to , institutions . inst_nr" StatementType="SELECT" QueryHash="0x4BA55BC3854FA498" QueryPlanHash="0x12249F799C73A769">
  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="1024" CachedPlanSize="184" CompileTime="51" CompileCPU="51" CompileMemory="4160">
  9. <RelOp AvgRowSize="304" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Inner Join" NodeId="0" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.065496">
  10. <OutputList>
  11. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_id" />
  12. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_nr" />
  13. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_name" />
  14. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations1]" Column="trans_to" />
  15. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations2]" Column="trans_to" />
  16. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations3]" Column="trans_to" />
  17. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations4]" Column="trans_to" />
  18. </OutputList>
  19. <RunTimeInformation>
  20. <RunTimeCountersPerThread Thread="0" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
  21. </RunTimeInformation>
  22. <NestedLoops Optimized="false">
  23. <PassThru>
  24. <ScalarOperator ScalarString="[IsBaseRow1005] IS NULL">
  25. <Compare CompareOp="IS">
  26. <ScalarOperator>
  27. <Identifier>
  28. <ColumnReference Column="IsBaseRow1005" />
  29. </Identifier>
  30. </ScalarOperator>
  31. <ScalarOperator>
  32. <Const ConstValue="NULL" />
  33. </ScalarOperator>
  34. </Compare>
  35. </ScalarOperator>
  36. </PassThru>
  37. <OuterReferences>
  38. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations4]" Column="trans_id" />
  39. </OuterReferences>
  40. <RelOp AvgRowSize="259" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Left Outer Join" NodeId="1" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0622084">
  41. <OutputList>
  42. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_id" />
  43. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_nr" />
  44. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_name" />
  45. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations1]" Column="trans_to" />
  46. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations2]" Column="trans_to" />
  47. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations3]" Column="trans_to" />
  48. <ColumnReference Column="IsBaseRow1005" />
  49. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations4]" Column="trans_id" />
  50. </OutputList>
  51. <RunTimeInformation>
  52. <RunTimeCountersPerThread Thread="0" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
  53. </RunTimeInformation>
  54. <NestedLoops Optimized="false">
  55. <OuterReferences>
  56. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_name" />
  57. </OuterReferences>
  58. <RelOp AvgRowSize="254" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Inner Join" NodeId="2" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0589211">
  59. <OutputList>
  60. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_id" />
  61. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_nr" />
  62. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_name" />
  63. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations1]" Column="trans_to" />
  64. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations2]" Column="trans_to" />
  65. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations3]" Column="trans_to" />
  66. </OutputList>
  67. <RunTimeInformation>
  68. <RunTimeCountersPerThread Thread="0" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
  69. </RunTimeInformation>
  70. <NestedLoops Optimized="false">
  71. <PassThru>
  72. <ScalarOperator ScalarString="[IsBaseRow1004] IS NULL">
  73. <Compare CompareOp="IS">
  74. <ScalarOperator>
  75. <Identifier>
  76. <ColumnReference Column="IsBaseRow1004" />
  77. </Identifier>
  78. </ScalarOperator>
  79. <ScalarOperator>
  80. <Const ConstValue="NULL" />
  81. </ScalarOperator>
  82. </Compare>
  83. </ScalarOperator>
  84. </PassThru>
  85. <OuterReferences>
  86. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations3]" Column="trans_id" />
  87. </OuterReferences>
  88. <RelOp AvgRowSize="209" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Left Outer Join" NodeId="3" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0556335">
  89. <OutputList>
  90. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_id" />
  91. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_nr" />
  92. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_name" />
  93. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations1]" Column="trans_to" />
  94. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations2]" Column="trans_to" />
  95. <ColumnReference Column="IsBaseRow1004" />
  96. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations3]" Column="trans_id" />
  97. </OutputList>
  98. <RunTimeInformation>
  99. <RunTimeCountersPerThread Thread="0" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
  100. </RunTimeInformation>
  101. <NestedLoops Optimized="false">
  102. <OuterReferences>
  103. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_name" />
  104. </OuterReferences>
  105. <RelOp AvgRowSize="204" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Inner Join" NodeId="4" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0523462">
  106. <OutputList>
  107. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_id" />
  108. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_nr" />
  109. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_name" />
  110. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations1]" Column="trans_to" />
  111. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations2]" Column="trans_to" />
  112. </OutputList>
  113. <RunTimeInformation>
  114. <RunTimeCountersPerThread Thread="0" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
  115. </RunTimeInformation>
  116. <NestedLoops Optimized="false">
  117. <PassThru>
  118. <ScalarOperator ScalarString="[IsBaseRow1003] IS NULL">
  119. <Compare CompareOp="IS">
  120. <ScalarOperator>
  121. <Identifier>
  122. <ColumnReference Column="IsBaseRow1003" />
  123. </Identifier>
  124. </ScalarOperator>
  125. <ScalarOperator>
  126. <Const ConstValue="NULL" />
  127. </ScalarOperator>
  128. </Compare>
  129. </ScalarOperator>
  130. </PassThru>
  131. <OuterReferences>
  132. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations2]" Column="trans_id" />
  133. </OuterReferences>
  134. <RelOp AvgRowSize="159" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Left Outer Join" NodeId="5" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0490587">
  135. <OutputList>
  136. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_id" />
  137. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_nr" />
  138. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_name" />
  139. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations1]" Column="trans_to" />
  140. <ColumnReference Column="IsBaseRow1003" />
  141. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations2]" Column="trans_id" />
  142. </OutputList>
  143. <RunTimeInformation>
  144. <RunTimeCountersPerThread Thread="0" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
  145. </RunTimeInformation>
  146. <NestedLoops Optimized="false">
  147. <OuterReferences>
  148. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_nr" />
  149. </OuterReferences>
  150. <RelOp AvgRowSize="154" EstimateCPU="0.000100154" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Sort" NodeId="6" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.0457714">
  151. <OutputList>
  152. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_id" />
  153. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_nr" />
  154. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_name" />
  155. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations1]" Column="trans_to" />
  156. </OutputList>
  157. <MemoryFractions Input="1" Output="1" />
  158. <RunTimeInformation>
  159. <RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
  160. </RunTimeInformation>
  161. <Sort Distinct="false">
  162. <OrderBy>
  163. <OrderByColumn Ascending="true">
  164. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations1]" Column="trans_to" />
  165. </OrderByColumn>
  166. <OrderByColumn Ascending="true">
  167. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_nr" />
  168. </OrderByColumn>
  169. </OrderBy>
  170. <RelOp AvgRowSize="154" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Inner Join" NodeId="7" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.03441">
  171. <OutputList>
  172. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_id" />
  173. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_nr" />
  174. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_name" />
  175. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations1]" Column="trans_to" />
  176. </OutputList>
  177. <RunTimeInformation>
  178. <RunTimeCountersPerThread Thread="0" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
  179. </RunTimeInformation>
  180. <NestedLoops Optimized="false">
  181. <PassThru>
  182. <ScalarOperator ScalarString="[IsBaseRow1002] IS NULL">
  183. <Compare CompareOp="IS">
  184. <ScalarOperator>
  185. <Identifier>
  186. <ColumnReference Column="IsBaseRow1002" />
  187. </Identifier>
  188. </ScalarOperator>
  189. <ScalarOperator>
  190. <Const ConstValue="NULL" />
  191. </ScalarOperator>
  192. </Compare>
  193. </ScalarOperator>
  194. </PassThru>
  195. <OuterReferences>
  196. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations1]" Column="trans_id" />
  197. </OuterReferences>
  198. <RelOp AvgRowSize="109" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Left Outer Join" NodeId="8" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0311224">
  199. <OutputList>
  200. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_id" />
  201. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_nr" />
  202. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_name" />
  203. <ColumnReference Column="IsBaseRow1002" />
  204. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations1]" Column="trans_id" />
  205. </OutputList>
  206. <RunTimeInformation>
  207. <RunTimeCountersPerThread Thread="0" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
  208. </RunTimeInformation>
  209. <NestedLoops Optimized="false">
  210. <OuterReferences>
  211. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_nr" />
  212. </OuterReferences>
  213. <RelOp AvgRowSize="104" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="9" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0278351">
  214. <OutputList>
  215. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_id" />
  216. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_nr" />
  217. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_name" />
  218. </OutputList>
  219. <RunTimeInformation>
  220. <RunTimeCountersPerThread Thread="0" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
  221. </RunTimeInformation>
  222. <NestedLoops Optimized="false">
  223. <OuterReferences>
  224. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_id" />
  225. </OuterReferences>
  226. <RelOp AvgRowSize="112" EstimateCPU="0.000191513" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="10" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00331651" TableCardinality="901999">
  227. <OutputList>
  228. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_id" />
  229. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_nr" />
  230. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_name" />
  231. </OutputList>
  232. <RunTimeInformation>
  233. <RunTimeCountersPerThread Thread="0" ActualRows="760" ActualEndOfScans="1" ActualExecutions="1" />
  234. </RunTimeInformation>
  235. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
  236. <DefinedValues>
  237. <DefinedValue>
  238. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_id" />
  239. </DefinedValue>
  240. <DefinedValue>
  241. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_nr" />
  242. </DefinedValue>
  243. <DefinedValue>
  244. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_name" />
  245. </DefinedValue>
  246. </DefinedValues>
  247. <Object Database="[db]" Schema="[dbo]" Table="[institutions]" Index="[IX_institutions_lcd_id]" IndexKind="NonClustered" />
  248. <SeekPredicates>
  249. <SeekPredicateNew>
  250. <SeekKeys>
  251. <Prefix ScanType="EQ">
  252. <RangeColumns>
  253. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="lcd_id" />
  254. </RangeColumns>
  255. <RangeExpressions>
  256. <ScalarOperator ScalarString="[@12]">
  257. <Identifier>
  258. <ColumnReference Column="@12" />
  259. </Identifier>
  260. </ScalarOperator>
  261. </RangeExpressions>
  262. </Prefix>
  263. </SeekKeys>
  264. </SeekPredicateNew>
  265. </SeekPredicates>
  266. <Predicate>
  267. <ScalarOperator ScalarString="[db].[dbo].[institutions].[org_id]=[@8] AND [db].[dbo].[institutions].[app_id]=[@9] OR [db].[dbo].[institutions].[org_id]=[@10] AND [db].[dbo].[institutions].[app_id]=[@11]">
  268. <Logical Operation="OR">
  269. <ScalarOperator>
  270. <Logical Operation="AND">
  271. <ScalarOperator>
  272. <Compare CompareOp="EQ">
  273. <ScalarOperator>
  274. <Identifier>
  275. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="org_id" />
  276. </Identifier>
  277. </ScalarOperator>
  278. <ScalarOperator>
  279. <Identifier>
  280. <ColumnReference Column="@8" />
  281. </Identifier>
  282. </ScalarOperator>
  283. </Compare>
  284. </ScalarOperator>
  285. <ScalarOperator>
  286. <Compare CompareOp="EQ">
  287. <ScalarOperator>
  288. <Identifier>
  289. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="app_id" />
  290. </Identifier>
  291. </ScalarOperator>
  292. <ScalarOperator>
  293. <Identifier>
  294. <ColumnReference Column="@9" />
  295. </Identifier>
  296. </ScalarOperator>
  297. </Compare>
  298. </ScalarOperator>
  299. </Logical>
  300. </ScalarOperator>
  301. <ScalarOperator>
  302. <Logical Operation="AND">
  303. <ScalarOperator>
  304. <Compare CompareOp="EQ">
  305. <ScalarOperator>
  306. <Identifier>
  307. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="org_id" />
  308. </Identifier>
  309. </ScalarOperator>
  310. <ScalarOperator>
  311. <Identifier>
  312. <ColumnReference Column="@10" />
  313. </Identifier>
  314. </ScalarOperator>
  315. </Compare>
  316. </ScalarOperator>
  317. <ScalarOperator>
  318. <Compare CompareOp="EQ">
  319. <ScalarOperator>
  320. <Identifier>
  321. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="app_id" />
  322. </Identifier>
  323. </ScalarOperator>
  324. <ScalarOperator>
  325. <Identifier>
  326. <ColumnReference Column="@11" />
  327. </Identifier>
  328. </ScalarOperator>
  329. </Compare>
  330. </ScalarOperator>
  331. </Logical>
  332. </ScalarOperator>
  333. </Logical>
  334. </ScalarOperator>
  335. </Predicate>
  336. </IndexScan>
  337. </RelOp>
  338. <RelOp AvgRowSize="9" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Inner Join" NodeId="12" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0244617">
  339. <OutputList />
  340. <RunTimeInformation>
  341. <RunTimeCountersPerThread Thread="0" ActualRows="3" ActualEndOfScans="757" ActualExecutions="760" />
  342. </RunTimeInformation>
  343. <NestedLoops Optimized="false">
  344. <OuterReferences>
  345. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="agree_id" />
  346. </OuterReferences>
  347. <RelOp AvgRowSize="11" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="13" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0211736">
  348. <OutputList>
  349. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="agree_id" />
  350. </OutputList>
  351. <RunTimeInformation>
  352. <RunTimeCountersPerThread Thread="0" ActualRows="46286" ActualEndOfScans="757" ActualExecutions="760" />
  353. </RunTimeInformation>
  354. <NestedLoops Optimized="false">
  355. <OuterReferences>
  356. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="agree_id" />
  357. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="anz_gesamt" />
  358. </OuterReferences>
  359. <RelOp AvgRowSize="15" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="14" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.017872">
  360. <OutputList>
  361. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="agree_id" />
  362. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="anz_gesamt" />
  363. </OutputList>
  364. <RunTimeInformation>
  365. <RunTimeCountersPerThread Thread="0" ActualRows="50834" ActualEndOfScans="757" ActualExecutions="760" />
  366. </RunTimeInformation>
  367. <NestedLoops Optimized="false">
  368. <Predicate>
  369. <ScalarOperator ScalarString="[db].[dbo].[agreements].[agree_id]=[db].[dbo].[ZU_STUDJ_AGREE].[agree_id]">
  370. <Compare CompareOp="EQ">
  371. <ScalarOperator>
  372. <Identifier>
  373. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="agree_id" />
  374. </Identifier>
  375. </ScalarOperator>
  376. <ScalarOperator>
  377. <Identifier>
  378. <ColumnReference Database="[db]" Schema="[dbo]" Table="[ZU_STUDJ_AGREE]" Column="agree_id" />
  379. </Identifier>
  380. </ScalarOperator>
  381. </Compare>
  382. </ScalarOperator>
  383. </Predicate>
  384. <RelOp AvgRowSize="15" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Left Anti Semi Join" NodeId="15" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0112971">
  385. <OutputList>
  386. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="agree_id" />
  387. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="anz_gesamt" />
  388. </OutputList>
  389. <RunTimeInformation>
  390. <RunTimeCountersPerThread Thread="0" ActualRows="54630" ActualEndOfScans="757" ActualExecutions="760" />
  391. </RunTimeInformation>
  392. <NestedLoops Optimized="false">
  393. <OuterReferences>
  394. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="aust_prog_id" />
  395. </OuterReferences>
  396. <RelOp AvgRowSize="27" EstimateCPU="5.39763E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1.2913" LogicalOp="Inner Join" NodeId="16" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00800681">
  397. <OutputList>
  398. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="agree_id" />
  399. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="aust_prog_id" />
  400. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="anz_gesamt" />
  401. </OutputList>
  402. <RunTimeInformation>
  403. <RunTimeCountersPerThread Thread="0" ActualRows="54630" ActualEndOfScans="757" ActualExecutions="760" />
  404. </RunTimeInformation>
  405. <NestedLoops Optimized="false">
  406. <OuterReferences>
  407. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="agree_id" />
  408. </OuterReferences>
  409. <RelOp AvgRowSize="15" EstimateCPU="0.000629998" EstimateIO="0.0035155" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1.2913" LogicalOp="Index Seek" NodeId="17" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0041455" TableCardinality="150918">
  410. <OutputList>
  411. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="agree_id" />
  412. </OutputList>
  413. <RunTimeInformation>
  414. <RunTimeCountersPerThread Thread="0" ActualRows="54630" ActualEndOfScans="757" ActualExecutions="760" />
  415. </RunTimeInformation>
  416. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
  417. <DefinedValues>
  418. <DefinedValue>
  419. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="agree_id" />
  420. </DefinedValue>
  421. </DefinedValues>
  422. <Object Database="[db]" Schema="[dbo]" Table="[agreements]" Index="[IX_agreements_7]" TableReferenceId="2" IndexKind="NonClustered" />
  423. <SeekPredicates>
  424. <SeekPredicateNew>
  425. <SeekKeys>
  426. <Prefix ScanType="EQ">
  427. <RangeColumns>
  428. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="org_id" />
  429. </RangeColumns>
  430. <RangeExpressions>
  431. <ScalarOperator ScalarString="[@14]">
  432. <Identifier>
  433. <ColumnReference Column="@14" />
  434. </Identifier>
  435. </ScalarOperator>
  436. </RangeExpressions>
  437. </Prefix>
  438. </SeekKeys>
  439. </SeekPredicateNew>
  440. </SeekPredicates>
  441. <Predicate>
  442. <ScalarOperator ScalarString="[db].[dbo].[agreements].[inst_id]=[@27]">
  443. <Compare CompareOp="EQ">
  444. <ScalarOperator>
  445. <Identifier>
  446. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="inst_id" />
  447. </Identifier>
  448. </ScalarOperator>
  449. <ScalarOperator>
  450. <Identifier>
  451. <ColumnReference Column="@27" />
  452. </Identifier>
  453. </ScalarOperator>
  454. </Compare>
  455. </ScalarOperator>
  456. </Predicate>
  457. </IndexScan>
  458. </RelOp>
  459. <RelOp AvgRowSize="25" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0.2913" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="19" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00364951" TableCardinality="150918">
  460. <OutputList>
  461. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="aust_prog_id" />
  462. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="anz_gesamt" />
  463. </OutputList>
  464. <RunTimeInformation>
  465. <RunTimeCountersPerThread Thread="0" ActualRows="54630" ActualEndOfScans="0" ActualExecutions="54630" />
  466. </RunTimeInformation>
  467. <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
  468. <DefinedValues>
  469. <DefinedValue>
  470. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="aust_prog_id" />
  471. </DefinedValue>
  472. <DefinedValue>
  473. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="anz_gesamt" />
  474. </DefinedValue>
  475. </DefinedValues>
  476. <Object Database="[db]" Schema="[dbo]" Table="[agreements]" Index="[PK_agreements]" TableReferenceId="-1" IndexKind="Clustered" />
  477. <SeekPredicates>
  478. <SeekPredicateNew>
  479. <SeekKeys>
  480. <Prefix ScanType="EQ">
  481. <RangeColumns>
  482. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="agree_id" />
  483. </RangeColumns>
  484. <RangeExpressions>
  485. <ScalarOperator ScalarString="[db].[dbo].[agreements].[agree_id]">
  486. <Identifier>
  487. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="agree_id" />
  488. </Identifier>
  489. </ScalarOperator>
  490. </RangeExpressions>
  491. </Prefix>
  492. </SeekKeys>
  493. </SeekPredicateNew>
  494. </SeekPredicates>
  495. <Predicate>
  496. <ScalarOperator ScalarString="([db].[dbo].[agreements].[kz_bew_pers]=[@16] OR [db].[dbo].[agreements].[kz_bew_pers]=[@15]) AND ([db].[dbo].[agreements].[kz_bew_art]=CONVERT_IMPLICIT(nvarchar(4000),[@18],0) OR [db].[dbo].[agreements].[kz_bew_art]=CONVERT_IMPLICIT(nvarchar(4000),[@17],0))">
  497. <Logical Operation="AND">
  498. <ScalarOperator>
  499. <Logical Operation="OR">
  500. <ScalarOperator>
  501. <Compare CompareOp="EQ">
  502. <ScalarOperator>
  503. <Identifier>
  504. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="kz_bew_pers" />
  505. </Identifier>
  506. </ScalarOperator>
  507. <ScalarOperator>
  508. <Identifier>
  509. <ColumnReference Column="@16" />
  510. </Identifier>
  511. </ScalarOperator>
  512. </Compare>
  513. </ScalarOperator>
  514. <ScalarOperator>
  515. <Compare CompareOp="EQ">
  516. <ScalarOperator>
  517. <Identifier>
  518. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="kz_bew_pers" />
  519. </Identifier>
  520. </ScalarOperator>
  521. <ScalarOperator>
  522. <Identifier>
  523. <ColumnReference Column="@15" />
  524. </Identifier>
  525. </ScalarOperator>
  526. </Compare>
  527. </ScalarOperator>
  528. </Logical>
  529. </ScalarOperator>
  530. <ScalarOperator>
  531. <Logical Operation="OR">
  532. <ScalarOperator>
  533. <Compare CompareOp="EQ">
  534. <ScalarOperator>
  535. <Identifier>
  536. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="kz_bew_art" />
  537. </Identifier>
  538. </ScalarOperator>
  539. <ScalarOperator>
  540. <Identifier>
  541. <ColumnReference Column="ConstExpr1022">
  542. <ScalarOperator>
  543. <Convert DataType="nvarchar" Length="8000" Style="0" Implicit="true">
  544. <ScalarOperator>
  545. <Identifier>
  546. <ColumnReference Column="@18" />
  547. </Identifier>
  548. </ScalarOperator>
  549. </Convert>
  550. </ScalarOperator>
  551. </ColumnReference>
  552. </Identifier>
  553. </ScalarOperator>
  554. </Compare>
  555. </ScalarOperator>
  556. <ScalarOperator>
  557. <Compare CompareOp="EQ">
  558. <ScalarOperator>
  559. <Identifier>
  560. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="kz_bew_art" />
  561. </Identifier>
  562. </ScalarOperator>
  563. <ScalarOperator>
  564. <Identifier>
  565. <ColumnReference Column="ConstExpr1023">
  566. <ScalarOperator>
  567. <Convert DataType="nvarchar" Length="8000" Style="0" Implicit="true">
  568. <ScalarOperator>
  569. <Identifier>
  570. <ColumnReference Column="@17" />
  571. </Identifier>
  572. </ScalarOperator>
  573. </Convert>
  574. </ScalarOperator>
  575. </ColumnReference>
  576. </Identifier>
  577. </ScalarOperator>
  578. </Compare>
  579. </ScalarOperator>
  580. </Logical>
  581. </ScalarOperator>
  582. </Logical>
  583. </ScalarOperator>
  584. </Predicate>
  585. </IndexScan>
  586. </RelOp>
  587. </NestedLoops>
  588. </RelOp>
  589. <RelOp AvgRowSize="12" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="20" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="3264">
  590. <OutputList />
  591. <RunTimeInformation>
  592. <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="54630" ActualExecutions="54630" />
  593. </RunTimeInformation>
  594. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
  595. <DefinedValues />
  596. <Object Database="[db]" Schema="[dbo]" Table="[AUST_PROGRAMME]" Index="[PK_AUST_PROGRAMME]" IndexKind="Clustered" />
  597. <SeekPredicates>
  598. <SeekPredicateNew>
  599. <SeekKeys>
  600. <Prefix ScanType="EQ">
  601. <RangeColumns>
  602. <ColumnReference Database="[db]" Schema="[dbo]" Table="[AUST_PROGRAMME]" Column="aust_prog_id" />
  603. </RangeColumns>
  604. <RangeExpressions>
  605. <ScalarOperator ScalarString="[db].[dbo].[agreements].[aust_prog_id]">
  606. <Identifier>
  607. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="aust_prog_id" />
  608. </Identifier>
  609. </ScalarOperator>
  610. </RangeExpressions>
  611. </Prefix>
  612. </SeekKeys>
  613. </SeekPredicateNew>
  614. </SeekPredicates>
  615. <Predicate>
  616. <ScalarOperator ScalarString="[db].[dbo].[AUST_PROGRAMME].[org_id]=[@19] AND [db].[dbo].[AUST_PROGRAMME].[is_not_part_of_all_prog]=[@20]">
  617. <Logical Operation="AND">
  618. <ScalarOperator>
  619. <Compare CompareOp="EQ">
  620. <ScalarOperator>
  621. <Identifier>
  622. <ColumnReference Database="[db]" Schema="[dbo]" Table="[AUST_PROGRAMME]" Column="org_id" />
  623. </Identifier>
  624. </ScalarOperator>
  625. <ScalarOperator>
  626. <Identifier>
  627. <ColumnReference Column="@19" />
  628. </Identifier>
  629. </ScalarOperator>
  630. </Compare>
  631. </ScalarOperator>
  632. <ScalarOperator>
  633. <Compare CompareOp="EQ">
  634. <ScalarOperator>
  635. <Identifier>
  636. <ColumnReference Database="[db]" Schema="[dbo]" Table="[AUST_PROGRAMME]" Column="is_not_part_of_all_prog" />
  637. </Identifier>
  638. </ScalarOperator>
  639. <ScalarOperator>
  640. <Identifier>
  641. <ColumnReference Column="@20" />
  642. </Identifier>
  643. </ScalarOperator>
  644. </Compare>
  645. </ScalarOperator>
  646. </Logical>
  647. </ScalarOperator>
  648. </Predicate>
  649. </IndexScan>
  650. </RelOp>
  651. </NestedLoops>
  652. </RelOp>
  653. <RelOp AvgRowSize="11" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Inner Join" NodeId="21" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00657038">
  654. <OutputList>
  655. <ColumnReference Database="[db]" Schema="[dbo]" Table="[ZU_STUDJ_AGREE]" Column="agree_id" />
  656. </OutputList>
  657. <RunTimeInformation>
  658. <RunTimeCountersPerThread Thread="0" ActualRows="17549508" ActualEndOfScans="3796" ActualExecutions="54630" />
  659. </RunTimeInformation>
  660. <NestedLoops Optimized="false">
  661. <OuterReferences>
  662. <ColumnReference Database="[db]" Schema="[dbo]" Table="[ZU_STUDJ_AGREE]" Column="studj_agree_id" />
  663. </OuterReferences>
  664. <RelOp AvgRowSize="11" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="22" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="922743">
  665. <OutputList>
  666. <ColumnReference Database="[db]" Schema="[dbo]" Table="[ZU_STUDJ_AGREE]" Column="studj_agree_id" />
  667. </OutputList>
  668. <RunTimeInformation>
  669. <RunTimeCountersPerThread Thread="0" ActualRows="17549508" ActualEndOfScans="3796" ActualExecutions="54630" />
  670. </RunTimeInformation>
  671. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
  672. <DefinedValues>
  673. <DefinedValue>
  674. <ColumnReference Database="[db]" Schema="[dbo]" Table="[ZU_STUDJ_AGREE]" Column="studj_agree_id" />
  675. </DefinedValue>
  676. </DefinedValues>
  677. <Object Database="[db]" Schema="[dbo]" Table="[ZU_STUDJ_AGREE]" Index="[IX_ZU_STUDJ_AGREE_6]" IndexKind="NonClustered" />
  678. <SeekPredicates>
  679. <SeekPredicateNew>
  680. <SeekKeys>
  681. <Prefix ScanType="EQ">
  682. <RangeColumns>
  683. <ColumnReference Database="[db]" Schema="[dbo]" Table="[ZU_STUDJ_AGREE]" Column="studj_id" />
  684. <ColumnReference Database="[db]" Schema="[dbo]" Table="[ZU_STUDJ_AGREE]" Column="sem_id" />
  685. </RangeColumns>
  686. <RangeExpressions>
  687. <ScalarOperator ScalarString="[@21]">
  688. <Identifier>
  689. <ColumnReference Column="@21" />
  690. </Identifier>
  691. </ScalarOperator>
  692. <ScalarOperator ScalarString="[@22]">
  693. <Identifier>
  694. <ColumnReference Column="@22" />
  695. </Identifier>
  696. </ScalarOperator>
  697. </RangeExpressions>
  698. </Prefix>
  699. </SeekKeys>
  700. </SeekPredicateNew>
  701. </SeekPredicates>
  702. </IndexScan>
  703. </RelOp>
  704. <RelOp AvgRowSize="11" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="24" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="922743">
  705. <OutputList>
  706. <ColumnReference Database="[db]" Schema="[dbo]" Table="[ZU_STUDJ_AGREE]" Column="agree_id" />
  707. </OutputList>
  708. <RunTimeInformation>
  709. <RunTimeCountersPerThread Thread="0" ActualRows="17549508" ActualEndOfScans="0" ActualExecutions="17549508" />
  710. </RunTimeInformation>
  711. <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
  712. <DefinedValues>
  713. <DefinedValue>
  714. <ColumnReference Database="[db]" Schema="[dbo]" Table="[ZU_STUDJ_AGREE]" Column="agree_id" />
  715. </DefinedValue>
  716. </DefinedValues>
  717. <Object Database="[db]" Schema="[dbo]" Table="[ZU_STUDJ_AGREE]" Index="[PK_ZU_STUDJ_AGREE]" TableReferenceId="-1" IndexKind="Clustered" />
  718. <SeekPredicates>
  719. <SeekPredicateNew>
  720. <SeekKeys>
  721. <Prefix ScanType="EQ">
  722. <RangeColumns>
  723. <ColumnReference Database="[db]" Schema="[dbo]" Table="[ZU_STUDJ_AGREE]" Column="studj_agree_id" />
  724. </RangeColumns>
  725. <RangeExpressions>
  726. <ScalarOperator ScalarString="[db].[dbo].[ZU_STUDJ_AGREE].[studj_agree_id]">
  727. <Identifier>
  728. <ColumnReference Database="[db]" Schema="[dbo]" Table="[ZU_STUDJ_AGREE]" Column="studj_agree_id" />
  729. </Identifier>
  730. </ScalarOperator>
  731. </RangeExpressions>
  732. </Prefix>
  733. </SeekKeys>
  734. </SeekPredicateNew>
  735. </SeekPredicates>
  736. </IndexScan>
  737. </RelOp>
  738. </NestedLoops>
  739. </RelOp>
  740. </NestedLoops>
  741. </RelOp>
  742. <RelOp AvgRowSize="9" EstimateCPU="2E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Concatenation" NodeId="25" Parallel="false" PhysicalOp="Concatenation" EstimatedTotalSubtreeCost="0.00329738">
  743. <OutputList />
  744. <RunTimeInformation>
  745. <RunTimeCountersPerThread Thread="0" ActualRows="46286" ActualEndOfScans="4548" ActualExecutions="50834" />
  746. </RunTimeInformation>
  747. <Concat>
  748. <DefinedValues />
  749. <RelOp AvgRowSize="9" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Left Anti Semi Join" NodeId="26" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00329738">
  750. <OutputList />
  751. <RunTimeInformation>
  752. <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="50834" ActualExecutions="50834" />
  753. </RunTimeInformation>
  754. <NestedLoops Optimized="false">
  755. <RelOp AvgRowSize="9" EstimateCPU="1.157E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Constant Scan" NodeId="27" Parallel="false" PhysicalOp="Constant Scan" EstimatedTotalSubtreeCost="1.157E-06">
  756. <OutputList />
  757. <RunTimeInformation>
  758. <RunTimeCountersPerThread Thread="0" ActualRows="50834" ActualEndOfScans="50834" ActualExecutions="50834" />
  759. </RunTimeInformation>
  760. <ConstantScan />
  761. </RelOp>
  762. <RelOp AvgRowSize="9" EstimateCPU="0.00016704" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="9.12739" LogicalOp="Index Seek" NodeId="28" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00329204" TableCardinality="477171">
  763. <OutputList />
  764. <RunTimeInformation>
  765. <RunTimeCountersPerThread Thread="0" ActualRows="50834" ActualEndOfScans="0" ActualExecutions="50834" />
  766. </RunTimeInformation>
  767. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
  768. <DefinedValues />
  769. <Object Database="[db]" Schema="[dbo]" Table="[AGREE_STAT]" Index="[IX_AGREE_STAT_2]" TableReferenceId="1" IndexKind="NonClustered" />
  770. <SeekPredicates>
  771. <SeekPredicateNew>
  772. <SeekKeys>
  773. <Prefix ScanType="EQ">
  774. <RangeColumns>
  775. <ColumnReference Database="[db]" Schema="[dbo]" Table="[AGREE_STAT]" Column="org_id" />
  776. <ColumnReference Database="[db]" Schema="[dbo]" Table="[AGREE_STAT]" Column="agree_id" />
  777. </RangeColumns>
  778. <RangeExpressions>
  779. <ScalarOperator ScalarString="[@23]">
  780. <Identifier>
  781. <ColumnReference Column="@23" />
  782. </Identifier>
  783. </ScalarOperator>
  784. <ScalarOperator ScalarString="[db].[dbo].[agreements].[agree_id]">
  785. <Identifier>
  786. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="agree_id" />
  787. </Identifier>
  788. </ScalarOperator>
  789. </RangeExpressions>
  790. </Prefix>
  791. </SeekKeys>
  792. </SeekPredicateNew>
  793. </SeekPredicates>
  794. </IndexScan>
  795. </RelOp>
  796. </NestedLoops>
  797. </RelOp>
  798. <RelOp AvgRowSize="11" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Inner Join" NodeId="29" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00657038">
  799. <OutputList />
  800. <RunTimeInformation>
  801. <RunTimeCountersPerThread Thread="0" ActualRows="46286" ActualEndOfScans="4548" ActualExecutions="50834" />
  802. </RunTimeInformation>
  803. <NestedLoops Optimized="false">
  804. <OuterReferences>
  805. <ColumnReference Database="[db]" Schema="[dbo]" Table="[AGREE_STAT]" Column="agree_stat_id" />
  806. </OuterReferences>
  807. <RelOp AvgRowSize="11" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="30" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="477171">
  808. <OutputList>
  809. <ColumnReference Database="[db]" Schema="[dbo]" Table="[AGREE_STAT]" Column="agree_stat_id" />
  810. </OutputList>
  811. <RunTimeInformation>
  812. <RunTimeCountersPerThread Thread="0" ActualRows="50834" ActualEndOfScans="4548" ActualExecutions="50834" />
  813. </RunTimeInformation>
  814. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
  815. <DefinedValues>
  816. <DefinedValue>
  817. <ColumnReference Database="[db]" Schema="[dbo]" Table="[AGREE_STAT]" Column="agree_stat_id" />
  818. </DefinedValue>
  819. </DefinedValues>
  820. <Object Database="[db]" Schema="[dbo]" Table="[AGREE_STAT]" Index="[IX_AGREE_STAT_3]" TableReferenceId="2" IndexKind="NonClustered" />
  821. <SeekPredicates>
  822. <SeekPredicateNew>
  823. <SeekKeys>
  824. <Prefix ScanType="EQ">
  825. <RangeColumns>
  826. <ColumnReference Database="[db]" Schema="[dbo]" Table="[AGREE_STAT]" Column="org_id" />
  827. <ColumnReference Database="[db]" Schema="[dbo]" Table="[AGREE_STAT]" Column="agree_id" />
  828. <ColumnReference Database="[db]" Schema="[dbo]" Table="[AGREE_STAT]" Column="studj_id" />
  829. <ColumnReference Database="[db]" Schema="[dbo]" Table="[AGREE_STAT]" Column="sem_id" />
  830. </RangeColumns>
  831. <RangeExpressions>
  832. <ScalarOperator ScalarString="[@24]">
  833. <Identifier>
  834. <ColumnReference Column="@24" />
  835. </Identifier>
  836. </ScalarOperator>
  837. <ScalarOperator ScalarString="[db].[dbo].[agreements].[agree_id]">
  838. <Identifier>
  839. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="agree_id" />
  840. </Identifier>
  841. </ScalarOperator>
  842. <ScalarOperator ScalarString="[@25]">
  843. <Identifier>
  844. <ColumnReference Column="@25" />
  845. </Identifier>
  846. </ScalarOperator>
  847. <ScalarOperator ScalarString="[@26]">
  848. <Identifier>
  849. <ColumnReference Column="@26" />
  850. </Identifier>
  851. </ScalarOperator>
  852. </RangeExpressions>
  853. </Prefix>
  854. </SeekKeys>
  855. </SeekPredicateNew>
  856. </SeekPredicates>
  857. </IndexScan>
  858. </RelOp>
  859. <RelOp AvgRowSize="11" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="32" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="477171">
  860. <OutputList />
  861. <RunTimeInformation>
  862. <RunTimeCountersPerThread Thread="0" ActualRows="46286" ActualEndOfScans="4548" ActualExecutions="50834" />
  863. </RunTimeInformation>
  864. <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
  865. <DefinedValues />
  866. <Object Database="[db]" Schema="[dbo]" Table="[AGREE_STAT]" Index="[PK_AGREE_STAT]" TableReferenceId="-1" IndexKind="Clustered" />
  867. <SeekPredicates>
  868. <SeekPredicateNew>
  869. <SeekKeys>
  870. <Prefix ScanType="EQ">
  871. <RangeColumns>
  872. <ColumnReference Database="[db]" Schema="[dbo]" Table="[AGREE_STAT]" Column="agree_stat_id" />
  873. </RangeColumns>
  874. <RangeExpressions>
  875. <ScalarOperator ScalarString="[db].[dbo].[AGREE_STAT].[agree_stat_id]">
  876. <Identifier>
  877. <ColumnReference Database="[db]" Schema="[dbo]" Table="[AGREE_STAT]" Column="agree_stat_id" />
  878. </Identifier>
  879. </ScalarOperator>
  880. </RangeExpressions>
  881. </Prefix>
  882. </SeekKeys>
  883. </SeekPredicateNew>
  884. </SeekPredicates>
  885. <Predicate>
  886. <ScalarOperator ScalarString="[db].[dbo].[AGREE_STAT].[anz_zut_out]&lt;[db].[dbo].[agreements].[anz_gesamt]">
  887. <Compare CompareOp="LT">
  888. <ScalarOperator>
  889. <Identifier>
  890. <ColumnReference Database="[db]" Schema="[dbo]" Table="[AGREE_STAT]" Column="anz_zut_out" />
  891. </Identifier>
  892. </ScalarOperator>
  893. <ScalarOperator>
  894. <Identifier>
  895. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="anz_gesamt" />
  896. </Identifier>
  897. </ScalarOperator>
  898. </Compare>
  899. </ScalarOperator>
  900. </Predicate>
  901. </IndexScan>
  902. </RelOp>
  903. </NestedLoops>
  904. </RelOp>
  905. </Concat>
  906. </RelOp>
  907. </NestedLoops>
  908. </RelOp>
  909. <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="33" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="150918">
  910. <OutputList />
  911. <RunTimeInformation>
  912. <RunTimeCountersPerThread Thread="0" ActualRows="3" ActualEndOfScans="46283" ActualExecutions="46286" />
  913. </RunTimeInformation>
  914. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
  915. <DefinedValues />
  916. <Object Database="[db]" Schema="[dbo]" Table="[agreements]" Index="[PK_agreements]" TableReferenceId="1" IndexKind="Clustered" />
  917. <SeekPredicates>
  918. <SeekPredicateNew>
  919. <SeekKeys>
  920. <Prefix ScanType="EQ">
  921. <RangeColumns>
  922. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="agree_id" />
  923. </RangeColumns>
  924. <RangeExpressions>
  925. <ScalarOperator ScalarString="[db].[dbo].[agreements].[agree_id]">
  926. <Identifier>
  927. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="agree_id" />
  928. </Identifier>
  929. </ScalarOperator>
  930. </RangeExpressions>
  931. </Prefix>
  932. </SeekKeys>
  933. </SeekPredicateNew>
  934. </SeekPredicates>
  935. <Predicate>
  936. <ScalarOperator ScalarString="[db].[dbo].[agreements].[inst_id_partner]=[db].[dbo].[institutions].[inst_id] AND [db].[dbo].[agreements].[org_id]=[@13]">
  937. <Logical Operation="AND">
  938. <ScalarOperator>
  939. <Compare CompareOp="EQ">
  940. <ScalarOperator>
  941. <Identifier>
  942. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="inst_id_partner" />
  943. </Identifier>
  944. </ScalarOperator>
  945. <ScalarOperator>
  946. <Identifier>
  947. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_id" />
  948. </Identifier>
  949. </ScalarOperator>
  950. </Compare>
  951. </ScalarOperator>
  952. <ScalarOperator>
  953. <Compare CompareOp="EQ">
  954. <ScalarOperator>
  955. <Identifier>
  956. <ColumnReference Database="[db]" Schema="[dbo]" Table="[agreements]" Column="org_id" />
  957. </Identifier>
  958. </ScalarOperator>
  959. <ScalarOperator>
  960. <Identifier>
  961. <ColumnReference Column="@13" />
  962. </Identifier>
  963. </ScalarOperator>
  964. </Compare>
  965. </ScalarOperator>
  966. </Logical>
  967. </ScalarOperator>
  968. </Predicate>
  969. </IndexScan>
  970. </RelOp>
  971. </NestedLoops>
  972. </RelOp>
  973. </NestedLoops>
  974. </RelOp>
  975. <RelOp AvgRowSize="12" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="34" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="202827">
  976. <OutputList>
  977. <ColumnReference Column="IsBaseRow1002" />
  978. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations1]" Column="trans_id" />
  979. </OutputList>
  980. <RunTimeInformation>
  981. <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="3" ActualExecutions="3" />
  982. </RunTimeInformation>
  983. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
  984. <DefinedValues>
  985. <DefinedValue>
  986. <ColumnReference Column="IsBaseRow1002" />
  987. </DefinedValue>
  988. <DefinedValue>
  989. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations1]" Column="trans_id" />
  990. </DefinedValue>
  991. </DefinedValues>
  992. <Object Database="[db]" Schema="[dbo]" Table="[translations]" Index="[IX_translations]" Alias="[translations1]" IndexKind="NonClustered" />
  993. <SeekPredicates>
  994. <SeekPredicateNew>
  995. <SeekKeys>
  996. <Prefix ScanType="EQ">
  997. <RangeColumns>
  998. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations1]" Column="lang_locale" />
  999. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations1]" Column="trans_from" />
  1000. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations1]" Column="org_id" />
  1001. </RangeColumns>
  1002. <RangeExpressions>
  1003. <ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(4000),[@0],0)">
  1004. <Identifier>
  1005. <ColumnReference Column="ConstExpr1018">
  1006. <ScalarOperator>
  1007. <Convert DataType="nvarchar" Length="8000" Style="0" Implicit="true">
  1008. <ScalarOperator>
  1009. <Identifier>
  1010. <ColumnReference Column="@0" />
  1011. </Identifier>
  1012. </ScalarOperator>
  1013. </Convert>
  1014. </ScalarOperator>
  1015. </ColumnReference>
  1016. </Identifier>
  1017. </ScalarOperator>
  1018. <ScalarOperator ScalarString="[db].[dbo].[institutions].[inst_nr]">
  1019. <Identifier>
  1020. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_nr" />
  1021. </Identifier>
  1022. </ScalarOperator>
  1023. <ScalarOperator ScalarString="[@1]">
  1024. <Identifier>
  1025. <ColumnReference Column="@1" />
  1026. </Identifier>
  1027. </ScalarOperator>
  1028. </RangeExpressions>
  1029. </Prefix>
  1030. </SeekKeys>
  1031. </SeekPredicateNew>
  1032. </SeekPredicates>
  1033. </IndexScan>
  1034. </RelOp>
  1035. </NestedLoops>
  1036. </RelOp>
  1037. <RelOp AvgRowSize="411" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="36" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="202827">
  1038. <OutputList>
  1039. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations1]" Column="trans_to" />
  1040. </OutputList>
  1041. <RunTimeInformation>
  1042. <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
  1043. </RunTimeInformation>
  1044. <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
  1045. <DefinedValues>
  1046. <DefinedValue>
  1047. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations1]" Column="trans_to" />
  1048. </DefinedValue>
  1049. </DefinedValues>
  1050. <Object Database="[db]" Schema="[dbo]" Table="[translations]" Index="[PK_translations]" Alias="[translations1]" TableReferenceId="-1" IndexKind="Clustered" />
  1051. <SeekPredicates>
  1052. <SeekPredicateNew>
  1053. <SeekKeys>
  1054. <Prefix ScanType="EQ">
  1055. <RangeColumns>
  1056. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations1]" Column="trans_id" />
  1057. </RangeColumns>
  1058. <RangeExpressions>
  1059. <ScalarOperator ScalarString="[db].[dbo].[translations].[trans_id] as [translations1].[trans_id]">
  1060. <Identifier>
  1061. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations1]" Column="trans_id" />
  1062. </Identifier>
  1063. </ScalarOperator>
  1064. </RangeExpressions>
  1065. </Prefix>
  1066. </SeekKeys>
  1067. </SeekPredicateNew>
  1068. </SeekPredicates>
  1069. </IndexScan>
  1070. </RelOp>
  1071. </NestedLoops>
  1072. </RelOp>
  1073. </Sort>
  1074. </RelOp>
  1075. <RelOp AvgRowSize="12" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="37" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="202827">
  1076. <OutputList>
  1077. <ColumnReference Column="IsBaseRow1003" />
  1078. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations2]" Column="trans_id" />
  1079. </OutputList>
  1080. <RunTimeInformation>
  1081. <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="3" ActualExecutions="3" />
  1082. </RunTimeInformation>
  1083. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
  1084. <DefinedValues>
  1085. <DefinedValue>
  1086. <ColumnReference Column="IsBaseRow1003" />
  1087. </DefinedValue>
  1088. <DefinedValue>
  1089. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations2]" Column="trans_id" />
  1090. </DefinedValue>
  1091. </DefinedValues>
  1092. <Object Database="[db]" Schema="[dbo]" Table="[translations]" Index="[IX_translations]" Alias="[translations2]" IndexKind="NonClustered" />
  1093. <SeekPredicates>
  1094. <SeekPredicateNew>
  1095. <SeekKeys>
  1096. <Prefix ScanType="EQ">
  1097. <RangeColumns>
  1098. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations2]" Column="lang_locale" />
  1099. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations2]" Column="trans_from" />
  1100. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations2]" Column="org_id" />
  1101. </RangeColumns>
  1102. <RangeExpressions>
  1103. <ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(4000),[@2],0)">
  1104. <Identifier>
  1105. <ColumnReference Column="ConstExpr1019">
  1106. <ScalarOperator>
  1107. <Convert DataType="nvarchar" Length="8000" Style="0" Implicit="true">
  1108. <ScalarOperator>
  1109. <Identifier>
  1110. <ColumnReference Column="@2" />
  1111. </Identifier>
  1112. </ScalarOperator>
  1113. </Convert>
  1114. </ScalarOperator>
  1115. </ColumnReference>
  1116. </Identifier>
  1117. </ScalarOperator>
  1118. <ScalarOperator ScalarString="[db].[dbo].[institutions].[inst_nr]">
  1119. <Identifier>
  1120. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_nr" />
  1121. </Identifier>
  1122. </ScalarOperator>
  1123. <ScalarOperator ScalarString="[@3]">
  1124. <Identifier>
  1125. <ColumnReference Column="@3" />
  1126. </Identifier>
  1127. </ScalarOperator>
  1128. </RangeExpressions>
  1129. </Prefix>
  1130. </SeekKeys>
  1131. </SeekPredicateNew>
  1132. </SeekPredicates>
  1133. </IndexScan>
  1134. </RelOp>
  1135. </NestedLoops>
  1136. </RelOp>
  1137. <RelOp AvgRowSize="411" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="39" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="202827">
  1138. <OutputList>
  1139. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations2]" Column="trans_to" />
  1140. </OutputList>
  1141. <RunTimeInformation>
  1142. <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
  1143. </RunTimeInformation>
  1144. <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
  1145. <DefinedValues>
  1146. <DefinedValue>
  1147. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations2]" Column="trans_to" />
  1148. </DefinedValue>
  1149. </DefinedValues>
  1150. <Object Database="[db]" Schema="[dbo]" Table="[translations]" Index="[PK_translations]" Alias="[translations2]" TableReferenceId="-1" IndexKind="Clustered" />
  1151. <SeekPredicates>
  1152. <SeekPredicateNew>
  1153. <SeekKeys>
  1154. <Prefix ScanType="EQ">
  1155. <RangeColumns>
  1156. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations2]" Column="trans_id" />
  1157. </RangeColumns>
  1158. <RangeExpressions>
  1159. <ScalarOperator ScalarString="[db].[dbo].[translations].[trans_id] as [translations2].[trans_id]">
  1160. <Identifier>
  1161. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations2]" Column="trans_id" />
  1162. </Identifier>
  1163. </ScalarOperator>
  1164. </RangeExpressions>
  1165. </Prefix>
  1166. </SeekKeys>
  1167. </SeekPredicateNew>
  1168. </SeekPredicates>
  1169. </IndexScan>
  1170. </RelOp>
  1171. </NestedLoops>
  1172. </RelOp>
  1173. <RelOp AvgRowSize="12" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="40" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="202827">
  1174. <OutputList>
  1175. <ColumnReference Column="IsBaseRow1004" />
  1176. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations3]" Column="trans_id" />
  1177. </OutputList>
  1178. <RunTimeInformation>
  1179. <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="3" ActualExecutions="3" />
  1180. </RunTimeInformation>
  1181. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
  1182. <DefinedValues>
  1183. <DefinedValue>
  1184. <ColumnReference Column="IsBaseRow1004" />
  1185. </DefinedValue>
  1186. <DefinedValue>
  1187. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations3]" Column="trans_id" />
  1188. </DefinedValue>
  1189. </DefinedValues>
  1190. <Object Database="[db]" Schema="[dbo]" Table="[translations]" Index="[IX_translations]" Alias="[translations3]" IndexKind="NonClustered" />
  1191. <SeekPredicates>
  1192. <SeekPredicateNew>
  1193. <SeekKeys>
  1194. <Prefix ScanType="EQ">
  1195. <RangeColumns>
  1196. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations3]" Column="lang_locale" />
  1197. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations3]" Column="trans_from" />
  1198. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations3]" Column="org_id" />
  1199. </RangeColumns>
  1200. <RangeExpressions>
  1201. <ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(4000),[@4],0)">
  1202. <Identifier>
  1203. <ColumnReference Column="ConstExpr1020">
  1204. <ScalarOperator>
  1205. <Convert DataType="nvarchar" Length="8000" Style="0" Implicit="true">
  1206. <ScalarOperator>
  1207. <Identifier>
  1208. <ColumnReference Column="@4" />
  1209. </Identifier>
  1210. </ScalarOperator>
  1211. </Convert>
  1212. </ScalarOperator>
  1213. </ColumnReference>
  1214. </Identifier>
  1215. </ScalarOperator>
  1216. <ScalarOperator ScalarString="[db].[dbo].[institutions].[inst_name]">
  1217. <Identifier>
  1218. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_name" />
  1219. </Identifier>
  1220. </ScalarOperator>
  1221. <ScalarOperator ScalarString="[@5]">
  1222. <Identifier>
  1223. <ColumnReference Column="@5" />
  1224. </Identifier>
  1225. </ScalarOperator>
  1226. </RangeExpressions>
  1227. </Prefix>
  1228. </SeekKeys>
  1229. </SeekPredicateNew>
  1230. </SeekPredicates>
  1231. </IndexScan>
  1232. </RelOp>
  1233. </NestedLoops>
  1234. </RelOp>
  1235. <RelOp AvgRowSize="411" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="42" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="202827">
  1236. <OutputList>
  1237. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations3]" Column="trans_to" />
  1238. </OutputList>
  1239. <RunTimeInformation>
  1240. <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
  1241. </RunTimeInformation>
  1242. <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
  1243. <DefinedValues>
  1244. <DefinedValue>
  1245. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations3]" Column="trans_to" />
  1246. </DefinedValue>
  1247. </DefinedValues>
  1248. <Object Database="[db]" Schema="[dbo]" Table="[translations]" Index="[PK_translations]" Alias="[translations3]" TableReferenceId="-1" IndexKind="Clustered" />
  1249. <SeekPredicates>
  1250. <SeekPredicateNew>
  1251. <SeekKeys>
  1252. <Prefix ScanType="EQ">
  1253. <RangeColumns>
  1254. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations3]" Column="trans_id" />
  1255. </RangeColumns>
  1256. <RangeExpressions>
  1257. <ScalarOperator ScalarString="[db].[dbo].[translations].[trans_id] as [translations3].[trans_id]">
  1258. <Identifier>
  1259. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations3]" Column="trans_id" />
  1260. </Identifier>
  1261. </ScalarOperator>
  1262. </RangeExpressions>
  1263. </Prefix>
  1264. </SeekKeys>
  1265. </SeekPredicateNew>
  1266. </SeekPredicates>
  1267. </IndexScan>
  1268. </RelOp>
  1269. </NestedLoops>
  1270. </RelOp>
  1271. <RelOp AvgRowSize="12" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="43" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="202827">
  1272. <OutputList>
  1273. <ColumnReference Column="IsBaseRow1005" />
  1274. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations4]" Column="trans_id" />
  1275. </OutputList>
  1276. <RunTimeInformation>
  1277. <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="3" ActualExecutions="3" />
  1278. </RunTimeInformation>
  1279. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
  1280. <DefinedValues>
  1281. <DefinedValue>
  1282. <ColumnReference Column="IsBaseRow1005" />
  1283. </DefinedValue>
  1284. <DefinedValue>
  1285. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations4]" Column="trans_id" />
  1286. </DefinedValue>
  1287. </DefinedValues>
  1288. <Object Database="[db]" Schema="[dbo]" Table="[translations]" Index="[IX_translations]" Alias="[translations4]" IndexKind="NonClustered" />
  1289. <SeekPredicates>
  1290. <SeekPredicateNew>
  1291. <SeekKeys>
  1292. <Prefix ScanType="EQ">
  1293. <RangeColumns>
  1294. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations4]" Column="lang_locale" />
  1295. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations4]" Column="trans_from" />
  1296. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations4]" Column="org_id" />
  1297. </RangeColumns>
  1298. <RangeExpressions>
  1299. <ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(4000),[@6],0)">
  1300. <Identifier>
  1301. <ColumnReference Column="ConstExpr1021">
  1302. <ScalarOperator>
  1303. <Convert DataType="nvarchar" Length="8000" Style="0" Implicit="true">
  1304. <ScalarOperator>
  1305. <Identifier>
  1306. <ColumnReference Column="@6" />
  1307. </Identifier>
  1308. </ScalarOperator>
  1309. </Convert>
  1310. </ScalarOperator>
  1311. </ColumnReference>
  1312. </Identifier>
  1313. </ScalarOperator>
  1314. <ScalarOperator ScalarString="[db].[dbo].[institutions].[inst_name]">
  1315. <Identifier>
  1316. <ColumnReference Database="[db]" Schema="[dbo]" Table="[institutions]" Column="inst_name" />
  1317. </Identifier>
  1318. </ScalarOperator>
  1319. <ScalarOperator ScalarString="[@7]">
  1320. <Identifier>
  1321. <ColumnReference Column="@7" />
  1322. </Identifier>
  1323. </ScalarOperator>
  1324. </RangeExpressions>
  1325. </Prefix>
  1326. </SeekKeys>
  1327. </SeekPredicateNew>
  1328. </SeekPredicates>
  1329. </IndexScan>
  1330. </RelOp>
  1331. </NestedLoops>
  1332. </RelOp>
  1333. <RelOp AvgRowSize="411" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="45" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="202827">
  1334. <OutputList>
  1335. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations4]" Column="trans_to" />
  1336. </OutputList>
  1337. <RunTimeInformation>
  1338. <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
  1339. </RunTimeInformation>
  1340. <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
  1341. <DefinedValues>
  1342. <DefinedValue>
  1343. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations4]" Column="trans_to" />
  1344. </DefinedValue>
  1345. </DefinedValues>
  1346. <Object Database="[db]" Schema="[dbo]" Table="[translations]" Index="[PK_translations]" Alias="[translations4]" TableReferenceId="-1" IndexKind="Clustered" />
  1347. <SeekPredicates>
  1348. <SeekPredicateNew>
  1349. <SeekKeys>
  1350. <Prefix ScanType="EQ">
  1351. <RangeColumns>
  1352. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations4]" Column="trans_id" />
  1353. </RangeColumns>
  1354. <RangeExpressions>
  1355. <ScalarOperator ScalarString="[db].[dbo].[translations].[trans_id] as [translations4].[trans_id]">
  1356. <Identifier>
  1357. <ColumnReference Database="[db]" Schema="[dbo]" Table="[translations]" Alias="[translations4]" Column="trans_id" />
  1358. </Identifier>
  1359. </ScalarOperator>
  1360. </RangeExpressions>
  1361. </Prefix>
  1362. </SeekKeys>
  1363. </SeekPredicateNew>
  1364. </SeekPredicates>
  1365. </IndexScan>
  1366. </RelOp>
  1367. </NestedLoops>
  1368. </RelOp>
  1369. <ParameterList>
  1370. <ColumnReference Column="@27" ParameterCompiledValue="(123)" ParameterRuntimeValue="(123)" />
  1371. <ColumnReference Column="@26" ParameterCompiledValue="(456)" ParameterRuntimeValue="(456)" />
  1372. <ColumnReference Column="@25" ParameterCompiledValue="(789)" ParameterRuntimeValue="(789)" />
  1373. <ColumnReference Column="@24" ParameterCompiledValue="(1)" ParameterRuntimeValue="(1)" />
  1374. <ColumnReference Column="@23" ParameterCompiledValue="(1)" ParameterRuntimeValue="(1)" />
  1375. <ColumnReference Column="@22" ParameterCompiledValue="(456)" ParameterRuntimeValue="(456)" />
  1376. <ColumnReference Column="@21" ParameterCompiledValue="(789)" ParameterRuntimeValue="(789)" />
  1377. <ColumnReference Column="@20" ParameterCompiledValue="(1)" ParameterRuntimeValue="(1)" />
  1378. <ColumnReference Column="@19" ParameterCompiledValue="(1)" ParameterRuntimeValue="(1)" />
  1379. <ColumnReference Column="@17" ParameterCompiledValue="'A'" ParameterRuntimeValue="'A'" />
  1380. <ColumnReference Column="@18" ParameterCompiledValue="'B'" ParameterRuntimeValue="'B'" />
  1381. <ColumnReference Column="@15" ParameterCompiledValue="'S'" ParameterRuntimeValue="'S'" />
  1382. <ColumnReference Column="@16" ParameterCompiledValue="'B'" ParameterRuntimeValue="'B'" />
  1383. <ColumnReference Column="@14" ParameterCompiledValue="(1)" ParameterRuntimeValue="(1)" />
  1384. <ColumnReference Column="@13" ParameterCompiledValue="(1)" ParameterRuntimeValue="(1)" />
  1385. <ColumnReference Column="@12" ParameterCompiledValue="(33590)" ParameterRuntimeValue="(33590)" />
  1386. <ColumnReference Column="@11" ParameterCompiledValue="(1)" ParameterRuntimeValue="(1)" />
  1387. <ColumnReference Column="@10" ParameterCompiledValue="(1)" ParameterRuntimeValue="(1)" />
  1388. <ColumnReference Column="@9" ParameterCompiledValue="(1)" ParameterRuntimeValue="(1)" />
  1389. <ColumnReference Column="@8" ParameterCompiledValue="(1)" ParameterRuntimeValue="(1)" />
  1390. <ColumnReference Column="@7" ParameterCompiledValue="(1)" ParameterRuntimeValue="(1)" />
  1391. <ColumnReference Column="@6" ParameterCompiledValue="'de'" ParameterRuntimeValue="'de'" />
  1392. <ColumnReference Column="@5" ParameterCompiledValue="(0)" ParameterRuntimeValue="(0)" />
  1393. <ColumnReference Column="@4" ParameterCompiledValue="'de'" ParameterRuntimeValue="'de'" />
  1394. <ColumnReference Column="@3" ParameterCompiledValue="(1)" ParameterRuntimeValue="(1)" />
  1395. <ColumnReference Column="@2" ParameterCompiledValue="'de'" ParameterRuntimeValue="'de'" />
  1396. <ColumnReference Column="@1" ParameterCompiledValue="(0)" ParameterRuntimeValue="(0)" />
  1397. <ColumnReference Column="@0" ParameterCompiledValue="'de'" ParameterRuntimeValue="'de'" />
  1398. </ParameterList>
  1399. </QueryPlan>
  1400. </StmtSimple>
  1401. </Statements>
  1402. </Batch>
  1403. </BatchSequence>
  1404. </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!