API tools faq
paste
raghavcinch

Plan

raghavcinch
Aug 19th, 2016
150
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 304.02 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="11.0.5058.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
  3. <BatchSequence>
  4. <Batch>
  5. <Statements>
  6. <StmtSimple StatementCompId="10" StatementEstRows="3.27367" StatementId="1" StatementOptmLevel="TRIVIAL" StatementSubTreeCost="0.0132892" StatementText="INSERT INTO @locations SELECT Id FROM Location WHERE AccountId = @AccountId;&#xD;&#xA; " StatementType="INSERT" QueryHash="0x7A787B9A3146A6E4" QueryPlanHash="0xAB05E6F865B198C3" RetrievedFromCache="true">
  7. <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
  8. <QueryPlan DegreeOfParallelism="0" NonParallelPlanReason="CouldNotGenerateValidParallelPlan" CachedPlanSize="16" CompileTime="0" CompileCPU="0" CompileMemory="296">
  9. <MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" />
  10. <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="314561" EstimatedPagesCached="78640" EstimatedAvailableDegreeOfParallelism="2" />
  11. <RelOp AvgRowSize="9" EstimateCPU="3.27367E-06" EstimateIO="0.01" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3.27367" LogicalOp="Insert" NodeId="0" Parallel="false" PhysicalOp="Clustered Index Insert" EstimatedTotalSubtreeCost="0.0132892">
  12. <OutputList />
  13. <RunTimeInformation>
  14. <RunTimeCountersPerThread Thread="0" ActualRows="474" ActualEndOfScans="1" ActualExecutions="1" />
  15. </RunTimeInformation>
  16. <Update DMLRequestSort="false">
  17. <Object Table="[@locations]" Index="[PK__#AF5312E__3214EC0724F0754B]" />
  18. <SetPredicate>
  19. <ScalarOperator ScalarString="[Id] = [m5db].[dbo].[Location].[Id]">
  20. <ScalarExpressionList>
  21. <ScalarOperator>
  22. <MultipleAssign>
  23. <Assign>
  24. <ColumnReference Column="Id" />
  25. <ScalarOperator>
  26. <Identifier>
  27. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Column="Id" />
  28. </Identifier>
  29. </ScalarOperator>
  30. </Assign>
  31. </MultipleAssign>
  32. </ScalarOperator>
  33. </ScalarExpressionList>
  34. </ScalarOperator>
  35. </SetPredicate>
  36. <RelOp AvgRowSize="11" EstimateCPU="3.27367E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3.27367" LogicalOp="Top" NodeId="1" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="0.00328593">
  37. <OutputList>
  38. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Column="Id" />
  39. </OutputList>
  40. <RunTimeInformation>
  41. <RunTimeCountersPerThread Thread="0" ActualRows="474" ActualEndOfScans="1" ActualExecutions="1" />
  42. </RunTimeInformation>
  43. <Top RowCount="true" IsPercent="false" WithTies="false">
  44. <TopExpression>
  45. <ScalarOperator ScalarString="(0)">
  46. <Const ConstValue="(0)" />
  47. </ScalarOperator>
  48. </TopExpression>
  49. <RelOp AvgRowSize="11" EstimateCPU="0.000160601" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3.27367" LogicalOp="Index Seek" NodeId="2" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032856" TableCardinality="31578">
  50. <OutputList>
  51. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Column="Id" />
  52. </OutputList>
  53. <RunTimeInformation>
  54. <RunTimeCountersPerThread Thread="0" ActualRows="474" ActualEndOfScans="1" ActualExecutions="1" />
  55. </RunTimeInformation>
  56. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  57. <DefinedValues>
  58. <DefinedValue>
  59. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Column="Id" />
  60. </DefinedValue>
  61. </DefinedValues>
  62. <Object Database="[m5db]" Schema="[dbo]" Table="[Location]" Index="[IX_Location_AccountId]" IndexKind="NonClustered" />
  63. <SeekPredicates>
  64. <SeekPredicateNew>
  65. <SeekKeys>
  66. <Prefix ScanType="EQ">
  67. <RangeColumns>
  68. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Column="AccountId" />
  69. </RangeColumns>
  70. <RangeExpressions>
  71. <ScalarOperator ScalarString="[@AccountId]">
  72. <Identifier>
  73. <ColumnReference Column="@AccountId" />
  74. </Identifier>
  75. </ScalarOperator>
  76. </RangeExpressions>
  77. </Prefix>
  78. </SeekKeys>
  79. </SeekPredicateNew>
  80. </SeekPredicates>
  81. </IndexScan>
  82. </RelOp>
  83. </Top>
  84. </RelOp>
  85. </Update>
  86. </RelOp>
  87. <ParameterList>
  88. <ColumnReference Column="@AccountId" ParameterRuntimeValue="(5926)" />
  89. </ParameterList>
  90. </QueryPlan>
  91. </StmtSimple>
  92. </Statements>
  93. </Batch>
  94. <Batch>
  95. <Statements>
  96. <StmtSimple StatementCompId="14" StatementEstRows="1.23053" StatementId="2" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="TimeOut" StatementSubTreeCost="0.462873" StatementText="SELECT&#xD;&#xA; pe.Id AS PersonId,&#xD;&#xA; pe.FirstName,&#xD;&#xA; pe.LastName,&#xD;&#xA; FullName = CASE&#xD;&#xA; WHEN pe.Id IS NULL THEN 'Unassigned'&#xD;&#xA; WHEN pe.FirstName IS NULL AND pe.LastName IS NULL THEN COALESCE(pr.InternalCallerId, '')&#xD;&#xA; ELSE LTRIM(RTRIM(COALESCE(pe.FirstName, '') + ' ' + COALESCE(pe.LastName, '')))&#xD;&#xA; END,&#xD;&#xA; pr.Id AS ProfileId,&#xD;&#xA; pr.ProfileStatusId,&#xD;&#xA; COALESCE(pr.InternalCallerId, pr.Tn) AS InternalCallerId,&#xD;&#xA; pe.BusinessEmail,&#xD;&#xA; pr.LocationId AS LocationId,&#xD;&#xA; pr.AccountId AS AccountId,&#xD;&#xA; pr.Tn AS [Tn],&#xD;&#xA; pr.TnCountryId,&#xD;&#xA; pr.Extension AS Extension,&#xD;&#xA; pr.ProfileLocked AS ProfileLocked,&#xD;&#xA; --pr.PersonLocked AS PersonLocked,&#xD;&#xA; --CAST((CASE WHEN (SELECT COUNT(*) FROM @roles r WHERE r.personId IS NOT NULL AND r.personId = pe.Id AND r.roleId = 1) &gt; 0 THEN 1 ELSE 0 END) AS BIT) AS IsDM, -- Decision maker.&#xD;&#xA; --CAST((CASE WHEN (SELECT COUNT(*) FROM @roles r WHERE r.personId IS NOT NULL AND r.personId = pe.Id AND r.roleId = 2) &gt; 0 THEN 1 ELSE 0 END) AS BIT) AS IsPM, -- Phone manager.&#xD;&#xA; --CAST((CASE WHEN (SELECT COUNT(*) FROM @roles r WHERE r.personId IS NOT NULL AND r.personId = pe.Id AND r.roleId = 3) &gt; 0 THEN 1 ELSE 0 END) AS BIT) AS IsBC, -- Billing contact.&#xD;&#xA; --CAST((CASE WHEN (SELECT COUNT(*) FROM @roles r WHERE r.personId IS NOT NULL AND r.personId = pe.Id AND r.roleId = 4) &gt; 0 THEN 1 ELSE 0 END) AS BIT) AS IsEC, -- Emergency contact.&#xD;&#xA; --CAST((CASE WHEN (SELECT COUNT(*) FROM @roles r WHERE r.personId IS NOT NULL AND r.personId = pe.Id AND r.roleId = 8) &gt; 0 THEN 1 ELSE 0 END) AS BIT) AS IsTC, -- Technical.&#xD;&#xA; pr.ProfileTypeId AS ProfileTypeId,&#xD;&#xA; -- US23479 Profile life-cycle is maintained by the Director for sky accounts, we should not allow &quot;close profile&quot;.&#xD;&#xA; CASE WHEN pr.PlatFormTypeId = 7 THEN CAST(0 AS BIT) ELSE CAST(1 AS BIT) END AS IsCloseable, -- Only Premise profiles should be blocked from closing.&#xD;&#xA; pr.PlatformTypeId,&#xD;&#xA; pro.PartitionId &#xD;&#xA; FROM&#xD;&#xA; VwProfileDetails pr WITH(NOLOCK)&#xD;&#xA; LEFT JOIN [Person] pe WITH (NOLOCK) ON pr.PersonId = pe.Id&#xD;&#xA; LEFT JOIN [Profile] pro WITH (NOLOCK) ON pro.Id = pr.Id&#xD;&#xA; WHERE&#xD;&#xA; -- The filter below was placed there from the GetUserDetails() repository method.&#xD;&#xA; -- ENG-432057: Voicemail profiles should be displayed in Users grid.&#xD;&#xA; pr.ProfileTypeId IN (2, 3, 4, 5, 7, 11, 13, 12, 15) -- Managed, Analog, Virtual, Courtesy, Voicemail, Premise, PremiseRoutePoint, PremiseWorkgroup.&#xD;&#xA; AND&#xD;&#xA; pr.LocationId IN (SELECT Id FROM @locations)&#xD;&#xA; AND pr.AccountId = @AccountId&#xD;&#xA; AND (@PartitionId &lt;= 0 OR @PartitionId = pro.PartitionId);&#xD;&#xA; " StatementType="SELECT" QueryHash="0x1ABA189056C7C874" QueryPlanHash="0x37C9ACEC3D16C982" RetrievedFromCache="true">
  97. <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
  98. <QueryPlan DegreeOfParallelism="0" NonParallelPlanReason="CouldNotGenerateValidParallelPlan" MemoryGrant="1088" CachedPlanSize="264" CompileTime="894" CompileCPU="311" CompileMemory="5944">
  99. <Warnings>
  100. <PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(nvarchar(15),[pr].[TnId],0)" />
  101. <PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(nvarchar(100),[pr].[TnId],0)" />
  102. </Warnings>
  103. <MemoryGrantInfo SerialRequiredMemory="1024" SerialDesiredMemory="1088" RequiredMemory="1024" DesiredMemory="1088" RequestedMemory="1088" GrantWaitTime="0" GrantedMemory="1088" MaxUsedMemory="232" />
  104. <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="314561" EstimatedPagesCached="78640" EstimatedAvailableDegreeOfParallelism="2" />
  105. <RelOp AvgRowSize="842" EstimateCPU="1.23053E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.23053" LogicalOp="Compute Scalar" NodeId="0" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.462873">
  106. <OutputList>
  107. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  108. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  109. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  110. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Extension" />
  111. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnId" />
  112. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnCountryId" />
  113. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  114. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="AccountId" />
  115. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="PlatformTypeId" />
  116. <ColumnReference Column="Expr1045" />
  117. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="Id" />
  118. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="FirstName" />
  119. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="LastName" />
  120. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="BusinessEmail" />
  121. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pro]" Column="PartitionId" />
  122. <ColumnReference Column="Expr1055" />
  123. <ColumnReference Column="Expr1056" />
  124. <ColumnReference Column="Expr1057" />
  125. </OutputList>
  126. <ComputeScalar>
  127. <DefinedValues>
  128. <DefinedValue>
  129. <ColumnReference Column="Expr1045" />
  130. <ScalarOperator ScalarString="CONVERT(bit,CASE WHEN isnull([m5db].[dbo].[AccountFeature].[FeatureStatusId] as [af].[FeatureStatusId],[m5db].[dbo].[Feature].[DefaultStatus] as [df].[DefaultStatus])=(0) THEN (0) ELSE CASE WHEN [m5db].[dbo].[access_UserLogin].[FailedLoginCount] as [ul].[FailedLoginCount] IS NULL THEN (0) ELSE CASE WHEN [m5db].[dbo].[access_UserLogin].[FailedLoginCount] as [ul].[FailedLoginCount]&gt;=CONVERT_IMPLICIT(int,isnull([m5db].[dbo].[AccountPolicy].[Value] as [mfl].[Value],[m5db].[dbo].[AccountPolicyField].[Default] as [mfld].[Default]),0) AND [m5db].[dbo].[access_UserLogin].[DateLocked] as [ul].[DateLocked]&lt;dateadd(hour, -CONVERT(int,isnull([m5db].[dbo].[AccountPolicy].[Value] as [ld].[Value],[m5db].[dbo].[AccountPolicyField].[Default] as [ldd].[Default]),0),getutcdate()) THEN (0) ELSE CASE WHEN [m5db].[dbo].[access_UserLogin].[FailedLoginCount] as [ul].[FailedLoginCount]&gt;=CONVERT_IMPLICIT(int,isnull([m5db].[dbo].[AccountPolicy].[Value] as [mfl].[Value],[m5db].[dbo].[AccountPolicyField].[Default] as [mfld].[Default]),0) THEN (1) ELSE (0) END END END END,0)">
  131. <Convert DataType="bit" Style="0" Implicit="false">
  132. <ScalarOperator>
  133. <IF>
  134. <Condition>
  135. <ScalarOperator>
  136. <Compare CompareOp="EQ">
  137. <ScalarOperator>
  138. <Intrinsic FunctionName="isnull">
  139. <ScalarOperator>
  140. <Identifier>
  141. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountFeature]" Alias="[af]" Column="FeatureStatusId" />
  142. </Identifier>
  143. </ScalarOperator>
  144. <ScalarOperator>
  145. <Identifier>
  146. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Feature]" Alias="[df]" Column="DefaultStatus" />
  147. </Identifier>
  148. </ScalarOperator>
  149. </Intrinsic>
  150. </ScalarOperator>
  151. <ScalarOperator>
  152. <Const ConstValue="(0)" />
  153. </ScalarOperator>
  154. </Compare>
  155. </ScalarOperator>
  156. </Condition>
  157. <Then>
  158. <ScalarOperator>
  159. <Const ConstValue="(0)" />
  160. </ScalarOperator>
  161. </Then>
  162. <Else>
  163. <ScalarOperator>
  164. <IF>
  165. <Condition>
  166. <ScalarOperator>
  167. <Compare CompareOp="IS">
  168. <ScalarOperator>
  169. <Identifier>
  170. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[access_UserLogin]" Alias="[ul]" Column="FailedLoginCount" />
  171. </Identifier>
  172. </ScalarOperator>
  173. <ScalarOperator>
  174. <Const ConstValue="NULL" />
  175. </ScalarOperator>
  176. </Compare>
  177. </ScalarOperator>
  178. </Condition>
  179. <Then>
  180. <ScalarOperator>
  181. <Const ConstValue="(0)" />
  182. </ScalarOperator>
  183. </Then>
  184. <Else>
  185. <ScalarOperator>
  186. <IF>
  187. <Condition>
  188. <ScalarOperator>
  189. <Logical Operation="AND">
  190. <ScalarOperator>
  191. <Compare CompareOp="GE">
  192. <ScalarOperator>
  193. <Identifier>
  194. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[access_UserLogin]" Alias="[ul]" Column="FailedLoginCount" />
  195. </Identifier>
  196. </ScalarOperator>
  197. <ScalarOperator>
  198. <Convert DataType="int" Style="0" Implicit="true">
  199. <ScalarOperator>
  200. <Intrinsic FunctionName="isnull">
  201. <ScalarOperator>
  202. <Identifier>
  203. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[mfl]" Column="Value" />
  204. </Identifier>
  205. </ScalarOperator>
  206. <ScalarOperator>
  207. <Identifier>
  208. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[mfld]" Column="Default" />
  209. </Identifier>
  210. </ScalarOperator>
  211. </Intrinsic>
  212. </ScalarOperator>
  213. </Convert>
  214. </ScalarOperator>
  215. </Compare>
  216. </ScalarOperator>
  217. <ScalarOperator>
  218. <Compare CompareOp="LT">
  219. <ScalarOperator>
  220. <Identifier>
  221. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[access_UserLogin]" Alias="[ul]" Column="DateLocked" />
  222. </Identifier>
  223. </ScalarOperator>
  224. <ScalarOperator>
  225. <Intrinsic FunctionName="dateadd">
  226. <ScalarOperator>
  227. <Const ConstValue="(6)" />
  228. </ScalarOperator>
  229. <ScalarOperator>
  230. <Arithmetic Operation="MINUS">
  231. <ScalarOperator>
  232. <Convert DataType="int" Style="0" Implicit="false">
  233. <ScalarOperator>
  234. <Intrinsic FunctionName="isnull">
  235. <ScalarOperator>
  236. <Identifier>
  237. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[ld]" Column="Value" />
  238. </Identifier>
  239. </ScalarOperator>
  240. <ScalarOperator>
  241. <Identifier>
  242. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[ldd]" Column="Default" />
  243. </Identifier>
  244. </ScalarOperator>
  245. </Intrinsic>
  246. </ScalarOperator>
  247. </Convert>
  248. </ScalarOperator>
  249. </Arithmetic>
  250. </ScalarOperator>
  251. <ScalarOperator>
  252. <Identifier>
  253. <ColumnReference Column="ConstExpr1058">
  254. <ScalarOperator>
  255. <Intrinsic FunctionName="getutcdate" />
  256. </ScalarOperator>
  257. </ColumnReference>
  258. </Identifier>
  259. </ScalarOperator>
  260. </Intrinsic>
  261. </ScalarOperator>
  262. </Compare>
  263. </ScalarOperator>
  264. </Logical>
  265. </ScalarOperator>
  266. </Condition>
  267. <Then>
  268. <ScalarOperator>
  269. <Const ConstValue="(0)" />
  270. </ScalarOperator>
  271. </Then>
  272. <Else>
  273. <ScalarOperator>
  274. <IF>
  275. <Condition>
  276. <ScalarOperator>
  277. <Compare CompareOp="GE">
  278. <ScalarOperator>
  279. <Identifier>
  280. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[access_UserLogin]" Alias="[ul]" Column="FailedLoginCount" />
  281. </Identifier>
  282. </ScalarOperator>
  283. <ScalarOperator>
  284. <Convert DataType="int" Style="0" Implicit="true">
  285. <ScalarOperator>
  286. <Intrinsic FunctionName="isnull">
  287. <ScalarOperator>
  288. <Identifier>
  289. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[mfl]" Column="Value" />
  290. </Identifier>
  291. </ScalarOperator>
  292. <ScalarOperator>
  293. <Identifier>
  294. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[mfld]" Column="Default" />
  295. </Identifier>
  296. </ScalarOperator>
  297. </Intrinsic>
  298. </ScalarOperator>
  299. </Convert>
  300. </ScalarOperator>
  301. </Compare>
  302. </ScalarOperator>
  303. </Condition>
  304. <Then>
  305. <ScalarOperator>
  306. <Const ConstValue="(1)" />
  307. </ScalarOperator>
  308. </Then>
  309. <Else>
  310. <ScalarOperator>
  311. <Const ConstValue="(0)" />
  312. </ScalarOperator>
  313. </Else>
  314. </IF>
  315. </ScalarOperator>
  316. </Else>
  317. </IF>
  318. </ScalarOperator>
  319. </Else>
  320. </IF>
  321. </ScalarOperator>
  322. </Else>
  323. </IF>
  324. </ScalarOperator>
  325. </Convert>
  326. </ScalarOperator>
  327. </DefinedValue>
  328. <DefinedValue>
  329. <ColumnReference Column="Expr1055" />
  330. <ScalarOperator ScalarString="CASE WHEN [m5db].[dbo].[Person].[Id] as [pe].[Id] IS NULL THEN N'Unassigned' ELSE CASE WHEN [m5db].[dbo].[Person].[FirstName] as [pe].[FirstName] IS NULL AND [m5db].[dbo].[Person].[LastName] as [pe].[LastName] IS NULL THEN CASE WHEN [m5db].[dbo].[Profile].[InternalCallerId] as [pr].[InternalCallerId] IS NOT NULL THEN [m5db].[dbo].[Profile].[InternalCallerId] as [pr].[InternalCallerId] ELSE N'' END ELSE ltrim(rtrim(CASE WHEN [m5db].[dbo].[Person].[FirstName] as [pe].[FirstName] IS NOT NULL THEN [m5db].[dbo].[Person].[FirstName] as [pe].[FirstName] ELSE N'' END+N' '+CASE WHEN [m5db].[dbo].[Person].[LastName] as [pe].[LastName] IS NOT NULL THEN [m5db].[dbo].[Person].[LastName] as [pe].[LastName] ELSE N'' END)) END END">
  331. <IF>
  332. <Condition>
  333. <ScalarOperator>
  334. <Compare CompareOp="IS">
  335. <ScalarOperator>
  336. <Identifier>
  337. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="Id" />
  338. </Identifier>
  339. </ScalarOperator>
  340. <ScalarOperator>
  341. <Const ConstValue="NULL" />
  342. </ScalarOperator>
  343. </Compare>
  344. </ScalarOperator>
  345. </Condition>
  346. <Then>
  347. <ScalarOperator>
  348. <Const ConstValue="N'Unassigned'" />
  349. </ScalarOperator>
  350. </Then>
  351. <Else>
  352. <ScalarOperator>
  353. <IF>
  354. <Condition>
  355. <ScalarOperator>
  356. <Logical Operation="AND">
  357. <ScalarOperator>
  358. <Compare CompareOp="IS">
  359. <ScalarOperator>
  360. <Identifier>
  361. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="FirstName" />
  362. </Identifier>
  363. </ScalarOperator>
  364. <ScalarOperator>
  365. <Const ConstValue="NULL" />
  366. </ScalarOperator>
  367. </Compare>
  368. </ScalarOperator>
  369. <ScalarOperator>
  370. <Compare CompareOp="IS">
  371. <ScalarOperator>
  372. <Identifier>
  373. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="LastName" />
  374. </Identifier>
  375. </ScalarOperator>
  376. <ScalarOperator>
  377. <Const ConstValue="NULL" />
  378. </ScalarOperator>
  379. </Compare>
  380. </ScalarOperator>
  381. </Logical>
  382. </ScalarOperator>
  383. </Condition>
  384. <Then>
  385. <ScalarOperator>
  386. <IF>
  387. <Condition>
  388. <ScalarOperator>
  389. <Compare CompareOp="IS NOT">
  390. <ScalarOperator>
  391. <Identifier>
  392. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="InternalCallerId" />
  393. </Identifier>
  394. </ScalarOperator>
  395. <ScalarOperator>
  396. <Const ConstValue="NULL" />
  397. </ScalarOperator>
  398. </Compare>
  399. </ScalarOperator>
  400. </Condition>
  401. <Then>
  402. <ScalarOperator>
  403. <Identifier>
  404. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="InternalCallerId" />
  405. </Identifier>
  406. </ScalarOperator>
  407. </Then>
  408. <Else>
  409. <ScalarOperator>
  410. <Const ConstValue="N''" />
  411. </ScalarOperator>
  412. </Else>
  413. </IF>
  414. </ScalarOperator>
  415. </Then>
  416. <Else>
  417. <ScalarOperator>
  418. <Intrinsic FunctionName="ltrim">
  419. <ScalarOperator>
  420. <Intrinsic FunctionName="rtrim">
  421. <ScalarOperator>
  422. <Arithmetic Operation="ADD">
  423. <ScalarOperator>
  424. <Arithmetic Operation="ADD">
  425. <ScalarOperator>
  426. <IF>
  427. <Condition>
  428. <ScalarOperator>
  429. <Compare CompareOp="IS NOT">
  430. <ScalarOperator>
  431. <Identifier>
  432. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="FirstName" />
  433. </Identifier>
  434. </ScalarOperator>
  435. <ScalarOperator>
  436. <Const ConstValue="NULL" />
  437. </ScalarOperator>
  438. </Compare>
  439. </ScalarOperator>
  440. </Condition>
  441. <Then>
  442. <ScalarOperator>
  443. <Identifier>
  444. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="FirstName" />
  445. </Identifier>
  446. </ScalarOperator>
  447. </Then>
  448. <Else>
  449. <ScalarOperator>
  450. <Const ConstValue="N''" />
  451. </ScalarOperator>
  452. </Else>
  453. </IF>
  454. </ScalarOperator>
  455. <ScalarOperator>
  456. <Const ConstValue="N' '" />
  457. </ScalarOperator>
  458. </Arithmetic>
  459. </ScalarOperator>
  460. <ScalarOperator>
  461. <IF>
  462. <Condition>
  463. <ScalarOperator>
  464. <Compare CompareOp="IS NOT">
  465. <ScalarOperator>
  466. <Identifier>
  467. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="LastName" />
  468. </Identifier>
  469. </ScalarOperator>
  470. <ScalarOperator>
  471. <Const ConstValue="NULL" />
  472. </ScalarOperator>
  473. </Compare>
  474. </ScalarOperator>
  475. </Condition>
  476. <Then>
  477. <ScalarOperator>
  478. <Identifier>
  479. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="LastName" />
  480. </Identifier>
  481. </ScalarOperator>
  482. </Then>
  483. <Else>
  484. <ScalarOperator>
  485. <Const ConstValue="N''" />
  486. </ScalarOperator>
  487. </Else>
  488. </IF>
  489. </ScalarOperator>
  490. </Arithmetic>
  491. </ScalarOperator>
  492. </Intrinsic>
  493. </ScalarOperator>
  494. </Intrinsic>
  495. </ScalarOperator>
  496. </Else>
  497. </IF>
  498. </ScalarOperator>
  499. </Else>
  500. </IF>
  501. </ScalarOperator>
  502. </DefinedValue>
  503. </DefinedValues>
  504. <RelOp AvgRowSize="1169" EstimateCPU="1.00705E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.23053" LogicalOp="Filter" NodeId="1" Parallel="false" PhysicalOp="Filter" EstimatedTotalSubtreeCost="0.462873">
  505. <OutputList>
  506. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  507. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  508. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  509. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="InternalCallerId" />
  510. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Extension" />
  511. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnId" />
  512. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnCountryId" />
  513. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  514. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="AccountId" />
  515. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="PlatformTypeId" />
  516. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Feature]" Alias="[df]" Column="DefaultStatus" />
  517. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountFeature]" Alias="[af]" Column="FeatureStatusId" />
  518. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[mfld]" Column="Default" />
  519. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[mfl]" Column="Value" />
  520. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[ldd]" Column="Default" />
  521. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[ld]" Column="Value" />
  522. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[access_UserLogin]" Alias="[ul]" Column="FailedLoginCount" />
  523. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[access_UserLogin]" Alias="[ul]" Column="DateLocked" />
  524. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="Id" />
  525. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="FirstName" />
  526. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="LastName" />
  527. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="BusinessEmail" />
  528. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pro]" Column="PartitionId" />
  529. <ColumnReference Column="Expr1056" />
  530. <ColumnReference Column="Expr1057" />
  531. </OutputList>
  532. <RunTimeInformation>
  533. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="1" ActualExecutions="1" />
  534. </RunTimeInformation>
  535. <Filter StartupExpression="false">
  536. <RelOp AvgRowSize="1169" EstimateCPU="6.19039E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.48095" LogicalOp="Left Outer Join" NodeId="2" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.462872">
  537. <OutputList>
  538. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  539. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  540. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  541. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="InternalCallerId" />
  542. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Extension" />
  543. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnId" />
  544. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnCountryId" />
  545. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  546. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="AccountId" />
  547. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="PlatformTypeId" />
  548. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Feature]" Alias="[df]" Column="DefaultStatus" />
  549. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountFeature]" Alias="[af]" Column="FeatureStatusId" />
  550. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[mfld]" Column="Default" />
  551. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[mfl]" Column="Value" />
  552. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[ldd]" Column="Default" />
  553. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[ld]" Column="Value" />
  554. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[access_UserLogin]" Alias="[ul]" Column="FailedLoginCount" />
  555. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[access_UserLogin]" Alias="[ul]" Column="DateLocked" />
  556. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="Id" />
  557. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="FirstName" />
  558. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="LastName" />
  559. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="BusinessEmail" />
  560. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pro]" Column="PartitionId" />
  561. <ColumnReference Column="Expr1056" />
  562. <ColumnReference Column="Expr1057" />
  563. </OutputList>
  564. <RunTimeInformation>
  565. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="1" ActualExecutions="1" />
  566. </RunTimeInformation>
  567. <NestedLoops Optimized="true">
  568. <OuterReferences>
  569. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  570. </OuterReferences>
  571. <RelOp AvgRowSize="1164" EstimateCPU="6.19039E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.48095" LogicalOp="Left Outer Join" NodeId="4" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.458878">
  572. <OutputList>
  573. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  574. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  575. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  576. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="InternalCallerId" />
  577. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Extension" />
  578. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnId" />
  579. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnCountryId" />
  580. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  581. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="AccountId" />
  582. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="PlatformTypeId" />
  583. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Feature]" Alias="[df]" Column="DefaultStatus" />
  584. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountFeature]" Alias="[af]" Column="FeatureStatusId" />
  585. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[mfld]" Column="Default" />
  586. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[mfl]" Column="Value" />
  587. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[ldd]" Column="Default" />
  588. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[ld]" Column="Value" />
  589. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[access_UserLogin]" Alias="[ul]" Column="FailedLoginCount" />
  590. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[access_UserLogin]" Alias="[ul]" Column="DateLocked" />
  591. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="Id" />
  592. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="FirstName" />
  593. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="LastName" />
  594. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="BusinessEmail" />
  595. <ColumnReference Column="Expr1056" />
  596. <ColumnReference Column="Expr1057" />
  597. </OutputList>
  598. <RunTimeInformation>
  599. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="1" ActualExecutions="1" />
  600. </RunTimeInformation>
  601. <NestedLoops Optimized="false">
  602. <OuterReferences>
  603. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="Id" />
  604. </OuterReferences>
  605. <RelOp AvgRowSize="703" EstimateCPU="6.19039E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.48095" LogicalOp="Left Outer Join" NodeId="5" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.454885">
  606. <OutputList>
  607. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  608. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  609. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  610. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="InternalCallerId" />
  611. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Extension" />
  612. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnId" />
  613. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnCountryId" />
  614. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="Id" />
  615. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  616. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="AccountId" />
  617. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="PlatformTypeId" />
  618. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Feature]" Alias="[df]" Column="DefaultStatus" />
  619. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountFeature]" Alias="[af]" Column="FeatureStatusId" />
  620. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[mfld]" Column="Default" />
  621. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[mfl]" Column="Value" />
  622. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[ldd]" Column="Default" />
  623. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[ld]" Column="Value" />
  624. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[access_UserLogin]" Alias="[ul]" Column="FailedLoginCount" />
  625. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[access_UserLogin]" Alias="[ul]" Column="DateLocked" />
  626. <ColumnReference Column="Expr1056" />
  627. <ColumnReference Column="Expr1057" />
  628. </OutputList>
  629. <RunTimeInformation>
  630. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="1" ActualExecutions="1" />
  631. </RunTimeInformation>
  632. <NestedLoops Optimized="false">
  633. <OuterReferences>
  634. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Account]" Alias="[a]" Column="Id" />
  635. <ColumnReference Column="Expr1067" />
  636. </OuterReferences>
  637. <RelOp AvgRowSize="707" EstimateCPU="6.19039E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.48095" LogicalOp="Left Outer Join" NodeId="6" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.450917">
  638. <OutputList>
  639. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  640. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  641. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  642. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="InternalCallerId" />
  643. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Extension" />
  644. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnId" />
  645. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnCountryId" />
  646. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="Id" />
  647. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  648. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="AccountId" />
  649. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="PlatformTypeId" />
  650. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Account]" Alias="[a]" Column="Id" />
  651. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Feature]" Alias="[df]" Column="DefaultStatus" />
  652. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountFeature]" Alias="[af]" Column="FeatureStatusId" />
  653. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[mfld]" Column="Default" />
  654. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[mfl]" Column="Value" />
  655. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[ldd]" Column="Default" />
  656. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[ld]" Column="Value" />
  657. <ColumnReference Column="Expr1056" />
  658. <ColumnReference Column="Expr1057" />
  659. <ColumnReference Column="Expr1067" />
  660. </OutputList>
  661. <RunTimeInformation>
  662. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="1" ActualExecutions="1" />
  663. </RunTimeInformation>
  664. <NestedLoops Optimized="false">
  665. <OuterReferences>
  666. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="PersonId" />
  667. </OuterReferences>
  668. <RelOp AvgRowSize="707" EstimateCPU="6.19039E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.48095" LogicalOp="Inner Join" NodeId="7" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.446924">
  669. <OutputList>
  670. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  671. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="PersonId" />
  672. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  673. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  674. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="InternalCallerId" />
  675. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Extension" />
  676. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnId" />
  677. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnCountryId" />
  678. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  679. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="AccountId" />
  680. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="PlatformTypeId" />
  681. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Account]" Alias="[a]" Column="Id" />
  682. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Feature]" Alias="[df]" Column="DefaultStatus" />
  683. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountFeature]" Alias="[af]" Column="FeatureStatusId" />
  684. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[mfld]" Column="Default" />
  685. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[mfl]" Column="Value" />
  686. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[ldd]" Column="Default" />
  687. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[ld]" Column="Value" />
  688. <ColumnReference Column="Expr1056" />
  689. <ColumnReference Column="Expr1057" />
  690. <ColumnReference Column="Expr1067" />
  691. </OutputList>
  692. <RunTimeInformation>
  693. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="1" ActualExecutions="1" />
  694. </RunTimeInformation>
  695. <NestedLoops Optimized="false">
  696. <PassThru>
  697. <ScalarOperator ScalarString="[IsBaseRow1031] IS NULL">
  698. <Compare CompareOp="IS">
  699. <ScalarOperator>
  700. <Identifier>
  701. <ColumnReference Column="IsBaseRow1031" />
  702. </Identifier>
  703. </ScalarOperator>
  704. <ScalarOperator>
  705. <Const ConstValue="NULL" />
  706. </ScalarOperator>
  707. </Compare>
  708. </ScalarOperator>
  709. </PassThru>
  710. <OuterReferences>
  711. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[ld]" Column="Id" />
  712. </OuterReferences>
  713. <RelOp AvgRowSize="609" EstimateCPU="6.19039E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.48095" LogicalOp="Left Outer Join" NodeId="8" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.442931">
  714. <OutputList>
  715. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  716. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="PersonId" />
  717. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  718. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  719. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="InternalCallerId" />
  720. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Extension" />
  721. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnId" />
  722. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnCountryId" />
  723. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  724. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="AccountId" />
  725. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="PlatformTypeId" />
  726. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Account]" Alias="[a]" Column="Id" />
  727. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Feature]" Alias="[df]" Column="DefaultStatus" />
  728. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountFeature]" Alias="[af]" Column="FeatureStatusId" />
  729. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[mfld]" Column="Default" />
  730. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[mfl]" Column="Value" />
  731. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[ldd]" Column="Default" />
  732. <ColumnReference Column="IsBaseRow1031" />
  733. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[ld]" Column="Id" />
  734. <ColumnReference Column="Expr1056" />
  735. <ColumnReference Column="Expr1057" />
  736. <ColumnReference Column="Expr1067" />
  737. </OutputList>
  738. <RunTimeInformation>
  739. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="1" ActualExecutions="1" />
  740. </RunTimeInformation>
  741. <NestedLoops Optimized="false">
  742. <OuterReferences>
  743. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Account]" Alias="[a]" Column="Id" />
  744. </OuterReferences>
  745. <RelOp AvgRowSize="605" EstimateCPU="6.19039E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.48095" LogicalOp="Inner Join" NodeId="9" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.438945">
  746. <OutputList>
  747. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  748. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="PersonId" />
  749. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  750. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  751. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="InternalCallerId" />
  752. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Extension" />
  753. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnId" />
  754. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnCountryId" />
  755. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  756. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="AccountId" />
  757. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="PlatformTypeId" />
  758. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Account]" Alias="[a]" Column="Id" />
  759. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Feature]" Alias="[df]" Column="DefaultStatus" />
  760. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountFeature]" Alias="[af]" Column="FeatureStatusId" />
  761. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[mfld]" Column="Default" />
  762. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[mfl]" Column="Value" />
  763. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[ldd]" Column="Default" />
  764. <ColumnReference Column="Expr1056" />
  765. <ColumnReference Column="Expr1057" />
  766. <ColumnReference Column="Expr1067" />
  767. </OutputList>
  768. <RunTimeInformation>
  769. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="1" ActualExecutions="1" />
  770. </RunTimeInformation>
  771. <NestedLoops Optimized="false">
  772. <PassThru>
  773. <ScalarOperator ScalarString="[IsBaseRow1027] IS NULL">
  774. <Compare CompareOp="IS">
  775. <ScalarOperator>
  776. <Identifier>
  777. <ColumnReference Column="IsBaseRow1027" />
  778. </Identifier>
  779. </ScalarOperator>
  780. <ScalarOperator>
  781. <Const ConstValue="NULL" />
  782. </ScalarOperator>
  783. </Compare>
  784. </ScalarOperator>
  785. </PassThru>
  786. <OuterReferences>
  787. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[mfl]" Column="Id" />
  788. </OuterReferences>
  789. <RelOp AvgRowSize="507" EstimateCPU="6.19039E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.48095" LogicalOp="Left Outer Join" NodeId="10" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.434953">
  790. <OutputList>
  791. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  792. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="PersonId" />
  793. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  794. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  795. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="InternalCallerId" />
  796. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Extension" />
  797. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnId" />
  798. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnCountryId" />
  799. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  800. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="AccountId" />
  801. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="PlatformTypeId" />
  802. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Account]" Alias="[a]" Column="Id" />
  803. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Feature]" Alias="[df]" Column="DefaultStatus" />
  804. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountFeature]" Alias="[af]" Column="FeatureStatusId" />
  805. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[mfld]" Column="Default" />
  806. <ColumnReference Column="IsBaseRow1027" />
  807. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[mfl]" Column="Id" />
  808. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[ldd]" Column="Default" />
  809. <ColumnReference Column="Expr1056" />
  810. <ColumnReference Column="Expr1057" />
  811. <ColumnReference Column="Expr1067" />
  812. </OutputList>
  813. <RunTimeInformation>
  814. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="1" ActualExecutions="1" />
  815. </RunTimeInformation>
  816. <NestedLoops Optimized="false">
  817. <OuterReferences>
  818. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Account]" Alias="[a]" Column="Id" />
  819. </OuterReferences>
  820. <RelOp AvgRowSize="503" EstimateCPU="6.19039E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.48095" LogicalOp="Left Outer Join" NodeId="11" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.430967">
  821. <OutputList>
  822. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  823. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="PersonId" />
  824. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  825. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  826. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="InternalCallerId" />
  827. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Extension" />
  828. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnId" />
  829. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnCountryId" />
  830. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  831. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="AccountId" />
  832. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="PlatformTypeId" />
  833. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Account]" Alias="[a]" Column="Id" />
  834. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Feature]" Alias="[df]" Column="DefaultStatus" />
  835. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountFeature]" Alias="[af]" Column="FeatureStatusId" />
  836. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[mfld]" Column="Default" />
  837. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[ldd]" Column="Default" />
  838. <ColumnReference Column="Expr1056" />
  839. <ColumnReference Column="Expr1057" />
  840. <ColumnReference Column="Expr1067" />
  841. </OutputList>
  842. <RunTimeInformation>
  843. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="1" ActualExecutions="1" />
  844. </RunTimeInformation>
  845. <NestedLoops Optimized="false">
  846. <OuterReferences>
  847. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Account]" Alias="[a]" Column="Id" />
  848. </OuterReferences>
  849. <RelOp AvgRowSize="499" EstimateCPU="6.19039E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.48095" LogicalOp="Inner Join" NodeId="12" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.427602">
  850. <OutputList>
  851. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  852. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="PersonId" />
  853. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  854. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  855. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="InternalCallerId" />
  856. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Extension" />
  857. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnId" />
  858. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnCountryId" />
  859. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  860. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="AccountId" />
  861. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="PlatformTypeId" />
  862. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Account]" Alias="[a]" Column="Id" />
  863. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Feature]" Alias="[df]" Column="DefaultStatus" />
  864. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[mfld]" Column="Default" />
  865. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[ldd]" Column="Default" />
  866. <ColumnReference Column="Expr1056" />
  867. <ColumnReference Column="Expr1057" />
  868. <ColumnReference Column="Expr1067" />
  869. </OutputList>
  870. <RunTimeInformation>
  871. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="1" ActualExecutions="1" />
  872. </RunTimeInformation>
  873. <NestedLoops Optimized="false">
  874. <RelOp AvgRowSize="11" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="13" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="26">
  875. <OutputList>
  876. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Feature]" Alias="[df]" Column="DefaultStatus" />
  877. </OutputList>
  878. <RunTimeInformation>
  879. <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
  880. </RunTimeInformation>
  881. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  882. <DefinedValues>
  883. <DefinedValue>
  884. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Feature]" Alias="[df]" Column="DefaultStatus" />
  885. </DefinedValue>
  886. </DefinedValues>
  887. <Object Database="[m5db]" Schema="[dbo]" Table="[Feature]" Index="[PK_Feature]" Alias="[df]" IndexKind="Clustered" />
  888. <SeekPredicates>
  889. <SeekPredicateNew>
  890. <SeekKeys>
  891. <Prefix ScanType="EQ">
  892. <RangeColumns>
  893. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Feature]" Alias="[df]" Column="Id" />
  894. </RangeColumns>
  895. <RangeExpressions>
  896. <ScalarOperator ScalarString="(13)">
  897. <Const ConstValue="(13)" />
  898. </ScalarOperator>
  899. </RangeExpressions>
  900. </Prefix>
  901. </SeekKeys>
  902. </SeekPredicateNew>
  903. </SeekPredicates>
  904. </IndexScan>
  905. </RelOp>
  906. <RelOp AvgRowSize="495" EstimateCPU="6.19039E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.48095" LogicalOp="Inner Join" NodeId="14" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.424313">
  907. <OutputList>
  908. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  909. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="PersonId" />
  910. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  911. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  912. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="InternalCallerId" />
  913. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Extension" />
  914. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnId" />
  915. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnCountryId" />
  916. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  917. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="AccountId" />
  918. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="PlatformTypeId" />
  919. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Account]" Alias="[a]" Column="Id" />
  920. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[mfld]" Column="Default" />
  921. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[ldd]" Column="Default" />
  922. <ColumnReference Column="Expr1056" />
  923. <ColumnReference Column="Expr1057" />
  924. <ColumnReference Column="Expr1067" />
  925. </OutputList>
  926. <RunTimeInformation>
  927. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="1" ActualExecutions="1" />
  928. </RunTimeInformation>
  929. <NestedLoops Optimized="false">
  930. <RelOp AvgRowSize="111" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="15" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="40">
  931. <OutputList>
  932. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[mfld]" Column="Default" />
  933. </OutputList>
  934. <RunTimeInformation>
  935. <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
  936. </RunTimeInformation>
  937. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  938. <DefinedValues>
  939. <DefinedValue>
  940. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[mfld]" Column="Default" />
  941. </DefinedValue>
  942. </DefinedValues>
  943. <Object Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Index="[PK_AccountPolicyField]" Alias="[mfld]" IndexKind="Clustered" />
  944. <SeekPredicates>
  945. <SeekPredicateNew>
  946. <SeekKeys>
  947. <Prefix ScanType="EQ">
  948. <RangeColumns>
  949. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[mfld]" Column="Id" />
  950. </RangeColumns>
  951. <RangeExpressions>
  952. <ScalarOperator ScalarString="(13001)">
  953. <Const ConstValue="(13001)" />
  954. </ScalarOperator>
  955. </RangeExpressions>
  956. </Prefix>
  957. </SeekKeys>
  958. </SeekPredicateNew>
  959. </SeekPredicates>
  960. </IndexScan>
  961. </RelOp>
  962. <RelOp AvgRowSize="392" EstimateCPU="6.19039E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.48095" LogicalOp="Inner Join" NodeId="16" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.421023">
  963. <OutputList>
  964. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  965. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="PersonId" />
  966. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  967. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  968. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="InternalCallerId" />
  969. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Extension" />
  970. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnId" />
  971. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnCountryId" />
  972. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  973. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="AccountId" />
  974. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="PlatformTypeId" />
  975. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Account]" Alias="[a]" Column="Id" />
  976. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[ldd]" Column="Default" />
  977. <ColumnReference Column="Expr1056" />
  978. <ColumnReference Column="Expr1057" />
  979. <ColumnReference Column="Expr1067" />
  980. </OutputList>
  981. <RunTimeInformation>
  982. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="1" ActualExecutions="1" />
  983. </RunTimeInformation>
  984. <NestedLoops Optimized="false">
  985. <RelOp AvgRowSize="111" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="17" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="40">
  986. <OutputList>
  987. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[ldd]" Column="Default" />
  988. </OutputList>
  989. <RunTimeInformation>
  990. <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
  991. </RunTimeInformation>
  992. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  993. <DefinedValues>
  994. <DefinedValue>
  995. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[ldd]" Column="Default" />
  996. </DefinedValue>
  997. </DefinedValues>
  998. <Object Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Index="[PK_AccountPolicyField]" Alias="[ldd]" IndexKind="Clustered" />
  999. <SeekPredicates>
  1000. <SeekPredicateNew>
  1001. <SeekKeys>
  1002. <Prefix ScanType="EQ">
  1003. <RangeColumns>
  1004. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicyField]" Alias="[ldd]" Column="Id" />
  1005. </RangeColumns>
  1006. <RangeExpressions>
  1007. <ScalarOperator ScalarString="(13002)">
  1008. <Const ConstValue="(13002)" />
  1009. </ScalarOperator>
  1010. </RangeExpressions>
  1011. </Prefix>
  1012. </SeekKeys>
  1013. </SeekPredicateNew>
  1014. </SeekPredicates>
  1015. </IndexScan>
  1016. </RelOp>
  1017. <RelOp AvgRowSize="290" EstimateCPU="6.19039E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.48095" LogicalOp="Inner Join" NodeId="18" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.417734">
  1018. <OutputList>
  1019. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  1020. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="PersonId" />
  1021. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  1022. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  1023. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="InternalCallerId" />
  1024. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Extension" />
  1025. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnId" />
  1026. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnCountryId" />
  1027. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  1028. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="AccountId" />
  1029. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="PlatformTypeId" />
  1030. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Account]" Alias="[a]" Column="Id" />
  1031. <ColumnReference Column="Expr1056" />
  1032. <ColumnReference Column="Expr1057" />
  1033. <ColumnReference Column="Expr1067" />
  1034. </OutputList>
  1035. <RunTimeInformation>
  1036. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="1" ActualExecutions="1" />
  1037. </RunTimeInformation>
  1038. <NestedLoops Optimized="false">
  1039. <RelOp AvgRowSize="9" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="19" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="11720">
  1040. <OutputList />
  1041. <RunTimeInformation>
  1042. <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
  1043. </RunTimeInformation>
  1044. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  1045. <DefinedValues />
  1046. <Object Database="[m5db]" Schema="[dbo]" Table="[Account]" Index="[PK_Account]" Alias="[ac]" IndexKind="Clustered" />
  1047. <SeekPredicates>
  1048. <SeekPredicateNew>
  1049. <SeekKeys>
  1050. <Prefix ScanType="EQ">
  1051. <RangeColumns>
  1052. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Account]" Alias="[ac]" Column="Id" />
  1053. </RangeColumns>
  1054. <RangeExpressions>
  1055. <ScalarOperator ScalarString="[@AccountId]">
  1056. <Identifier>
  1057. <ColumnReference Column="@AccountId" />
  1058. </Identifier>
  1059. </ScalarOperator>
  1060. </RangeExpressions>
  1061. </Prefix>
  1062. </SeekKeys>
  1063. </SeekPredicateNew>
  1064. </SeekPredicates>
  1065. </IndexScan>
  1066. </RelOp>
  1067. <RelOp AvgRowSize="290" EstimateCPU="6.19039E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.48095" LogicalOp="Inner Join" NodeId="20" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.414445">
  1068. <OutputList>
  1069. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  1070. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="PersonId" />
  1071. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  1072. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  1073. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="InternalCallerId" />
  1074. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Extension" />
  1075. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnId" />
  1076. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnCountryId" />
  1077. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  1078. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="AccountId" />
  1079. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="PlatformTypeId" />
  1080. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Account]" Alias="[a]" Column="Id" />
  1081. <ColumnReference Column="Expr1056" />
  1082. <ColumnReference Column="Expr1057" />
  1083. <ColumnReference Column="Expr1067" />
  1084. </OutputList>
  1085. <RunTimeInformation>
  1086. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="1" ActualExecutions="1" />
  1087. </RunTimeInformation>
  1088. <NestedLoops Optimized="false">
  1089. <RelOp AvgRowSize="9" 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="2">
  1090. <OutputList />
  1091. <RunTimeInformation>
  1092. <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
  1093. </RunTimeInformation>
  1094. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  1095. <DefinedValues />
  1096. <Object Database="[m5db]" Schema="[dbo]" Table="[ProfileStatus]" Index="[PK_ProfileStatus]" Alias="[prn]" IndexKind="Clustered" />
  1097. <SeekPredicates>
  1098. <SeekPredicateNew>
  1099. <SeekKeys>
  1100. <Prefix ScanType="EQ">
  1101. <RangeColumns>
  1102. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[ProfileStatus]" Alias="[prn]" Column="Id" />
  1103. </RangeColumns>
  1104. <RangeExpressions>
  1105. <ScalarOperator ScalarString="(0)">
  1106. <Const ConstValue="(0)" />
  1107. </ScalarOperator>
  1108. </RangeExpressions>
  1109. </Prefix>
  1110. </SeekKeys>
  1111. </SeekPredicateNew>
  1112. </SeekPredicates>
  1113. </IndexScan>
  1114. </RelOp>
  1115. <RelOp AvgRowSize="290" EstimateCPU="6.19039E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.48095" LogicalOp="Inner Join" NodeId="22" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.411155">
  1116. <OutputList>
  1117. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  1118. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="PersonId" />
  1119. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  1120. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  1121. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="InternalCallerId" />
  1122. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Extension" />
  1123. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnId" />
  1124. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnCountryId" />
  1125. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  1126. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="AccountId" />
  1127. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="PlatformTypeId" />
  1128. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Account]" Alias="[a]" Column="Id" />
  1129. <ColumnReference Column="Expr1056" />
  1130. <ColumnReference Column="Expr1057" />
  1131. <ColumnReference Column="Expr1067" />
  1132. </OutputList>
  1133. <RunTimeInformation>
  1134. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="1" ActualExecutions="1" />
  1135. </RunTimeInformation>
  1136. <NestedLoops Optimized="false">
  1137. <OuterReferences>
  1138. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  1139. </OuterReferences>
  1140. <RelOp AvgRowSize="290" EstimateCPU="6.19039E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.48095" LogicalOp="Inner Join" NodeId="23" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.407789">
  1141. <OutputList>
  1142. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  1143. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="PersonId" />
  1144. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  1145. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  1146. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="InternalCallerId" />
  1147. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Extension" />
  1148. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnId" />
  1149. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnCountryId" />
  1150. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  1151. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="AccountId" />
  1152. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="PlatformTypeId" />
  1153. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Account]" Alias="[a]" Column="Id" />
  1154. <ColumnReference Column="Expr1056" />
  1155. <ColumnReference Column="Expr1057" />
  1156. <ColumnReference Column="Expr1067" />
  1157. </OutputList>
  1158. <RunTimeInformation>
  1159. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="1" ActualExecutions="1" />
  1160. </RunTimeInformation>
  1161. <NestedLoops Optimized="false">
  1162. <OuterReferences>
  1163. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="PlatformTypeId" />
  1164. </OuterReferences>
  1165. <RelOp AvgRowSize="290" EstimateCPU="0.000156818" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.48095" LogicalOp="Inner Join" NodeId="24" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.404423">
  1166. <OutputList>
  1167. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  1168. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="PersonId" />
  1169. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  1170. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  1171. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="InternalCallerId" />
  1172. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Extension" />
  1173. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnId" />
  1174. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnCountryId" />
  1175. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  1176. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="AccountId" />
  1177. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="PlatformTypeId" />
  1178. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Account]" Alias="[a]" Column="Id" />
  1179. <ColumnReference Column="Expr1056" />
  1180. <ColumnReference Column="Expr1057" />
  1181. <ColumnReference Column="Expr1067" />
  1182. </OutputList>
  1183. <RunTimeInformation>
  1184. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="1" ActualExecutions="1" />
  1185. </RunTimeInformation>
  1186. <NestedLoops Optimized="false" WithUnorderedPrefetch="true">
  1187. <OuterReferences>
  1188. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="Id" />
  1189. <ColumnReference Column="Expr1074" />
  1190. </OuterReferences>
  1191. <RelOp AvgRowSize="294" EstimateCPU="3.75162E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="37.5162" LogicalOp="Compute Scalar" NodeId="26" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.39521">
  1192. <OutputList>
  1193. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  1194. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="PersonId" />
  1195. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  1196. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  1197. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="InternalCallerId" />
  1198. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Extension" />
  1199. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnId" />
  1200. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnCountryId" />
  1201. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  1202. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="AccountId" />
  1203. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="Id" />
  1204. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="PlatformTypeId" />
  1205. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Account]" Alias="[a]" Column="Id" />
  1206. <ColumnReference Column="Expr1056" />
  1207. <ColumnReference Column="Expr1057" />
  1208. <ColumnReference Column="Expr1067" />
  1209. </OutputList>
  1210. <ComputeScalar>
  1211. <DefinedValues>
  1212. <DefinedValue>
  1213. <ColumnReference Column="Expr1057" />
  1214. <ScalarOperator ScalarString="CASE WHEN [m5db].[dbo].[Cluster].[PlatformTypeId] as [cl].[PlatformTypeId]=(7) THEN (0) ELSE (1) END">
  1215. <IF>
  1216. <Condition>
  1217. <ScalarOperator>
  1218. <Compare CompareOp="EQ">
  1219. <ScalarOperator>
  1220. <Identifier>
  1221. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="PlatformTypeId" />
  1222. </Identifier>
  1223. </ScalarOperator>
  1224. <ScalarOperator>
  1225. <Const ConstValue="(7)" />
  1226. </ScalarOperator>
  1227. </Compare>
  1228. </ScalarOperator>
  1229. </Condition>
  1230. <Then>
  1231. <ScalarOperator>
  1232. <Const ConstValue="(0)" />
  1233. </ScalarOperator>
  1234. </Then>
  1235. <Else>
  1236. <ScalarOperator>
  1237. <Const ConstValue="(1)" />
  1238. </ScalarOperator>
  1239. </Else>
  1240. </IF>
  1241. </ScalarOperator>
  1242. </DefinedValue>
  1243. </DefinedValues>
  1244. <RelOp AvgRowSize="293" EstimateCPU="0.000156818" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="37.5162" LogicalOp="Inner Join" NodeId="27" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.395207">
  1245. <OutputList>
  1246. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  1247. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="PersonId" />
  1248. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  1249. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  1250. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="InternalCallerId" />
  1251. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Extension" />
  1252. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnId" />
  1253. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnCountryId" />
  1254. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  1255. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="AccountId" />
  1256. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="Id" />
  1257. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="PlatformTypeId" />
  1258. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Account]" Alias="[a]" Column="Id" />
  1259. <ColumnReference Column="Expr1056" />
  1260. <ColumnReference Column="Expr1067" />
  1261. </OutputList>
  1262. <RunTimeInformation>
  1263. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="1" ActualExecutions="1" />
  1264. </RunTimeInformation>
  1265. <NestedLoops Optimized="false">
  1266. <OuterReferences>
  1267. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Partition]" Alias="[pt]" Column="ClusterId" />
  1268. </OuterReferences>
  1269. <RelOp AvgRowSize="289" EstimateCPU="0.000170098" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="37.5162" LogicalOp="Inner Join" NodeId="28" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.373623">
  1270. <OutputList>
  1271. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  1272. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="PersonId" />
  1273. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  1274. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  1275. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="InternalCallerId" />
  1276. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Extension" />
  1277. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnId" />
  1278. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnCountryId" />
  1279. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Partition]" Alias="[pt]" Column="ClusterId" />
  1280. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  1281. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="AccountId" />
  1282. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Account]" Alias="[a]" Column="Id" />
  1283. <ColumnReference Column="Expr1056" />
  1284. <ColumnReference Column="Expr1067" />
  1285. </OutputList>
  1286. <RunTimeInformation>
  1287. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="1" ActualExecutions="1" />
  1288. </RunTimeInformation>
  1289. <NestedLoops Optimized="false" WithUnorderedPrefetch="true">
  1290. <OuterReferences>
  1291. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Partition]" Alias="[pt]" Column="AccountId" />
  1292. <ColumnReference Column="Expr1073" />
  1293. </OuterReferences>
  1294. <RelOp AvgRowSize="289" EstimateCPU="0.000224276" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="40.6934" LogicalOp="Inner Join" NodeId="30" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.247281">
  1295. <OutputList>
  1296. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  1297. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="PersonId" />
  1298. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  1299. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  1300. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="InternalCallerId" />
  1301. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Extension" />
  1302. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnId" />
  1303. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnCountryId" />
  1304. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Partition]" Alias="[pt]" Column="ClusterId" />
  1305. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Partition]" Alias="[pt]" Column="AccountId" />
  1306. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  1307. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="AccountId" />
  1308. <ColumnReference Column="Expr1056" />
  1309. <ColumnReference Column="Expr1067" />
  1310. </OutputList>
  1311. <RunTimeInformation>
  1312. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="1" ActualExecutions="1" />
  1313. </RunTimeInformation>
  1314. <NestedLoops Optimized="false" WithUnorderedPrefetch="true">
  1315. <OuterReferences>
  1316. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="PartitionId" />
  1317. <ColumnReference Column="Expr1072" />
  1318. </OuterReferences>
  1319. <RelOp AvgRowSize="285" EstimateCPU="5.36546E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="53.6546" LogicalOp="Compute Scalar" NodeId="32" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.085182">
  1320. <OutputList>
  1321. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  1322. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="PartitionId" />
  1323. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="PersonId" />
  1324. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  1325. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  1326. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="InternalCallerId" />
  1327. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Extension" />
  1328. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnId" />
  1329. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnCountryId" />
  1330. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  1331. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="AccountId" />
  1332. <ColumnReference Column="Expr1056" />
  1333. <ColumnReference Column="Expr1067" />
  1334. </OutputList>
  1335. <ComputeScalar>
  1336. <DefinedValues>
  1337. <DefinedValue>
  1338. <ColumnReference Column="Expr1056" />
  1339. <ScalarOperator ScalarString="CASE WHEN [m5db].[dbo].[Profile].[InternalCallerId] as [pr].[InternalCallerId] IS NOT NULL THEN [m5db].[dbo].[Profile].[InternalCallerId] as [pr].[InternalCallerId] ELSE CONVERT_IMPLICIT(nvarchar(100),[m5db].[dbo].[Profile].[TnId] as [pr].[TnId],0) END">
  1340. <IF>
  1341. <Condition>
  1342. <ScalarOperator>
  1343. <Compare CompareOp="IS NOT">
  1344. <ScalarOperator>
  1345. <Identifier>
  1346. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="InternalCallerId" />
  1347. </Identifier>
  1348. </ScalarOperator>
  1349. <ScalarOperator>
  1350. <Const ConstValue="NULL" />
  1351. </ScalarOperator>
  1352. </Compare>
  1353. </ScalarOperator>
  1354. </Condition>
  1355. <Then>
  1356. <ScalarOperator>
  1357. <Identifier>
  1358. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="InternalCallerId" />
  1359. </Identifier>
  1360. </ScalarOperator>
  1361. </Then>
  1362. <Else>
  1363. <ScalarOperator>
  1364. <Convert DataType="nvarchar" Length="200" Style="0" Implicit="true">
  1365. <ScalarOperator>
  1366. <Identifier>
  1367. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnId" />
  1368. </Identifier>
  1369. </ScalarOperator>
  1370. </Convert>
  1371. </ScalarOperator>
  1372. </Else>
  1373. </IF>
  1374. </ScalarOperator>
  1375. </DefinedValue>
  1376. <DefinedValue>
  1377. <ColumnReference Column="Expr1067" />
  1378. <ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(15),[m5db].[dbo].[Profile].[TnId] as [pr].[TnId],0)">
  1379. <Convert DataType="nvarchar" Length="30" Style="0" Implicit="true">
  1380. <ScalarOperator>
  1381. <Identifier>
  1382. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnId" />
  1383. </Identifier>
  1384. </ScalarOperator>
  1385. </Convert>
  1386. </ScalarOperator>
  1387. </DefinedValue>
  1388. </DefinedValues>
  1389. <RelOp AvgRowSize="173" EstimateCPU="0.000225251" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="53.8877" LogicalOp="Inner Join" NodeId="33" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0851292">
  1390. <OutputList>
  1391. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  1392. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="PartitionId" />
  1393. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="PersonId" />
  1394. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  1395. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  1396. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="InternalCallerId" />
  1397. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Extension" />
  1398. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnId" />
  1399. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnCountryId" />
  1400. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  1401. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="AccountId" />
  1402. </OutputList>
  1403. <RunTimeInformation>
  1404. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="1" ActualExecutions="1" />
  1405. </RunTimeInformation>
  1406. <NestedLoops Optimized="true" WithUnorderedPrefetch="true">
  1407. <OuterReferences>
  1408. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  1409. <ColumnReference Column="Expr1071" />
  1410. </OuterReferences>
  1411. <RelOp AvgRowSize="27" EstimateCPU="0.000225251" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="53.8877" LogicalOp="Inner Join" NodeId="36" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0148664">
  1412. <OutputList>
  1413. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  1414. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  1415. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  1416. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  1417. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="AccountId" />
  1418. </OutputList>
  1419. <RunTimeInformation>
  1420. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="1" ActualExecutions="1" />
  1421. </RunTimeInformation>
  1422. <NestedLoops Optimized="false">
  1423. <OuterReferences>
  1424. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  1425. </OuterReferences>
  1426. <RelOp AvgRowSize="15" EstimateCPU="1.36839E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3.27367" LogicalOp="Inner Join" NodeId="38" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00694185">
  1427. <OutputList>
  1428. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  1429. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="AccountId" />
  1430. </OutputList>
  1431. <RunTimeInformation>
  1432. <RunTimeCountersPerThread Thread="0" ActualRows="474" ActualEndOfScans="1" ActualExecutions="1" />
  1433. </RunTimeInformation>
  1434. <NestedLoops Optimized="false">
  1435. <OuterReferences>
  1436. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  1437. </OuterReferences>
  1438. <RelOp AvgRowSize="15" EstimateCPU="0.000160601" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3.27367" LogicalOp="Index Seek" NodeId="39" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032856" TableCardinality="31579">
  1439. <OutputList>
  1440. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  1441. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="AccountId" />
  1442. </OutputList>
  1443. <RunTimeInformation>
  1444. <RunTimeCountersPerThread Thread="0" ActualRows="474" ActualEndOfScans="1" ActualExecutions="1" />
  1445. </RunTimeInformation>
  1446. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  1447. <DefinedValues>
  1448. <DefinedValue>
  1449. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  1450. </DefinedValue>
  1451. <DefinedValue>
  1452. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="AccountId" />
  1453. </DefinedValue>
  1454. </DefinedValues>
  1455. <Object Database="[m5db]" Schema="[dbo]" Table="[Location]" Index="[IX_Location_AccountId]" Alias="[l]" IndexKind="NonClustered" />
  1456. <SeekPredicates>
  1457. <SeekPredicateNew>
  1458. <SeekKeys>
  1459. <Prefix ScanType="EQ">
  1460. <RangeColumns>
  1461. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="AccountId" />
  1462. </RangeColumns>
  1463. <RangeExpressions>
  1464. <ScalarOperator ScalarString="[@AccountId]">
  1465. <Identifier>
  1466. <ColumnReference Column="@AccountId" />
  1467. </Identifier>
  1468. </ScalarOperator>
  1469. </RangeExpressions>
  1470. </Prefix>
  1471. </SeekKeys>
  1472. </SeekPredicateNew>
  1473. </SeekPredicates>
  1474. </IndexScan>
  1475. </RelOp>
  1476. <RelOp AvgRowSize="9" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="2.27367" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="40" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00364257" TableCardinality="474">
  1477. <OutputList />
  1478. <RunTimeInformation>
  1479. <RunTimeCountersPerThread Thread="0" ActualRows="474" ActualEndOfScans="0" ActualExecutions="474" />
  1480. </RunTimeInformation>
  1481. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  1482. <DefinedValues />
  1483. <Object Table="[@locations]" Index="[PK__#ACE375D__3214EC07796ECC04]" />
  1484. <SeekPredicates>
  1485. <SeekPredicateNew>
  1486. <SeekKeys>
  1487. <Prefix ScanType="EQ">
  1488. <RangeColumns>
  1489. <ColumnReference Column="Id" />
  1490. </RangeColumns>
  1491. <RangeExpressions>
  1492. <ScalarOperator ScalarString="[m5db].[dbo].[Location].[Id] as [l].[Id]">
  1493. <Identifier>
  1494. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  1495. </Identifier>
  1496. </ScalarOperator>
  1497. </RangeExpressions>
  1498. </Prefix>
  1499. </SeekKeys>
  1500. </SeekPredicateNew>
  1501. </SeekPredicates>
  1502. </IndexScan>
  1503. </RelOp>
  1504. </NestedLoops>
  1505. </RelOp>
  1506. <RelOp AvgRowSize="19" EstimateCPU="0.000175107" EstimateIO="0.003125" EstimateRebinds="2.27367" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="16.461" LogicalOp="Index Seek" NodeId="42" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00769935" TableCardinality="628585">
  1507. <OutputList>
  1508. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  1509. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  1510. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  1511. </OutputList>
  1512. <RunTimeInformation>
  1513. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="474" ActualExecutions="474" />
  1514. </RunTimeInformation>
  1515. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  1516. <DefinedValues>
  1517. <DefinedValue>
  1518. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  1519. </DefinedValue>
  1520. <DefinedValue>
  1521. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  1522. </DefinedValue>
  1523. <DefinedValue>
  1524. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  1525. </DefinedValue>
  1526. </DefinedValues>
  1527. <Object Database="[m5db]" Schema="[dbo]" Table="[Profile]" Index="[IX_Profile_LocationId_ProfileTypeId_ProfileStatusId]" Alias="[pr]" IndexKind="NonClustered" />
  1528. <SeekPredicates>
  1529. <SeekPredicateNew>
  1530. <SeekKeys>
  1531. <Prefix ScanType="EQ">
  1532. <RangeColumns>
  1533. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="LocationId" />
  1534. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  1535. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  1536. </RangeColumns>
  1537. <RangeExpressions>
  1538. <ScalarOperator ScalarString="[m5db].[dbo].[Location].[Id] as [l].[Id]">
  1539. <Identifier>
  1540. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  1541. </Identifier>
  1542. </ScalarOperator>
  1543. <ScalarOperator ScalarString="(2)">
  1544. <Const ConstValue="(2)" />
  1545. </ScalarOperator>
  1546. <ScalarOperator ScalarString="(0)">
  1547. <Const ConstValue="(0)" />
  1548. </ScalarOperator>
  1549. </RangeExpressions>
  1550. </Prefix>
  1551. </SeekKeys>
  1552. </SeekPredicateNew>
  1553. <SeekPredicateNew>
  1554. <SeekKeys>
  1555. <Prefix ScanType="EQ">
  1556. <RangeColumns>
  1557. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="LocationId" />
  1558. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  1559. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  1560. </RangeColumns>
  1561. <RangeExpressions>
  1562. <ScalarOperator ScalarString="[m5db].[dbo].[Location].[Id] as [l].[Id]">
  1563. <Identifier>
  1564. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  1565. </Identifier>
  1566. </ScalarOperator>
  1567. <ScalarOperator ScalarString="(3)">
  1568. <Const ConstValue="(3)" />
  1569. </ScalarOperator>
  1570. <ScalarOperator ScalarString="(0)">
  1571. <Const ConstValue="(0)" />
  1572. </ScalarOperator>
  1573. </RangeExpressions>
  1574. </Prefix>
  1575. </SeekKeys>
  1576. </SeekPredicateNew>
  1577. <SeekPredicateNew>
  1578. <SeekKeys>
  1579. <Prefix ScanType="EQ">
  1580. <RangeColumns>
  1581. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="LocationId" />
  1582. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  1583. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  1584. </RangeColumns>
  1585. <RangeExpressions>
  1586. <ScalarOperator ScalarString="[m5db].[dbo].[Location].[Id] as [l].[Id]">
  1587. <Identifier>
  1588. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  1589. </Identifier>
  1590. </ScalarOperator>
  1591. <ScalarOperator ScalarString="(4)">
  1592. <Const ConstValue="(4)" />
  1593. </ScalarOperator>
  1594. <ScalarOperator ScalarString="(0)">
  1595. <Const ConstValue="(0)" />
  1596. </ScalarOperator>
  1597. </RangeExpressions>
  1598. </Prefix>
  1599. </SeekKeys>
  1600. </SeekPredicateNew>
  1601. <SeekPredicateNew>
  1602. <SeekKeys>
  1603. <Prefix ScanType="EQ">
  1604. <RangeColumns>
  1605. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="LocationId" />
  1606. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  1607. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  1608. </RangeColumns>
  1609. <RangeExpressions>
  1610. <ScalarOperator ScalarString="[m5db].[dbo].[Location].[Id] as [l].[Id]">
  1611. <Identifier>
  1612. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  1613. </Identifier>
  1614. </ScalarOperator>
  1615. <ScalarOperator ScalarString="(5)">
  1616. <Const ConstValue="(5)" />
  1617. </ScalarOperator>
  1618. <ScalarOperator ScalarString="(0)">
  1619. <Const ConstValue="(0)" />
  1620. </ScalarOperator>
  1621. </RangeExpressions>
  1622. </Prefix>
  1623. </SeekKeys>
  1624. </SeekPredicateNew>
  1625. <SeekPredicateNew>
  1626. <SeekKeys>
  1627. <Prefix ScanType="EQ">
  1628. <RangeColumns>
  1629. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="LocationId" />
  1630. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  1631. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  1632. </RangeColumns>
  1633. <RangeExpressions>
  1634. <ScalarOperator ScalarString="[m5db].[dbo].[Location].[Id] as [l].[Id]">
  1635. <Identifier>
  1636. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  1637. </Identifier>
  1638. </ScalarOperator>
  1639. <ScalarOperator ScalarString="(7)">
  1640. <Const ConstValue="(7)" />
  1641. </ScalarOperator>
  1642. <ScalarOperator ScalarString="(0)">
  1643. <Const ConstValue="(0)" />
  1644. </ScalarOperator>
  1645. </RangeExpressions>
  1646. </Prefix>
  1647. </SeekKeys>
  1648. </SeekPredicateNew>
  1649. <SeekPredicateNew>
  1650. <SeekKeys>
  1651. <Prefix ScanType="EQ">
  1652. <RangeColumns>
  1653. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="LocationId" />
  1654. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  1655. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  1656. </RangeColumns>
  1657. <RangeExpressions>
  1658. <ScalarOperator ScalarString="[m5db].[dbo].[Location].[Id] as [l].[Id]">
  1659. <Identifier>
  1660. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  1661. </Identifier>
  1662. </ScalarOperator>
  1663. <ScalarOperator ScalarString="(11)">
  1664. <Const ConstValue="(11)" />
  1665. </ScalarOperator>
  1666. <ScalarOperator ScalarString="(0)">
  1667. <Const ConstValue="(0)" />
  1668. </ScalarOperator>
  1669. </RangeExpressions>
  1670. </Prefix>
  1671. </SeekKeys>
  1672. </SeekPredicateNew>
  1673. <SeekPredicateNew>
  1674. <SeekKeys>
  1675. <Prefix ScanType="EQ">
  1676. <RangeColumns>
  1677. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="LocationId" />
  1678. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  1679. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  1680. </RangeColumns>
  1681. <RangeExpressions>
  1682. <ScalarOperator ScalarString="[m5db].[dbo].[Location].[Id] as [l].[Id]">
  1683. <Identifier>
  1684. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  1685. </Identifier>
  1686. </ScalarOperator>
  1687. <ScalarOperator ScalarString="(12)">
  1688. <Const ConstValue="(12)" />
  1689. </ScalarOperator>
  1690. <ScalarOperator ScalarString="(0)">
  1691. <Const ConstValue="(0)" />
  1692. </ScalarOperator>
  1693. </RangeExpressions>
  1694. </Prefix>
  1695. </SeekKeys>
  1696. </SeekPredicateNew>
  1697. <SeekPredicateNew>
  1698. <SeekKeys>
  1699. <Prefix ScanType="EQ">
  1700. <RangeColumns>
  1701. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="LocationId" />
  1702. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  1703. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  1704. </RangeColumns>
  1705. <RangeExpressions>
  1706. <ScalarOperator ScalarString="[m5db].[dbo].[Location].[Id] as [l].[Id]">
  1707. <Identifier>
  1708. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  1709. </Identifier>
  1710. </ScalarOperator>
  1711. <ScalarOperator ScalarString="(13)">
  1712. <Const ConstValue="(13)" />
  1713. </ScalarOperator>
  1714. <ScalarOperator ScalarString="(0)">
  1715. <Const ConstValue="(0)" />
  1716. </ScalarOperator>
  1717. </RangeExpressions>
  1718. </Prefix>
  1719. </SeekKeys>
  1720. </SeekPredicateNew>
  1721. <SeekPredicateNew>
  1722. <SeekKeys>
  1723. <Prefix ScanType="EQ">
  1724. <RangeColumns>
  1725. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="LocationId" />
  1726. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  1727. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileStatusId" />
  1728. </RangeColumns>
  1729. <RangeExpressions>
  1730. <ScalarOperator ScalarString="[m5db].[dbo].[Location].[Id] as [l].[Id]">
  1731. <Identifier>
  1732. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Location]" Alias="[l]" Column="Id" />
  1733. </Identifier>
  1734. </ScalarOperator>
  1735. <ScalarOperator ScalarString="(15)">
  1736. <Const ConstValue="(15)" />
  1737. </ScalarOperator>
  1738. <ScalarOperator ScalarString="(0)">
  1739. <Const ConstValue="(0)" />
  1740. </ScalarOperator>
  1741. </RangeExpressions>
  1742. </Prefix>
  1743. </SeekKeys>
  1744. </SeekPredicateNew>
  1745. </SeekPredicates>
  1746. </IndexScan>
  1747. </RelOp>
  1748. </NestedLoops>
  1749. </RelOp>
  1750. <RelOp AvgRowSize="150" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="50.6141" EstimateRewinds="2.27361" EstimatedExecutionMode="Row" EstimateRows="53.6546" LogicalOp="Clustered Index Seek" NodeId="44" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0700375" TableCardinality="628585">
  1751. <OutputList>
  1752. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="PartitionId" />
  1753. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="PersonId" />
  1754. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="InternalCallerId" />
  1755. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Extension" />
  1756. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnId" />
  1757. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnCountryId" />
  1758. </OutputList>
  1759. <RunTimeInformation>
  1760. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="0" ActualExecutions="1970" />
  1761. </RunTimeInformation>
  1762. <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  1763. <DefinedValues>
  1764. <DefinedValue>
  1765. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="PartitionId" />
  1766. </DefinedValue>
  1767. <DefinedValue>
  1768. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="PersonId" />
  1769. </DefinedValue>
  1770. <DefinedValue>
  1771. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="InternalCallerId" />
  1772. </DefinedValue>
  1773. <DefinedValue>
  1774. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Extension" />
  1775. </DefinedValue>
  1776. <DefinedValue>
  1777. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnId" />
  1778. </DefinedValue>
  1779. <DefinedValue>
  1780. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="TnCountryId" />
  1781. </DefinedValue>
  1782. </DefinedValues>
  1783. <Object Database="[m5db]" Schema="[dbo]" Table="[Profile]" Index="[PK_Profile]" Alias="[pr]" TableReferenceId="-1" IndexKind="Clustered" />
  1784. <SeekPredicates>
  1785. <SeekPredicateNew>
  1786. <SeekKeys>
  1787. <Prefix ScanType="EQ">
  1788. <RangeColumns>
  1789. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  1790. </RangeColumns>
  1791. <RangeExpressions>
  1792. <ScalarOperator ScalarString="[m5db].[dbo].[Profile].[Id] as [pr].[Id]">
  1793. <Identifier>
  1794. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  1795. </Identifier>
  1796. </ScalarOperator>
  1797. </RangeExpressions>
  1798. </Prefix>
  1799. </SeekKeys>
  1800. </SeekPredicateNew>
  1801. </SeekPredicates>
  1802. <Predicate>
  1803. <ScalarOperator ScalarString="(0)=[m5db].[dbo].[Profile].[IsVoiceMailDeposit] as [pr].[IsVoiceMailDeposit] AND (0)=[m5db].[dbo].[Profile].[IsVoiceMailRetrieve] as [pr].[IsVoiceMailRetrieve]">
  1804. <Logical Operation="AND">
  1805. <ScalarOperator>
  1806. <Compare CompareOp="EQ">
  1807. <ScalarOperator>
  1808. <Const ConstValue="(0)" />
  1809. </ScalarOperator>
  1810. <ScalarOperator>
  1811. <Identifier>
  1812. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="IsVoiceMailDeposit" />
  1813. </Identifier>
  1814. </ScalarOperator>
  1815. </Compare>
  1816. </ScalarOperator>
  1817. <ScalarOperator>
  1818. <Compare CompareOp="EQ">
  1819. <ScalarOperator>
  1820. <Const ConstValue="(0)" />
  1821. </ScalarOperator>
  1822. <ScalarOperator>
  1823. <Identifier>
  1824. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="IsVoiceMailRetrieve" />
  1825. </Identifier>
  1826. </ScalarOperator>
  1827. </Compare>
  1828. </ScalarOperator>
  1829. </Logical>
  1830. </ScalarOperator>
  1831. </Predicate>
  1832. </IndexScan>
  1833. </RelOp>
  1834. </NestedLoops>
  1835. </RelOp>
  1836. </ComputeScalar>
  1837. </RelOp>
  1838. <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="52.6546" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="63" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.161874" TableCardinality="9417">
  1839. <OutputList>
  1840. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Partition]" Alias="[pt]" Column="ClusterId" />
  1841. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Partition]" Alias="[pt]" Column="AccountId" />
  1842. </OutputList>
  1843. <RunTimeInformation>
  1844. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="0" ActualExecutions="1970" />
  1845. </RunTimeInformation>
  1846. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  1847. <DefinedValues>
  1848. <DefinedValue>
  1849. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Partition]" Alias="[pt]" Column="ClusterId" />
  1850. </DefinedValue>
  1851. <DefinedValue>
  1852. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Partition]" Alias="[pt]" Column="AccountId" />
  1853. </DefinedValue>
  1854. </DefinedValues>
  1855. <Object Database="[m5db]" Schema="[dbo]" Table="[Partition]" Index="[PK_Partition]" Alias="[pt]" IndexKind="Clustered" />
  1856. <SeekPredicates>
  1857. <SeekPredicateNew>
  1858. <SeekKeys>
  1859. <Prefix ScanType="EQ">
  1860. <RangeColumns>
  1861. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Partition]" Alias="[pt]" Column="Id" />
  1862. </RangeColumns>
  1863. <RangeExpressions>
  1864. <ScalarOperator ScalarString="[m5db].[dbo].[Profile].[PartitionId] as [pr].[PartitionId]">
  1865. <Identifier>
  1866. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="PartitionId" />
  1867. </Identifier>
  1868. </ScalarOperator>
  1869. </RangeExpressions>
  1870. </Prefix>
  1871. </SeekKeys>
  1872. </SeekPredicateNew>
  1873. </SeekPredicates>
  1874. </IndexScan>
  1875. </RelOp>
  1876. </NestedLoops>
  1877. </RelOp>
  1878. <RelOp AvgRowSize="11" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="39.6934" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="64" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.126172" TableCardinality="11720">
  1879. <OutputList>
  1880. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Account]" Alias="[a]" Column="Id" />
  1881. </OutputList>
  1882. <RunTimeInformation>
  1883. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="0" ActualExecutions="1970" />
  1884. </RunTimeInformation>
  1885. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  1886. <DefinedValues>
  1887. <DefinedValue>
  1888. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Account]" Alias="[a]" Column="Id" />
  1889. </DefinedValue>
  1890. </DefinedValues>
  1891. <Object Database="[m5db]" Schema="[dbo]" Table="[Account]" Index="[PK_Account]" Alias="[a]" IndexKind="Clustered" />
  1892. <SeekPredicates>
  1893. <SeekPredicateNew>
  1894. <SeekKeys>
  1895. <Prefix ScanType="EQ">
  1896. <RangeColumns>
  1897. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Account]" Alias="[a]" Column="Id" />
  1898. </RangeColumns>
  1899. <RangeExpressions>
  1900. <ScalarOperator ScalarString="[m5db].[dbo].[Partition].[AccountId] as [pt].[AccountId]">
  1901. <Identifier>
  1902. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Partition]" Alias="[pt]" Column="AccountId" />
  1903. </Identifier>
  1904. </ScalarOperator>
  1905. </RangeExpressions>
  1906. </Prefix>
  1907. </SeekKeys>
  1908. </SeekPredicateNew>
  1909. </SeekPredicates>
  1910. </IndexScan>
  1911. </RelOp>
  1912. </NestedLoops>
  1913. </RelOp>
  1914. <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="36.321" EstimateRewinds="0.195275" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="65" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.021427" TableCardinality="202">
  1915. <OutputList>
  1916. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="Id" />
  1917. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="PlatformTypeId" />
  1918. </OutputList>
  1919. <RunTimeInformation>
  1920. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="0" ActualExecutions="1970" />
  1921. </RunTimeInformation>
  1922. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  1923. <DefinedValues>
  1924. <DefinedValue>
  1925. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="Id" />
  1926. </DefinedValue>
  1927. <DefinedValue>
  1928. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="PlatformTypeId" />
  1929. </DefinedValue>
  1930. </DefinedValues>
  1931. <Object Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Index="[PK_Cluster]" Alias="[cl]" IndexKind="Clustered" />
  1932. <SeekPredicates>
  1933. <SeekPredicateNew>
  1934. <SeekKeys>
  1935. <Prefix ScanType="EQ">
  1936. <RangeColumns>
  1937. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="Id" />
  1938. </RangeColumns>
  1939. <RangeExpressions>
  1940. <ScalarOperator ScalarString="[m5db].[dbo].[Partition].[ClusterId] as [pt].[ClusterId]">
  1941. <Identifier>
  1942. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Partition]" Alias="[pt]" Column="ClusterId" />
  1943. </Identifier>
  1944. </ScalarOperator>
  1945. </RangeExpressions>
  1946. </Prefix>
  1947. </SeekKeys>
  1948. </SeekPredicateNew>
  1949. </SeekPredicates>
  1950. </IndexScan>
  1951. </RelOp>
  1952. </NestedLoops>
  1953. </RelOp>
  1954. </ComputeScalar>
  1955. </RelOp>
  1956. <RelOp AvgRowSize="9" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="36.321" EstimateRewinds="0.195275" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="69" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00905632" TableCardinality="12077">
  1957. <OutputList />
  1958. <RunTimeInformation>
  1959. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="0" ActualExecutions="1970" />
  1960. </RunTimeInformation>
  1961. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  1962. <DefinedValues />
  1963. <Object Database="[m5db]" Schema="[dbo]" Table="[AccountCluster]" Index="[IX_AccountCluster_AccountId_ClusterId]" Alias="[acc]" IndexKind="NonClustered" />
  1964. <SeekPredicates>
  1965. <SeekPredicateNew>
  1966. <SeekKeys>
  1967. <Prefix ScanType="EQ">
  1968. <RangeColumns>
  1969. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountCluster]" Alias="[acc]" Column="AccountId" />
  1970. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountCluster]" Alias="[acc]" Column="ClusterId" />
  1971. </RangeColumns>
  1972. <RangeExpressions>
  1973. <ScalarOperator ScalarString="[@AccountId]">
  1974. <Identifier>
  1975. <ColumnReference Column="@AccountId" />
  1976. </Identifier>
  1977. </ScalarOperator>
  1978. <ScalarOperator ScalarString="[m5db].[dbo].[Cluster].[Id] as [cl].[Id]">
  1979. <Identifier>
  1980. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="Id" />
  1981. </Identifier>
  1982. </ScalarOperator>
  1983. </RangeExpressions>
  1984. </Prefix>
  1985. </SeekKeys>
  1986. </SeekPredicateNew>
  1987. </SeekPredicates>
  1988. </IndexScan>
  1989. </RelOp>
  1990. </NestedLoops>
  1991. </RelOp>
  1992. <RelOp AvgRowSize="9" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0.463106" EstimateRewinds="0.0178483" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="70" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00335914" TableCardinality="18">
  1993. <OutputList />
  1994. <RunTimeInformation>
  1995. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="0" ActualExecutions="1970" />
  1996. </RunTimeInformation>
  1997. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  1998. <DefinedValues />
  1999. <Object Database="[m5db]" Schema="[dbo]" Table="[PlatformType]" Index="[PK_ClusterType]" Alias="[plt]" IndexKind="Clustered" />
  2000. <SeekPredicates>
  2001. <SeekPredicateNew>
  2002. <SeekKeys>
  2003. <Prefix ScanType="EQ">
  2004. <RangeColumns>
  2005. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[PlatformType]" Alias="[plt]" Column="Id" />
  2006. </RangeColumns>
  2007. <RangeExpressions>
  2008. <ScalarOperator ScalarString="[m5db].[dbo].[Cluster].[PlatformTypeId] as [cl].[PlatformTypeId]">
  2009. <Identifier>
  2010. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Cluster]" Alias="[cl]" Column="PlatformTypeId" />
  2011. </Identifier>
  2012. </ScalarOperator>
  2013. </RangeExpressions>
  2014. </Prefix>
  2015. </SeekKeys>
  2016. </SeekPredicateNew>
  2017. </SeekPredicates>
  2018. </IndexScan>
  2019. </RelOp>
  2020. </NestedLoops>
  2021. </RelOp>
  2022. <RelOp AvgRowSize="11" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0.422354" EstimateRewinds="0.0586003" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="71" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00335914" TableCardinality="16">
  2023. <OutputList />
  2024. <RunTimeInformation>
  2025. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="0" ActualExecutions="1970" />
  2026. </RunTimeInformation>
  2027. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  2028. <DefinedValues />
  2029. <Object Database="[m5db]" Schema="[dbo]" Table="[ProfileType]" Index="[PK_ProfileType]" Alias="[prt]" IndexKind="Clustered" />
  2030. <SeekPredicates>
  2031. <SeekPredicateNew>
  2032. <SeekKeys>
  2033. <Prefix ScanType="EQ">
  2034. <RangeColumns>
  2035. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[ProfileType]" Alias="[prt]" Column="Id" />
  2036. </RangeColumns>
  2037. <RangeExpressions>
  2038. <ScalarOperator ScalarString="[m5db].[dbo].[Profile].[ProfileTypeId] as [pr].[ProfileTypeId]">
  2039. <Identifier>
  2040. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="ProfileTypeId" />
  2041. </Identifier>
  2042. </ScalarOperator>
  2043. </RangeExpressions>
  2044. </Prefix>
  2045. </SeekKeys>
  2046. </SeekPredicateNew>
  2047. </SeekPredicates>
  2048. <Predicate>
  2049. <ScalarOperator ScalarString="[m5db].[dbo].[ProfileType].[Id] as [prt].[Id]&gt;=(2) AND [m5db].[dbo].[ProfileType].[Id] as [prt].[Id]&lt;=(15)">
  2050. <Logical Operation="AND">
  2051. <ScalarOperator>
  2052. <Compare CompareOp="GE">
  2053. <ScalarOperator>
  2054. <Identifier>
  2055. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[ProfileType]" Alias="[prt]" Column="Id" />
  2056. </Identifier>
  2057. </ScalarOperator>
  2058. <ScalarOperator>
  2059. <Const ConstValue="(2)" />
  2060. </ScalarOperator>
  2061. </Compare>
  2062. </ScalarOperator>
  2063. <ScalarOperator>
  2064. <Compare CompareOp="LE">
  2065. <ScalarOperator>
  2066. <Identifier>
  2067. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[ProfileType]" Alias="[prt]" Column="Id" />
  2068. </Identifier>
  2069. </ScalarOperator>
  2070. <ScalarOperator>
  2071. <Const ConstValue="(15)" />
  2072. </ScalarOperator>
  2073. </Compare>
  2074. </ScalarOperator>
  2075. </Logical>
  2076. </ScalarOperator>
  2077. </Predicate>
  2078. </IndexScan>
  2079. </RelOp>
  2080. </NestedLoops>
  2081. </RelOp>
  2082. </NestedLoops>
  2083. </RelOp>
  2084. </NestedLoops>
  2085. </RelOp>
  2086. </NestedLoops>
  2087. </RelOp>
  2088. </NestedLoops>
  2089. </RelOp>
  2090. </NestedLoops>
  2091. </RelOp>
  2092. <RelOp AvgRowSize="11" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0.480955" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="72" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00335914" TableCardinality="3070">
  2093. <OutputList>
  2094. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountFeature]" Alias="[af]" Column="FeatureStatusId" />
  2095. </OutputList>
  2096. <RunTimeInformation>
  2097. <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1970" ActualExecutions="1970" />
  2098. </RunTimeInformation>
  2099. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  2100. <DefinedValues>
  2101. <DefinedValue>
  2102. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountFeature]" Alias="[af]" Column="FeatureStatusId" />
  2103. </DefinedValue>
  2104. </DefinedValues>
  2105. <Object Database="[m5db]" Schema="[dbo]" Table="[AccountFeature]" Index="[ix_AccountFeature_FeatureId]" Alias="[af]" IndexKind="NonClustered" />
  2106. <SeekPredicates>
  2107. <SeekPredicateNew>
  2108. <SeekKeys>
  2109. <Prefix ScanType="EQ">
  2110. <RangeColumns>
  2111. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountFeature]" Alias="[af]" Column="FeatureId" />
  2112. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountFeature]" Alias="[af]" Column="AccountId" />
  2113. </RangeColumns>
  2114. <RangeExpressions>
  2115. <ScalarOperator ScalarString="(13)">
  2116. <Const ConstValue="(13)" />
  2117. </ScalarOperator>
  2118. <ScalarOperator ScalarString="[m5db].[dbo].[Account].[Id] as [a].[Id]">
  2119. <Identifier>
  2120. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Account]" Alias="[a]" Column="Id" />
  2121. </Identifier>
  2122. </ScalarOperator>
  2123. </RangeExpressions>
  2124. </Prefix>
  2125. </SeekKeys>
  2126. </SeekPredicateNew>
  2127. </SeekPredicates>
  2128. </IndexScan>
  2129. </RelOp>
  2130. </NestedLoops>
  2131. </RelOp>
  2132. <RelOp AvgRowSize="12" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0.480955" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="73" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00397977" TableCardinality="18694">
  2133. <OutputList>
  2134. <ColumnReference Column="IsBaseRow1027" />
  2135. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[mfl]" Column="Id" />
  2136. </OutputList>
  2137. <RunTimeInformation>
  2138. <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1970" ActualExecutions="1970" />
  2139. </RunTimeInformation>
  2140. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  2141. <DefinedValues>
  2142. <DefinedValue>
  2143. <ColumnReference Column="IsBaseRow1027" />
  2144. </DefinedValue>
  2145. <DefinedValue>
  2146. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[mfl]" Column="Id" />
  2147. </DefinedValue>
  2148. </DefinedValues>
  2149. <Object Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Index="[IX_AccountPolisty_FieldId]" Alias="[mfl]" IndexKind="NonClustered" />
  2150. <SeekPredicates>
  2151. <SeekPredicateNew>
  2152. <SeekKeys>
  2153. <Prefix ScanType="EQ">
  2154. <RangeColumns>
  2155. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[mfl]" Column="AccountId" />
  2156. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[mfl]" Column="AccountPolicyFieldId" />
  2157. </RangeColumns>
  2158. <RangeExpressions>
  2159. <ScalarOperator ScalarString="[m5db].[dbo].[Account].[Id] as [a].[Id]">
  2160. <Identifier>
  2161. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Account]" Alias="[a]" Column="Id" />
  2162. </Identifier>
  2163. </ScalarOperator>
  2164. <ScalarOperator ScalarString="(13001)">
  2165. <Const ConstValue="(13001)" />
  2166. </ScalarOperator>
  2167. </RangeExpressions>
  2168. </Prefix>
  2169. </SeekKeys>
  2170. </SeekPredicateNew>
  2171. </SeekPredicates>
  2172. </IndexScan>
  2173. </RelOp>
  2174. </NestedLoops>
  2175. </RelOp>
  2176. <RelOp AvgRowSize="111" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0.480955" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="75" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00398565" TableCardinality="18694">
  2177. <OutputList>
  2178. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[mfl]" Column="Value" />
  2179. </OutputList>
  2180. <RunTimeInformation>
  2181. <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
  2182. </RunTimeInformation>
  2183. <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  2184. <DefinedValues>
  2185. <DefinedValue>
  2186. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[mfl]" Column="Value" />
  2187. </DefinedValue>
  2188. </DefinedValues>
  2189. <Object Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Index="[PK_AccountPolicy]" Alias="[mfl]" TableReferenceId="-1" IndexKind="Clustered" />
  2190. <SeekPredicates>
  2191. <SeekPredicateNew>
  2192. <SeekKeys>
  2193. <Prefix ScanType="EQ">
  2194. <RangeColumns>
  2195. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[mfl]" Column="Id" />
  2196. </RangeColumns>
  2197. <RangeExpressions>
  2198. <ScalarOperator ScalarString="[m5db].[dbo].[AccountPolicy].[Id] as [mfl].[Id]">
  2199. <Identifier>
  2200. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[mfl]" Column="Id" />
  2201. </Identifier>
  2202. </ScalarOperator>
  2203. </RangeExpressions>
  2204. </Prefix>
  2205. </SeekKeys>
  2206. </SeekPredicateNew>
  2207. </SeekPredicates>
  2208. </IndexScan>
  2209. </RelOp>
  2210. </NestedLoops>
  2211. </RelOp>
  2212. <RelOp AvgRowSize="12" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0.480955" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="79" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00397977" TableCardinality="18694">
  2213. <OutputList>
  2214. <ColumnReference Column="IsBaseRow1031" />
  2215. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[ld]" Column="Id" />
  2216. </OutputList>
  2217. <RunTimeInformation>
  2218. <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1970" ActualExecutions="1970" />
  2219. </RunTimeInformation>
  2220. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  2221. <DefinedValues>
  2222. <DefinedValue>
  2223. <ColumnReference Column="IsBaseRow1031" />
  2224. </DefinedValue>
  2225. <DefinedValue>
  2226. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[ld]" Column="Id" />
  2227. </DefinedValue>
  2228. </DefinedValues>
  2229. <Object Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Index="[IX_AccountPolisty_FieldId]" Alias="[ld]" IndexKind="NonClustered" />
  2230. <SeekPredicates>
  2231. <SeekPredicateNew>
  2232. <SeekKeys>
  2233. <Prefix ScanType="EQ">
  2234. <RangeColumns>
  2235. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[ld]" Column="AccountId" />
  2236. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[ld]" Column="AccountPolicyFieldId" />
  2237. </RangeColumns>
  2238. <RangeExpressions>
  2239. <ScalarOperator ScalarString="[m5db].[dbo].[Account].[Id] as [a].[Id]">
  2240. <Identifier>
  2241. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Account]" Alias="[a]" Column="Id" />
  2242. </Identifier>
  2243. </ScalarOperator>
  2244. <ScalarOperator ScalarString="(13002)">
  2245. <Const ConstValue="(13002)" />
  2246. </ScalarOperator>
  2247. </RangeExpressions>
  2248. </Prefix>
  2249. </SeekKeys>
  2250. </SeekPredicateNew>
  2251. </SeekPredicates>
  2252. </IndexScan>
  2253. </RelOp>
  2254. </NestedLoops>
  2255. </RelOp>
  2256. <RelOp AvgRowSize="111" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0.480955" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="81" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00398565" TableCardinality="18694">
  2257. <OutputList>
  2258. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[ld]" Column="Value" />
  2259. </OutputList>
  2260. <RunTimeInformation>
  2261. <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
  2262. </RunTimeInformation>
  2263. <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  2264. <DefinedValues>
  2265. <DefinedValue>
  2266. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[ld]" Column="Value" />
  2267. </DefinedValue>
  2268. </DefinedValues>
  2269. <Object Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Index="[PK_AccountPolicy]" Alias="[ld]" TableReferenceId="-1" IndexKind="Clustered" />
  2270. <SeekPredicates>
  2271. <SeekPredicateNew>
  2272. <SeekKeys>
  2273. <Prefix ScanType="EQ">
  2274. <RangeColumns>
  2275. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[ld]" Column="Id" />
  2276. </RangeColumns>
  2277. <RangeExpressions>
  2278. <ScalarOperator ScalarString="[m5db].[dbo].[AccountPolicy].[Id] as [ld].[Id]">
  2279. <Identifier>
  2280. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[AccountPolicy]" Alias="[ld]" Column="Id" />
  2281. </Identifier>
  2282. </ScalarOperator>
  2283. </RangeExpressions>
  2284. </Prefix>
  2285. </SeekKeys>
  2286. </SeekPredicateNew>
  2287. </SeekPredicates>
  2288. </IndexScan>
  2289. </RelOp>
  2290. </NestedLoops>
  2291. </RelOp>
  2292. <RelOp AvgRowSize="11" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0.480955" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="85" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00398698" TableCardinality="249822">
  2293. <OutputList>
  2294. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="Id" />
  2295. </OutputList>
  2296. <RunTimeInformation>
  2297. <RunTimeCountersPerThread Thread="0" ActualRows="1245" ActualEndOfScans="725" ActualExecutions="1970" />
  2298. </RunTimeInformation>
  2299. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  2300. <DefinedValues>
  2301. <DefinedValue>
  2302. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="Id" />
  2303. </DefinedValue>
  2304. </DefinedValues>
  2305. <Object Database="[m5db]" Schema="[dbo]" Table="[Person]" Index="[IX_Person_Id_Username_IsDeleted]" Alias="[pe]" TableReferenceId="1" IndexKind="NonClustered" />
  2306. <SeekPredicates>
  2307. <SeekPredicateNew>
  2308. <SeekKeys>
  2309. <Prefix ScanType="EQ">
  2310. <RangeColumns>
  2311. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="Id" />
  2312. </RangeColumns>
  2313. <RangeExpressions>
  2314. <ScalarOperator ScalarString="[m5db].[dbo].[Profile].[PersonId] as [pr].[PersonId]">
  2315. <Identifier>
  2316. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="PersonId" />
  2317. </Identifier>
  2318. </ScalarOperator>
  2319. </RangeExpressions>
  2320. </Prefix>
  2321. </SeekKeys>
  2322. </SeekPredicateNew>
  2323. </SeekPredicates>
  2324. </IndexScan>
  2325. </RelOp>
  2326. </NestedLoops>
  2327. </RelOp>
  2328. <RelOp AvgRowSize="22" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0.480955" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="86" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00396147" TableCardinality="794">
  2329. <OutputList>
  2330. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[access_UserLogin]" Alias="[ul]" Column="FailedLoginCount" />
  2331. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[access_UserLogin]" Alias="[ul]" Column="DateLocked" />
  2332. </OutputList>
  2333. <RunTimeInformation>
  2334. <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1970" ActualExecutions="1970" />
  2335. </RunTimeInformation>
  2336. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  2337. <DefinedValues>
  2338. <DefinedValue>
  2339. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[access_UserLogin]" Alias="[ul]" Column="FailedLoginCount" />
  2340. </DefinedValue>
  2341. <DefinedValue>
  2342. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[access_UserLogin]" Alias="[ul]" Column="DateLocked" />
  2343. </DefinedValue>
  2344. </DefinedValues>
  2345. <Object Database="[m5db]" Schema="[dbo]" Table="[access_UserLogin]" Index="[PK_access_UserLogin]" Alias="[ul]" IndexKind="Clustered" />
  2346. <SeekPredicates>
  2347. <SeekPredicateNew>
  2348. <SeekKeys>
  2349. <Prefix ScanType="EQ">
  2350. <RangeColumns>
  2351. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[access_UserLogin]" Alias="[ul]" Column="Username" />
  2352. </RangeColumns>
  2353. <RangeExpressions>
  2354. <ScalarOperator ScalarString="[Expr1067]">
  2355. <Identifier>
  2356. <ColumnReference Column="Expr1067" />
  2357. </Identifier>
  2358. </ScalarOperator>
  2359. </RangeExpressions>
  2360. </Prefix>
  2361. </SeekKeys>
  2362. </SeekPredicateNew>
  2363. </SeekPredicates>
  2364. <Predicate>
  2365. <ScalarOperator ScalarString="[m5db].[dbo].[access_UserLogin].[AccountId] as [ul].[AccountId]=[m5db].[dbo].[Account].[Id] as [a].[Id]">
  2366. <Compare CompareOp="EQ">
  2367. <ScalarOperator>
  2368. <Identifier>
  2369. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[access_UserLogin]" Alias="[ul]" Column="AccountId" />
  2370. </Identifier>
  2371. </ScalarOperator>
  2372. <ScalarOperator>
  2373. <Identifier>
  2374. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Account]" Alias="[a]" Column="Id" />
  2375. </Identifier>
  2376. </ScalarOperator>
  2377. </Compare>
  2378. </ScalarOperator>
  2379. </Predicate>
  2380. </IndexScan>
  2381. </RelOp>
  2382. </NestedLoops>
  2383. </RelOp>
  2384. <RelOp AvgRowSize="474" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0.480955" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="87" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00398698" TableCardinality="249822">
  2385. <OutputList>
  2386. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="Id" />
  2387. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="FirstName" />
  2388. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="LastName" />
  2389. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="BusinessEmail" />
  2390. </OutputList>
  2391. <RunTimeInformation>
  2392. <RunTimeCountersPerThread Thread="0" ActualRows="1245" ActualEndOfScans="725" ActualExecutions="1970" />
  2393. </RunTimeInformation>
  2394. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  2395. <DefinedValues>
  2396. <DefinedValue>
  2397. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="Id" />
  2398. </DefinedValue>
  2399. <DefinedValue>
  2400. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="FirstName" />
  2401. </DefinedValue>
  2402. <DefinedValue>
  2403. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="LastName" />
  2404. </DefinedValue>
  2405. <DefinedValue>
  2406. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="BusinessEmail" />
  2407. </DefinedValue>
  2408. </DefinedValues>
  2409. <Object Database="[m5db]" Schema="[dbo]" Table="[Person]" Index="[IX_Person_Id_Username_IsDeleted]" Alias="[pe]" TableReferenceId="2" IndexKind="NonClustered" />
  2410. <SeekPredicates>
  2411. <SeekPredicateNew>
  2412. <SeekKeys>
  2413. <Prefix ScanType="EQ">
  2414. <RangeColumns>
  2415. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="Id" />
  2416. </RangeColumns>
  2417. <RangeExpressions>
  2418. <ScalarOperator ScalarString="[m5db].[dbo].[Person].[Id] as [pe].[Id]">
  2419. <Identifier>
  2420. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Person]" Alias="[pe]" Column="Id" />
  2421. </Identifier>
  2422. </ScalarOperator>
  2423. </RangeExpressions>
  2424. </Prefix>
  2425. </SeekKeys>
  2426. </SeekPredicateNew>
  2427. </SeekPredicates>
  2428. </IndexScan>
  2429. </RelOp>
  2430. </NestedLoops>
  2431. </RelOp>
  2432. <RelOp AvgRowSize="11" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0.480955" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="88" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00398705" TableCardinality="628585">
  2433. <OutputList>
  2434. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pro]" Column="PartitionId" />
  2435. </OutputList>
  2436. <RunTimeInformation>
  2437. <RunTimeCountersPerThread Thread="0" ActualRows="1970" ActualEndOfScans="0" ActualExecutions="1970" />
  2438. </RunTimeInformation>
  2439. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  2440. <DefinedValues>
  2441. <DefinedValue>
  2442. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pro]" Column="PartitionId" />
  2443. </DefinedValue>
  2444. </DefinedValues>
  2445. <Object Database="[m5db]" Schema="[dbo]" Table="[Profile]" Index="[PK_Profile]" Alias="[pro]" IndexKind="Clustered" />
  2446. <SeekPredicates>
  2447. <SeekPredicateNew>
  2448. <SeekKeys>
  2449. <Prefix ScanType="EQ">
  2450. <RangeColumns>
  2451. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pro]" Column="Id" />
  2452. </RangeColumns>
  2453. <RangeExpressions>
  2454. <ScalarOperator ScalarString="[m5db].[dbo].[Profile].[Id] as [pr].[Id]">
  2455. <Identifier>
  2456. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pr]" Column="Id" />
  2457. </Identifier>
  2458. </ScalarOperator>
  2459. </RangeExpressions>
  2460. </Prefix>
  2461. </SeekKeys>
  2462. </SeekPredicateNew>
  2463. </SeekPredicates>
  2464. </IndexScan>
  2465. </RelOp>
  2466. </NestedLoops>
  2467. </RelOp>
  2468. <Predicate>
  2469. <ScalarOperator ScalarString="[@PartitionId]&lt;=(0) OR [@PartitionId]=[m5db].[dbo].[Profile].[PartitionId] as [pro].[PartitionId]">
  2470. <Logical Operation="OR">
  2471. <ScalarOperator>
  2472. <Identifier>
  2473. <ColumnReference Column="ConstExpr1060">
  2474. <ScalarOperator>
  2475. <Compare CompareOp="LE">
  2476. <ScalarOperator>
  2477. <Identifier>
  2478. <ColumnReference Column="@PartitionId" />
  2479. </Identifier>
  2480. </ScalarOperator>
  2481. <ScalarOperator>
  2482. <Const ConstValue="(0)" />
  2483. </ScalarOperator>
  2484. </Compare>
  2485. </ScalarOperator>
  2486. </ColumnReference>
  2487. </Identifier>
  2488. </ScalarOperator>
  2489. <ScalarOperator>
  2490. <Compare CompareOp="EQ">
  2491. <ScalarOperator>
  2492. <Identifier>
  2493. <ColumnReference Column="@PartitionId" />
  2494. </Identifier>
  2495. </ScalarOperator>
  2496. <ScalarOperator>
  2497. <Identifier>
  2498. <ColumnReference Database="[m5db]" Schema="[dbo]" Table="[Profile]" Alias="[pro]" Column="PartitionId" />
  2499. </Identifier>
  2500. </ScalarOperator>
  2501. </Compare>
  2502. </ScalarOperator>
  2503. </Logical>
  2504. </ScalarOperator>
  2505. </Predicate>
  2506. </Filter>
  2507. </RelOp>
  2508. </ComputeScalar>
  2509. </RelOp>
  2510. <ParameterList>
  2511. <ColumnReference Column="@PartitionId" ParameterRuntimeValue="(-1)" />
  2512. <ColumnReference Column="@AccountId" ParameterRuntimeValue="(5926)" />
  2513. </ParameterList>
  2514. </QueryPlan>
  2515. </StmtSimple>
  2516. </Statements>
  2517. </Batch>
  2518. </BatchSequence>
  2519. </ShowPlanXML>
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!