Advertisement
Guest User

Untitled

a guest
Dec 18th, 2012
473
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 31.50 KB | None | 0 0
  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.1" Build="10.50.1600.1" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
  3. <BatchSequence>
  4. <Batch>
  5. <Statements>
  6. <StmtSimple StatementCompId="31" StatementEstRows="3.18132" StatementId="1" StatementOptmLevel="FULL" StatementSubTreeCost="58.4186" StatementText="Select [Event].ID, &#xD;&#xA; [Event].[IATA], &#xD;&#xA; [Device].Name,&#xD;&#xA; [EventType].[Description],&#xD;&#xA; [Event].Data1,&#xD;&#xA; [Event].Data2,&#xD;&#xA; [Event].PLCTimeStamp,&#xD;&#xA; [Event].EventTypeID&#xD;&#xA; from&#xD;&#xA; [Event] inner join [EventType] on [Event].EventTypeID = EventType.ID inner join [Device] on [Event].DeviceID = [Device].ID&#xD;&#xA; WHERE [Event].EventTypeID in (3,30,40,41,42,46,49,50) and [Event].[PLCTimeStamp] between '01/28/2011 00:00:00' and '01/29/2011 00:00:00' and [dbo].[Event].[IATA] like '%0005836217%' order by [Event].ID" StatementType="SELECT" QueryHash="0xA215045E33A72252" QueryPlanHash="0xCDDC8630E7B20726">
  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="8" MemoryGrant="0" CachedPlanSize="40" CompileTime="82" CompileCPU="40" CompileMemory="840">
  9. <MissingIndexes>
  10. <MissingIndexGroup Impact="85.1565">
  11. <MissingIndex Database="[EWR]" Schema="[dbo]" Table="[Event]">
  12. <ColumnGroup Usage="INEQUALITY">
  13. <Column Name="[EventTypeID]" ColumnId="2" />
  14. <Column Name="[PLCTimeStamp]" ColumnId="3" />
  15. </ColumnGroup>
  16. <ColumnGroup Usage="INCLUDE">
  17. <Column Name="[ID]" ColumnId="1" />
  18. <Column Name="[DeviceID]" ColumnId="5" />
  19. <Column Name="[Data1]" ColumnId="7" />
  20. <Column Name="[Data2]" ColumnId="8" />
  21. <Column Name="[IATA]" ColumnId="15" />
  22. </ColumnGroup>
  23. </MissingIndex>
  24. </MissingIndexGroup>
  25. </MissingIndexes>
  26. <RelOp AvgRowSize="159" EstimateCPU="0.0285355" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="3.18132" LogicalOp="Gather Streams" NodeId="0" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="58.4186">
  27. <OutputList>
  28. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="ID" />
  29. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="EventTypeID" />
  30. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="PLCTimeStamp" />
  31. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="Data1" />
  32. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="Data2" />
  33. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="IATA" />
  34. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[EventType]" Column="Description" />
  35. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Device]" Column="Name" />
  36. </OutputList>
  37. <RunTimeInformation>
  38. <RunTimeCountersPerThread Thread="0" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
  39. </RunTimeInformation>
  40. <Parallelism>
  41. <OrderBy>
  42. <OrderByColumn Ascending="true">
  43. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="ID" />
  44. </OrderByColumn>
  45. </OrderBy>
  46. <RelOp AvgRowSize="159" EstimateCPU="3.32448E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="3.18132" LogicalOp="Inner Join" NodeId="1" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="58.39">
  47. <OutputList>
  48. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="ID" />
  49. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="EventTypeID" />
  50. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="PLCTimeStamp" />
  51. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="Data1" />
  52. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="Data2" />
  53. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="IATA" />
  54. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[EventType]" Column="Description" />
  55. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Device]" Column="Name" />
  56. </OutputList>
  57. <RunTimeInformation>
  58. <RunTimeCountersPerThread Thread="8" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
  59. <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
  60. <RunTimeCountersPerThread Thread="7" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
  61. <RunTimeCountersPerThread Thread="5" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
  62. <RunTimeCountersPerThread Thread="6" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
  63. <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
  64. <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
  65. <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
  66. <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
  67. </RunTimeInformation>
  68. <NestedLoops Optimized="false">
  69. <OuterReferences>
  70. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="DeviceID" />
  71. </OuterReferences>
  72. <RelOp AvgRowSize="111" EstimateCPU="3.32448E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="3.18132" LogicalOp="Inner Join" NodeId="2" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="58.3829">
  73. <OutputList>
  74. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="ID" />
  75. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="EventTypeID" />
  76. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="PLCTimeStamp" />
  77. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="DeviceID" />
  78. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="Data1" />
  79. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="Data2" />
  80. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="IATA" />
  81. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[EventType]" Column="Description" />
  82. </OutputList>
  83. <RunTimeInformation>
  84. <RunTimeCountersPerThread Thread="8" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
  85. <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
  86. <RunTimeCountersPerThread Thread="7" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
  87. <RunTimeCountersPerThread Thread="5" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
  88. <RunTimeCountersPerThread Thread="6" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
  89. <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
  90. <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
  91. <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
  92. <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
  93. </RunTimeInformation>
  94. <NestedLoops Optimized="false">
  95. <OuterReferences>
  96. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="EventTypeID" />
  97. </OuterReferences>
  98. <RelOp AvgRowSize="59" EstimateCPU="1.11178" EstimateIO="53.1424" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="3.18132" LogicalOp="Clustered Index Scan" NodeId="3" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="54.2542" TableCardinality="4042700">
  99. <OutputList>
  100. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="ID" />
  101. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="EventTypeID" />
  102. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="PLCTimeStamp" />
  103. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="DeviceID" />
  104. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="Data1" />
  105. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="Data2" />
  106. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="IATA" />
  107. </OutputList>
  108. <RunTimeInformation>
  109. <RunTimeCountersPerThread Thread="8" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
  110. <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
  111. <RunTimeCountersPerThread Thread="7" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
  112. <RunTimeCountersPerThread Thread="5" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
  113. <RunTimeCountersPerThread Thread="6" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
  114. <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
  115. <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
  116. <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
  117. <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
  118. </RunTimeInformation>
  119. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
  120. <DefinedValues>
  121. <DefinedValue>
  122. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="ID" />
  123. </DefinedValue>
  124. <DefinedValue>
  125. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="EventTypeID" />
  126. </DefinedValue>
  127. <DefinedValue>
  128. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="PLCTimeStamp" />
  129. </DefinedValue>
  130. <DefinedValue>
  131. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="DeviceID" />
  132. </DefinedValue>
  133. <DefinedValue>
  134. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="Data1" />
  135. </DefinedValue>
  136. <DefinedValue>
  137. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="Data2" />
  138. </DefinedValue>
  139. <DefinedValue>
  140. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="IATA" />
  141. </DefinedValue>
  142. </DefinedValues>
  143. <Object Database="[EWR]" Schema="[dbo]" Table="[Event]" Index="[PK_Event]" IndexKind="Clustered" />
  144. <Predicate>
  145. <ScalarOperator ScalarString="[EWR].[dbo].[Event].[PLCTimeStamp]&gt;='2011-01-28 00:00:00.000' AND [EWR].[dbo].[Event].[PLCTimeStamp]&lt;='2011-01-29 00:00:00.000' AND [EWR].[dbo].[Event].[IATA] like N'%0005836217%' AND ([EWR].[dbo].[Event].[EventTypeID]=(3) OR [EWR].[dbo].[Event].[EventTypeID]=(30) OR [EWR].[dbo].[Event].[EventTypeID]=(40) OR [EWR].[dbo].[Event].[EventTypeID]=(41) OR [EWR].[dbo].[Event].[EventTypeID]=(42) OR [EWR].[dbo].[Event].[EventTypeID]=(46) OR [EWR].[dbo].[Event].[EventTypeID]=(49) OR [EWR].[dbo].[Event].[EventTypeID]=(50))">
  146. <Logical Operation="AND">
  147. <ScalarOperator>
  148. <Compare CompareOp="GE">
  149. <ScalarOperator>
  150. <Identifier>
  151. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="PLCTimeStamp" />
  152. </Identifier>
  153. </ScalarOperator>
  154. <ScalarOperator>
  155. <Const ConstValue="'2011-01-28 00:00:00.000'" />
  156. </ScalarOperator>
  157. </Compare>
  158. </ScalarOperator>
  159. <ScalarOperator>
  160. <Compare CompareOp="LE">
  161. <ScalarOperator>
  162. <Identifier>
  163. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="PLCTimeStamp" />
  164. </Identifier>
  165. </ScalarOperator>
  166. <ScalarOperator>
  167. <Const ConstValue="'2011-01-29 00:00:00.000'" />
  168. </ScalarOperator>
  169. </Compare>
  170. </ScalarOperator>
  171. <ScalarOperator>
  172. <Intrinsic FunctionName="like">
  173. <ScalarOperator>
  174. <Identifier>
  175. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="IATA" />
  176. </Identifier>
  177. </ScalarOperator>
  178. <ScalarOperator>
  179. <Const ConstValue="N'%0005836217%'" />
  180. </ScalarOperator>
  181. </Intrinsic>
  182. </ScalarOperator>
  183. <ScalarOperator>
  184. <Logical Operation="OR">
  185. <ScalarOperator>
  186. <Compare CompareOp="EQ">
  187. <ScalarOperator>
  188. <Identifier>
  189. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="EventTypeID" />
  190. </Identifier>
  191. </ScalarOperator>
  192. <ScalarOperator>
  193. <Const ConstValue="(3)" />
  194. </ScalarOperator>
  195. </Compare>
  196. </ScalarOperator>
  197. <ScalarOperator>
  198. <Compare CompareOp="EQ">
  199. <ScalarOperator>
  200. <Identifier>
  201. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="EventTypeID" />
  202. </Identifier>
  203. </ScalarOperator>
  204. <ScalarOperator>
  205. <Const ConstValue="(30)" />
  206. </ScalarOperator>
  207. </Compare>
  208. </ScalarOperator>
  209. <ScalarOperator>
  210. <Compare CompareOp="EQ">
  211. <ScalarOperator>
  212. <Identifier>
  213. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="EventTypeID" />
  214. </Identifier>
  215. </ScalarOperator>
  216. <ScalarOperator>
  217. <Const ConstValue="(40)" />
  218. </ScalarOperator>
  219. </Compare>
  220. </ScalarOperator>
  221. <ScalarOperator>
  222. <Compare CompareOp="EQ">
  223. <ScalarOperator>
  224. <Identifier>
  225. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="EventTypeID" />
  226. </Identifier>
  227. </ScalarOperator>
  228. <ScalarOperator>
  229. <Const ConstValue="(41)" />
  230. </ScalarOperator>
  231. </Compare>
  232. </ScalarOperator>
  233. <ScalarOperator>
  234. <Compare CompareOp="EQ">
  235. <ScalarOperator>
  236. <Identifier>
  237. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="EventTypeID" />
  238. </Identifier>
  239. </ScalarOperator>
  240. <ScalarOperator>
  241. <Const ConstValue="(42)" />
  242. </ScalarOperator>
  243. </Compare>
  244. </ScalarOperator>
  245. <ScalarOperator>
  246. <Compare CompareOp="EQ">
  247. <ScalarOperator>
  248. <Identifier>
  249. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="EventTypeID" />
  250. </Identifier>
  251. </ScalarOperator>
  252. <ScalarOperator>
  253. <Const ConstValue="(46)" />
  254. </ScalarOperator>
  255. </Compare>
  256. </ScalarOperator>
  257. <ScalarOperator>
  258. <Compare CompareOp="EQ">
  259. <ScalarOperator>
  260. <Identifier>
  261. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="EventTypeID" />
  262. </Identifier>
  263. </ScalarOperator>
  264. <ScalarOperator>
  265. <Const ConstValue="(49)" />
  266. </ScalarOperator>
  267. </Compare>
  268. </ScalarOperator>
  269. <ScalarOperator>
  270. <Compare CompareOp="EQ">
  271. <ScalarOperator>
  272. <Identifier>
  273. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="EventTypeID" />
  274. </Identifier>
  275. </ScalarOperator>
  276. <ScalarOperator>
  277. <Const ConstValue="(50)" />
  278. </ScalarOperator>
  279. </Compare>
  280. </ScalarOperator>
  281. </Logical>
  282. </ScalarOperator>
  283. </Logical>
  284. </ScalarOperator>
  285. </Predicate>
  286. </IndexScan>
  287. </RelOp>
  288. <RelOp AvgRowSize="65" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="2.0119" EstimateRewinds="0.169421" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="4" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00515181" TableCardinality="22">
  289. <OutputList>
  290. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[EventType]" Column="Description" />
  291. </OutputList>
  292. <RunTimeInformation>
  293. <RunTimeCountersPerThread Thread="8" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
  294. <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
  295. <RunTimeCountersPerThread Thread="7" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
  296. <RunTimeCountersPerThread Thread="5" ActualRows="3" ActualEndOfScans="0" ActualExecutions="3" />
  297. <RunTimeCountersPerThread Thread="6" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
  298. <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
  299. <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
  300. <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
  301. <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
  302. </RunTimeInformation>
  303. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
  304. <DefinedValues>
  305. <DefinedValue>
  306. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[EventType]" Column="Description" />
  307. </DefinedValue>
  308. </DefinedValues>
  309. <Object Database="[EWR]" Schema="[dbo]" Table="[EventType]" Index="[PK_EventType]" IndexKind="Clustered" />
  310. <SeekPredicates>
  311. <SeekPredicateNew>
  312. <SeekKeys>
  313. <Prefix ScanType="EQ">
  314. <RangeColumns>
  315. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[EventType]" Column="ID" />
  316. </RangeColumns>
  317. <RangeExpressions>
  318. <ScalarOperator ScalarString="[EWR].[dbo].[Event].[EventTypeID]">
  319. <Identifier>
  320. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="EventTypeID" />
  321. </Identifier>
  322. </ScalarOperator>
  323. </RangeExpressions>
  324. </Prefix>
  325. </SeekKeys>
  326. </SeekPredicateNew>
  327. </SeekPredicates>
  328. <Predicate>
  329. <ScalarOperator ScalarString="[EWR].[dbo].[EventType].[ID]&gt;=(3) AND [EWR].[dbo].[EventType].[ID]&lt;=(50)">
  330. <Logical Operation="AND">
  331. <ScalarOperator>
  332. <Compare CompareOp="GE">
  333. <ScalarOperator>
  334. <Identifier>
  335. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[EventType]" Column="ID" />
  336. </Identifier>
  337. </ScalarOperator>
  338. <ScalarOperator>
  339. <Const ConstValue="(3)" />
  340. </ScalarOperator>
  341. </Compare>
  342. </ScalarOperator>
  343. <ScalarOperator>
  344. <Compare CompareOp="LE">
  345. <ScalarOperator>
  346. <Identifier>
  347. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[EventType]" Column="ID" />
  348. </Identifier>
  349. </ScalarOperator>
  350. <ScalarOperator>
  351. <Const ConstValue="(50)" />
  352. </ScalarOperator>
  353. </Compare>
  354. </ScalarOperator>
  355. </Logical>
  356. </ScalarOperator>
  357. </Predicate>
  358. </IndexScan>
  359. </RelOp>
  360. </NestedLoops>
  361. </RelOp>
  362. <RelOp AvgRowSize="61" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="2.18132" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="5" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00715937" TableCardinality="2806">
  363. <OutputList>
  364. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Device]" Column="Name" />
  365. </OutputList>
  366. <RunTimeInformation>
  367. <RunTimeCountersPerThread Thread="8" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
  368. <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
  369. <RunTimeCountersPerThread Thread="7" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
  370. <RunTimeCountersPerThread Thread="5" ActualRows="3" ActualEndOfScans="0" ActualExecutions="3" />
  371. <RunTimeCountersPerThread Thread="6" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
  372. <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
  373. <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
  374. <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
  375. <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
  376. </RunTimeInformation>
  377. <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
  378. <DefinedValues>
  379. <DefinedValue>
  380. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Device]" Column="Name" />
  381. </DefinedValue>
  382. </DefinedValues>
  383. <Object Database="[EWR]" Schema="[dbo]" Table="[Device]" Index="[PK_Device]" IndexKind="Clustered" />
  384. <SeekPredicates>
  385. <SeekPredicateNew>
  386. <SeekKeys>
  387. <Prefix ScanType="EQ">
  388. <RangeColumns>
  389. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Device]" Column="ID" />
  390. </RangeColumns>
  391. <RangeExpressions>
  392. <ScalarOperator ScalarString="[EWR].[dbo].[Event].[DeviceID]">
  393. <Identifier>
  394. <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="DeviceID" />
  395. </Identifier>
  396. </ScalarOperator>
  397. </RangeExpressions>
  398. </Prefix>
  399. </SeekKeys>
  400. </SeekPredicateNew>
  401. </SeekPredicates>
  402. </IndexScan>
  403. </RelOp>
  404. </NestedLoops>
  405. </RelOp>
  406. </Parallelism>
  407. </RelOp>
  408. </QueryPlan>
  409. </StmtSimple>
  410. </Statements>
  411. </Batch>
  412. </BatchSequence>
  413. </ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement