Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?xml version="1.0" encoding="utf-16"?>
- <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">
- <BatchSequence>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="31" StatementEstRows="3.18132" StatementId="1" StatementOptmLevel="FULL" StatementSubTreeCost="58.4186" StatementText="Select [Event].ID, 
 [Event].[IATA], 
 [Device].Name,
 [EventType].[Description],
 [Event].Data1,
 [Event].Data2,
 [Event].PLCTimeStamp,
 [Event].EventTypeID
 from
 [Event] inner join [EventType] on [Event].EventTypeID = EventType.ID inner join [Device] on [Event].DeviceID = [Device].ID
 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">
- <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
- <QueryPlan DegreeOfParallelism="8" MemoryGrant="0" CachedPlanSize="40" CompileTime="82" CompileCPU="40" CompileMemory="840">
- <MissingIndexes>
- <MissingIndexGroup Impact="85.1565">
- <MissingIndex Database="[EWR]" Schema="[dbo]" Table="[Event]">
- <ColumnGroup Usage="INEQUALITY">
- <Column Name="[EventTypeID]" ColumnId="2" />
- <Column Name="[PLCTimeStamp]" ColumnId="3" />
- </ColumnGroup>
- <ColumnGroup Usage="INCLUDE">
- <Column Name="[ID]" ColumnId="1" />
- <Column Name="[DeviceID]" ColumnId="5" />
- <Column Name="[Data1]" ColumnId="7" />
- <Column Name="[Data2]" ColumnId="8" />
- <Column Name="[IATA]" ColumnId="15" />
- </ColumnGroup>
- </MissingIndex>
- </MissingIndexGroup>
- </MissingIndexes>
- <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">
- <OutputList>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="ID" />
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="EventTypeID" />
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="PLCTimeStamp" />
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="Data1" />
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="Data2" />
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="IATA" />
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[EventType]" Column="Description" />
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Device]" Column="Name" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Parallelism>
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="ID" />
- </OrderByColumn>
- </OrderBy>
- <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">
- <OutputList>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="ID" />
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="EventTypeID" />
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="PLCTimeStamp" />
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="Data1" />
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="Data2" />
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="IATA" />
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[EventType]" Column="Description" />
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Device]" Column="Name" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="8" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="7" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="5" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="6" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="DeviceID" />
- </OuterReferences>
- <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">
- <OutputList>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="ID" />
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="EventTypeID" />
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="PLCTimeStamp" />
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="DeviceID" />
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="Data1" />
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="Data2" />
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="IATA" />
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[EventType]" Column="Description" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="8" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="7" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="5" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="6" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="EventTypeID" />
- </OuterReferences>
- <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">
- <OutputList>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="ID" />
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="EventTypeID" />
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="PLCTimeStamp" />
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="DeviceID" />
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="Data1" />
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="Data2" />
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="IATA" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="8" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="7" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="5" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="6" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="ID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="EventTypeID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="PLCTimeStamp" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="DeviceID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="Data1" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="Data2" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="IATA" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[EWR]" Schema="[dbo]" Table="[Event]" Index="[PK_Event]" IndexKind="Clustered" />
- <Predicate>
- <ScalarOperator ScalarString="[EWR].[dbo].[Event].[PLCTimeStamp]>='2011-01-28 00:00:00.000' AND [EWR].[dbo].[Event].[PLCTimeStamp]<='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))">
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="GE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="PLCTimeStamp" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'2011-01-28 00:00:00.000'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="LE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="PLCTimeStamp" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'2011-01-29 00:00:00.000'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="IATA" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%0005836217%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="OR">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="EventTypeID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(3)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="EventTypeID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(30)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="EventTypeID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(40)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="EventTypeID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(41)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="EventTypeID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(42)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="EventTypeID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(46)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="EventTypeID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(49)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="EventTypeID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(50)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- <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">
- <OutputList>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[EventType]" Column="Description" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="8" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="7" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="5" ActualRows="3" ActualEndOfScans="0" ActualExecutions="3" />
- <RunTimeCountersPerThread Thread="6" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[EventType]" Column="Description" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[EWR]" Schema="[dbo]" Table="[EventType]" Index="[PK_EventType]" IndexKind="Clustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[EventType]" Column="ID" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[EWR].[dbo].[Event].[EventTypeID]">
- <Identifier>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="EventTypeID" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="[EWR].[dbo].[EventType].[ID]>=(3) AND [EWR].[dbo].[EventType].[ID]<=(50)">
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="GE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[EventType]" Column="ID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(3)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="LE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[EventType]" Column="ID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(50)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <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">
- <OutputList>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Device]" Column="Name" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="8" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="7" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="5" ActualRows="3" ActualEndOfScans="0" ActualExecutions="3" />
- <RunTimeCountersPerThread Thread="6" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Device]" Column="Name" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[EWR]" Schema="[dbo]" Table="[Device]" Index="[PK_Device]" IndexKind="Clustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Device]" Column="ID" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[EWR].[dbo].[Event].[DeviceID]">
- <Identifier>
- <ColumnReference Database="[EWR]" Schema="[dbo]" Table="[Event]" Column="DeviceID" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </Parallelism>
- </RelOp>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- </BatchSequence>
- </ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement