Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.2" Build="12.0.4213.0"><BatchSequence><Batch><Statements><StmtSimple StatementSubTreeCost="0.0409163" StatementEstRows="1" StatementOptmLevel="FULL" QueryHash="0xB3143695BA6FA9A4" QueryPlanHash="0x5725CD5FC3166DDD" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="70"><QueryPlan CachedPlanSize="64" CompileTime="10" CompileCPU="10" CompileMemory="976"><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="544"/><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="366995" EstimatedPagesCached="183497" EstimatedAvailableDegreeOfParallelism="4"/><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0409163" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[annonym-portal]" Schema="[dbo]" Table="[StringData]" Alias="[Extent1]" Column="TimeStamp"/><ColumnReference Column="Expr1005"/></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1005"/><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"/></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="1" PhysicalOp="Sort" LogicalOp="Distinct Sort" EstimateRows="1" EstimateIO="0.0112613" EstimateCPU="0.000100015" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0409162" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[annonym-portal]" Schema="[dbo]" Table="[StringData]" Alias="[Extent1]" Column="TimeStamp"/></OutputList><MemoryFractions Input="1" Output="1"/><Sort Distinct="1"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[annonym-portal]" Schema="[dbo]" Table="[StringData]" Alias="[Extent1]" Column="TimeStamp"/></OrderByColumn></OrderBy><RelOp NodeId="2" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0295549" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[annonym-portal]" Schema="[dbo]" Table="[StringData]" Alias="[Extent1]" Column="TimeStamp"/></OutputList><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="[annonym-portal]" Schema="[dbo]" Table="[DCDistributionBox]" Alias="[Extent3]" Column="DataLoggerID"/></OuterReferences><RelOp NodeId="3" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0262677" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[annonym-portal]" Schema="[dbo]" Table="[StringData]" Alias="[Extent1]" Column="TimeStamp"/><ColumnReference Database="[annonym-portal]" Schema="[dbo]" Table="[DCDistributionBox]" Alias="[Extent3]" Column="DataLoggerID"/></OutputList><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="[annonym-portal]" Schema="[dbo]" Table="[DCString]" Alias="[Extent2]" Column="DCDistributionBoxID"/></OuterReferences><RelOp NodeId="4" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0229804" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[annonym-portal]" Schema="[dbo]" Table="[StringData]" Alias="[Extent1]" Column="TimeStamp"/><ColumnReference Database="[annonym-portal]" Schema="[dbo]" Table="[DCString]" Alias="[Extent2]" Column="DCDistributionBoxID"/></OutputList><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="[annonym-portal]" Schema="[dbo]" Table="[StringData]" Alias="[Extent1]" Column="DCStringID"/></OuterReferences><RelOp NodeId="5" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.01875" EstimateCPU="0.0009431" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0196931" TableCardinality="2.37653e+008" Parallel="0" Partitioned="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[annonym-portal]" Schema="[dbo]" Table="[StringData]" Alias="[Extent1]" Column="DCStringID"/><ColumnReference Database="[annonym-portal]" Schema="[dbo]" Table="[StringData]" Alias="[Extent1]" Column="TimeStamp"/></OutputList><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[annonym-portal]" Schema="[dbo]" Table="[StringData]" Alias="[Extent1]" Column="DCStringID"/></DefinedValue><DefinedValue><ColumnReference Database="[annonym-portal]" Schema="[dbo]" Table="[StringData]" Alias="[Extent1]" Column="TimeStamp"/></DefinedValue></DefinedValues><Object Database="[annonym-portal]" Schema="[dbo]" Table="[StringData]" Index="[PK_StringData1]" Alias="[Extent1]" IndexKind="Clustered" Storage="RowStore"/><SeekPredicates><SeekPredicateNew><SeekKeys><StartRange ScanType="GE"><RangeColumns><ColumnReference Column="PtnId1000"/></RangeColumns><RangeExpressions><ScalarOperator ScalarString="RangePartitionNew([@p__linq__1],(0),'2012-01-01 00:00:00.000','2012-02-01 00:00:00.000','2012-03-01 00:00:00.000','2012-04-01 00:00:00.000','2012-05-01 00:00:00.000','2012-06-01 00:00:00.000','2012-07-01 00:00:00.000','2012-08-01 00:00:00.000','2012-09-01 00:00:00.000','2012-10-01 00:00:00.000','2012-11-01 00:00:00.000','2012-12-01 00:00:00.000','2013-01-01 00:00:00.000','2013-02-01 00:00:00.000','2013-03-01 00:00:00.000','2013-04-01 00:00:00.000','2013-05-01 00:00:00.000','2013-06-01 00:00:00.000','2013-07-01 00:00:00.000','2013-08-01 00:00:00.000','2013-09-01 00:00:00.000','2013-10-01 00:00:00.000','2013-11-01 00:00:00.000','2013-12-01 00:00:00.000','2014-01-01 00:00:00.000','2014-02-01 00:00:00.000','2014-03-01 00:00:00.000','2014-04-01 00:00:00.000','2014-05-01 00:00:00.000','2014-06-01 00:00:00.000','2014-07-01 00:00:00.000','2014-08-01 00:00:00.000','2014-09-01 00:00:00.000','2014-10-01 00:00:00.000','2014-11-01 00:00:00.000','2014-12-01 00:00:00.000','2015-01-01 00:00:00.000','2015-02-01 00:00:00.000','2015-03-01 00:00:00.000','2015-04-01 00:00:00.000','2015-05-01 00:00:00.000','2015-06-01 00:00:00.000','2015-07-01 00:00:00.000','2015-08-01 00:00:00.000','2015-09-01 00:00:00.000','2015-10-01 00:00:00.000','2015-11-01 00:00:00.000','2015-12-01 00:00:00.000','2016-01-01 00:00:00.000','2016-02-01 00:00:00.000','2016-03-01 00:00:00.000','2016-04-01 00:00:00.000','2016-05-01 00:00:00.000','2016-06-01 00:00:00.000','2016-07-01 00:00:00.000','2016-08-01 00:00:00.000','2016-09-01 00:00:00.000','2016-10-01 00:00:00.000','2016-11-01 00:00:00.000','2016-12-01 00:00:00.000','2017-01-01 00:00:00.000')"><Intrinsic FunctionName="RangePartitionNew"><ScalarOperator><Identifier><ColumnReference Column="@p__linq__1"/></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"/></ScalarOperator><ScalarOperator><Const ConstValue="'2012-01-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2012-02-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2012-03-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2012-04-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2012-05-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2012-06-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2012-07-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2012-08-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2012-09-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2012-10-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2012-11-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2012-12-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2013-01-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2013-02-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2013-03-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2013-04-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2013-05-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2013-06-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2013-07-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2013-08-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2013-09-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2013-10-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2013-11-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2013-12-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2014-01-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2014-02-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2014-03-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2014-04-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2014-05-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2014-06-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2014-07-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2014-08-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2014-09-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2014-10-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2014-11-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2014-12-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2015-01-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2015-02-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2015-03-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2015-04-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2015-05-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2015-06-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2015-07-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2015-08-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2015-09-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2015-10-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2015-11-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2015-12-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2016-01-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2016-02-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2016-03-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2016-04-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2016-05-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2016-06-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2016-07-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2016-08-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2016-09-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2016-10-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2016-11-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2016-12-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2017-01-01 00:00:00.000'"/></ScalarOperator></Intrinsic></ScalarOperator></RangeExpressions></StartRange><EndRange ScanType="LE"><RangeColumns><ColumnReference Column="PtnId1000"/></RangeColumns><RangeExpressions><ScalarOperator ScalarString="RangePartitionNew([@p__linq__2],(0),'2012-01-01 00:00:00.000','2012-02-01 00:00:00.000','2012-03-01 00:00:00.000','2012-04-01 00:00:00.000','2012-05-01 00:00:00.000','2012-06-01 00:00:00.000','2012-07-01 00:00:00.000','2012-08-01 00:00:00.000','2012-09-01 00:00:00.000','2012-10-01 00:00:00.000','2012-11-01 00:00:00.000','2012-12-01 00:00:00.000','2013-01-01 00:00:00.000','2013-02-01 00:00:00.000','2013-03-01 00:00:00.000','2013-04-01 00:00:00.000','2013-05-01 00:00:00.000','2013-06-01 00:00:00.000','2013-07-01 00:00:00.000','2013-08-01 00:00:00.000','2013-09-01 00:00:00.000','2013-10-01 00:00:00.000','2013-11-01 00:00:00.000','2013-12-01 00:00:00.000','2014-01-01 00:00:00.000','2014-02-01 00:00:00.000','2014-03-01 00:00:00.000','2014-04-01 00:00:00.000','2014-05-01 00:00:00.000','2014-06-01 00:00:00.000','2014-07-01 00:00:00.000','2014-08-01 00:00:00.000','2014-09-01 00:00:00.000','2014-10-01 00:00:00.000','2014-11-01 00:00:00.000','2014-12-01 00:00:00.000','2015-01-01 00:00:00.000','2015-02-01 00:00:00.000','2015-03-01 00:00:00.000','2015-04-01 00:00:00.000','2015-05-01 00:00:00.000','2015-06-01 00:00:00.000','2015-07-01 00:00:00.000','2015-08-01 00:00:00.000','2015-09-01 00:00:00.000','2015-10-01 00:00:00.000','2015-11-01 00:00:00.000','2015-12-01 00:00:00.000','2016-01-01 00:00:00.000','2016-02-01 00:00:00.000','2016-03-01 00:00:00.000','2016-04-01 00:00:00.000','2016-05-01 00:00:00.000','2016-06-01 00:00:00.000','2016-07-01 00:00:00.000','2016-08-01 00:00:00.000','2016-09-01 00:00:00.000','2016-10-01 00:00:00.000','2016-11-01 00:00:00.000','2016-12-01 00:00:00.000','2017-01-01 00:00:00.000')"><Intrinsic FunctionName="RangePartitionNew"><ScalarOperator><Identifier><ColumnReference Column="@p__linq__2"/></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"/></ScalarOperator><ScalarOperator><Const ConstValue="'2012-01-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2012-02-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2012-03-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2012-04-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2012-05-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2012-06-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2012-07-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2012-08-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2012-09-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2012-10-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2012-11-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2012-12-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2013-01-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2013-02-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2013-03-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2013-04-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2013-05-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2013-06-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2013-07-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2013-08-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2013-09-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2013-10-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2013-11-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2013-12-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2014-01-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2014-02-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2014-03-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2014-04-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2014-05-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2014-06-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2014-07-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2014-08-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2014-09-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2014-10-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2014-11-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2014-12-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2015-01-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2015-02-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2015-03-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2015-04-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2015-05-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2015-06-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2015-07-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2015-08-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2015-09-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2015-10-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2015-11-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2015-12-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2016-01-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2016-02-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2016-03-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2016-04-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2016-05-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2016-06-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2016-07-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2016-08-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2016-09-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2016-10-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2016-11-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2016-12-01 00:00:00.000'"/></ScalarOperator><ScalarOperator><Const ConstValue="'2017-01-01 00:00:00.000'"/></ScalarOperator></Intrinsic></ScalarOperator></RangeExpressions></EndRange></SeekKeys><SeekKeys><StartRange ScanType="LT"><RangeColumns><ColumnReference Database="[annonym-portal]" Schema="[dbo]" Table="[StringData]" Alias="[Extent1]" Column="TimeStamp"/></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[@p__linq__2]"><Identifier><ColumnReference Column="@p__linq__2"/></Identifier></ScalarOperator></RangeExpressions></StartRange><EndRange ScanType="GE"><RangeColumns><ColumnReference Database="[annonym-portal]" Schema="[dbo]" Table="[StringData]" Alias="[Extent1]" Column="TimeStamp"/></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[@p__linq__1]"><Identifier><ColumnReference Column="@p__linq__1"/></Identifier></ScalarOperator></RangeExpressions></EndRange></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp><RelOp NodeId="6" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="9642" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[annonym-portal]" Schema="[dbo]" Table="[DCString]" Alias="[Extent2]" Column="DCDistributionBoxID"/></OutputList><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[annonym-portal]" Schema="[dbo]" Table="[DCString]" Alias="[Extent2]" Column="DCDistributionBoxID"/></DefinedValue></DefinedValues><Object Database="[annonym-portal]" Schema="[dbo]" Table="[DCString]" Index="[IX_ID_DCDistributionBoxID]" Alias="[Extent2]" IndexKind="NonClustered" Storage="RowStore"/><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[annonym-portal]" Schema="[dbo]" Table="[DCString]" Alias="[Extent2]" Column="ID"/></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[annonym-portal].[dbo].[StringData].[DCStringID] as [Extent1].[DCStringID]"><Identifier><ColumnReference Database="[annonym-portal]" Schema="[dbo]" Table="[StringData]" Alias="[Extent1]" Column="DCStringID"/></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp><RelOp NodeId="7" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="2146" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[annonym-portal]" Schema="[dbo]" Table="[DCDistributionBox]" Alias="[Extent3]" Column="DataLoggerID"/></OutputList><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[annonym-portal]" Schema="[dbo]" Table="[DCDistributionBox]" Alias="[Extent3]" Column="DataLoggerID"/></DefinedValue></DefinedValues><Object Database="[annonym-portal]" Schema="[dbo]" Table="[DCDistributionBox]" Index="[IX_ID_DataLoggerID]" Alias="[Extent3]" IndexKind="NonClustered" Storage="RowStore"/><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[annonym-portal]" Schema="[dbo]" Table="[DCDistributionBox]" Alias="[Extent3]" Column="ID"/></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[annonym-portal].[dbo].[DCString].[DCDistributionBoxID] as [Extent2].[DCDistributionBoxID]"><Identifier><ColumnReference Database="[annonym-portal]" Schema="[dbo]" Table="[DCString]" Alias="[Extent2]" Column="DCDistributionBoxID"/></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp><RelOp NodeId="8" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="1148" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList/><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues/><Object Database="[annonym-portal]" Schema="[dbo]" Table="[DataLogger]" Index="[IX_ID_ProjectID]" Alias="[Extent4]" IndexKind="NonClustered" Storage="RowStore"/><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[annonym-portal]" Schema="[dbo]" Table="[DataLogger]" Alias="[Extent4]" Column="ID"/><ColumnReference Database="[annonym-portal]" Schema="[dbo]" Table="[DataLogger]" Alias="[Extent4]" Column="ProjectID"/></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[annonym-portal].[dbo].[DCDistributionBox].[DataLoggerID] as [Extent3].[DataLoggerID]"><Identifier><ColumnReference Database="[annonym-portal]" Schema="[dbo]" Table="[DCDistributionBox]" Alias="[Extent3]" Column="DataLoggerID"/></Identifier></ScalarOperator><ScalarOperator ScalarString="CONVERT_IMPLICIT(bigint,[@p__linq__0],0)"><Identifier><ColumnReference Column="ConstExpr1006"><ScalarOperator><Convert DataType="bigint" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="@p__linq__0"/></Identifier></ScalarOperator></Convert></ScalarOperator></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp></Sort></RelOp></ComputeScalar></RelOp><ParameterList><ColumnReference Column="@p__linq__2" ParameterCompiledValue="'2016-02-07 00:00:00.000'"/><ColumnReference Column="@p__linq__1" ParameterCompiledValue="'2016-02-06 00:00:00.000'"/><ColumnReference Column="@p__linq__0" ParameterCompiledValue="(20827)"/></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
