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="12.2087" StatementEstRows="517196" StatementOptmLevel="FULL" QueryHash="0xB3143695BA6FA9A4" QueryPlanHash="0x9341E13C8CBC3C7D" CardinalityEstimationModelVersion="70"><QueryPlan CachedPlanSize="96" CompileTime="35" CompileCPU="35" CompileMemory="1400"><ThreadStat Branches="2"/><MemoryGrantInfo SerialRequiredMemory="2048" SerialDesiredMemory="50688"/><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="366995" EstimatedPagesCached="183497" EstimatedAvailableDegreeOfParallelism="4"/><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="517196" EstimateIO="0" EstimateCPU="0.0517196" AvgRowSize="19" EstimatedTotalSubtreeCost="12.2087" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[powerdoo-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="Parallelism" LogicalOp="Gather Streams" EstimateRows="517196" EstimateIO="0" EstimateCPU="0.306428" AvgRowSize="15" EstimatedTotalSubtreeCost="12.157" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[StringData]" Alias="[Extent1]" Column="TimeStamp"/></OutputList><Parallelism><RelOp NodeId="2" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="517196" EstimateIO="0" EstimateCPU="3.87145" AvgRowSize="15" EstimatedTotalSubtreeCost="11.8506" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[StringData]" Alias="[Extent1]" Column="TimeStamp"/></OutputList><MemoryFractions Input="0.991776" Output="1"/><Hash><DefinedValues/><HashKeysBuild><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[StringData]" Alias="[Extent1]" Column="TimeStamp"/></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[powerdoo-portal].[dbo].[StringData].[TimeStamp] as [Extent1].[TimeStamp] = [powerdoo-portal].[dbo].[StringData].[TimeStamp] as [Extent1].[TimeStamp]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[StringData]" Alias="[Extent1]" Column="TimeStamp"/></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[StringData]" Alias="[Extent1]" Column="TimeStamp"/></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="3" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="697415" EstimateIO="0" EstimateCPU="0.528939" AvgRowSize="15" EstimatedTotalSubtreeCost="7.97911" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[StringData]" Alias="[Extent1]" Column="TimeStamp"/></OutputList><Parallelism PartitioningType="Hash"><PartitionColumns><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[StringData]" Alias="[Extent1]" Column="TimeStamp"/></PartitionColumns><RelOp NodeId="4" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="697415" EstimateIO="0" EstimateCPU="0.728799" AvgRowSize="15" EstimatedTotalSubtreeCost="7.45017" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[StringData]" Alias="[Extent1]" Column="TimeStamp"/></OutputList><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[DCString]" Alias="[Extent2]" Column="ID"/></OuterReferences><RelOp NodeId="5" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="242.458" EstimateIO="0" EstimateCPU="0.0339742" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0953358" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[DCString]" Alias="[Extent2]" Column="ID"/></OutputList><MemoryFractions Input="1" Output="0.00822368"/><Hash><DefinedValues/><HashKeysBuild><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[DCDistributionBox]" Alias="[Extent3]" Column="ID"/></HashKeysBuild><HashKeysProbe><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[DCString]" Alias="[Extent2]" Column="DCDistributionBoxID"/></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[powerdoo-portal].[dbo].[DCString].[DCDistributionBoxID] as [Extent2].[DCDistributionBoxID]=[powerdoo-portal].[dbo].[DCDistributionBox].[ID] as [Extent3].[ID]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[DCString]" Alias="[Extent2]" Column="DCDistributionBoxID"/></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[DCDistributionBox]" Alias="[Extent3]" Column="ID"/></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="6" PhysicalOp="Bitmap" LogicalOp="Bitmap Create" EstimateRows="49.2515" EstimateIO="0" EstimateCPU="0.0286059" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0355428" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[DCDistributionBox]" Alias="[Extent3]" Column="ID"/></OutputList><Bitmap><DefinedValues><DefinedValue><ColumnReference Column="Bitmap1007"/></DefinedValue></DefinedValues><HashKeys><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[DCDistributionBox]" Alias="[Extent3]" Column="ID"/></HashKeys><RelOp NodeId="7" PhysicalOp="Parallelism" LogicalOp="Distribute Streams" EstimateRows="49.2515" EstimateIO="0" EstimateCPU="0.0286059" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0355428" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[DCDistributionBox]" Alias="[Extent3]" Column="ID"/></OutputList><Parallelism PartitioningType="Broadcast"><RelOp NodeId="8" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="49.2515" EstimateIO="0" EstimateCPU="0.000205871" AvgRowSize="15" EstimatedTotalSubtreeCost="0.00693688" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[DCDistributionBox]" Alias="[Extent3]" Column="ID"/></OutputList><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[DataLogger]" Alias="[Extent4]" Column="ID"/></OuterReferences><RelOp NodeId="9" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1.12657" EstimateIO="0.003125" EstimateCPU="0.000158239" AvgRowSize="15" EstimatedTotalSubtreeCost="0.00328324" TableCardinality="1148" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[DataLogger]" Alias="[Extent4]" Column="ID"/></OutputList><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[DataLogger]" Alias="[Extent4]" Column="ID"/></DefinedValue></DefinedValues><Object Database="[powerdoo-portal]" Schema="[dbo]" Table="[DataLogger]" Index="[IX_ProjectID]" Alias="[Extent4]" IndexKind="NonClustered" Storage="RowStore"/><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[DataLogger]" Alias="[Extent4]" Column="ProjectID"/></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[@p__linq__0]"><Identifier><ColumnReference Column="@p__linq__0"/></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp><RelOp NodeId="10" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="43.7179" EstimateIO="0.003125" EstimateCPU="0.00020509" AvgRowSize="15" EstimatedTotalSubtreeCost="0.00344777" TableCardinality="2146" Parallel="0" EstimateRebinds="0.126575" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[DCDistributionBox]" Alias="[Extent3]" Column="ID"/></OutputList><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[DCDistributionBox]" Alias="[Extent3]" Column="ID"/></DefinedValue></DefinedValues><Object Database="[powerdoo-portal]" Schema="[dbo]" Table="[DCDistributionBox]" Index="[IX_DataLoggerID]" Alias="[Extent3]" IndexKind="NonClustered" Storage="RowStore"/><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[DCDistributionBox]" Alias="[Extent3]" Column="DataLoggerID"/></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[powerdoo-portal].[dbo].[DataLogger].[ID] as [Extent4].[ID]"><Identifier><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[DataLogger]" Alias="[Extent4]" Column="ID"/></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp></Parallelism></RelOp></Bitmap></RelOp><RelOp NodeId="11" PhysicalOp="Index Scan" LogicalOp="Index Scan" EstimateRows="9642" EstimateIO="0.023125" EstimateCPU="0.0026908" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0258158" TableCardinality="9642" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[DCString]" Alias="[Extent2]" Column="ID"/><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[DCString]" Alias="[Extent2]" Column="DCDistributionBoxID"/></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[DCString]" Alias="[Extent2]" Column="ID"/></DefinedValue><DefinedValue><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[DCString]" Alias="[Extent2]" Column="DCDistributionBoxID"/></DefinedValue></DefinedValues><Object Database="[powerdoo-portal]" Schema="[dbo]" Table="[DCString]" Index="[IX_ID_DCDistributionBoxID]" Alias="[Extent2]" IndexKind="NonClustered" Storage="RowStore"/><Predicate><ScalarOperator ScalarString="PROBE([Bitmap1007],[powerdoo-portal].[dbo].[DCString].[DCDistributionBoxID] as [Extent2].[DCDistributionBoxID],N'[IN ROW]')"><Intrinsic FunctionName="PROBE"><ScalarOperator><Identifier><ColumnReference Column="Bitmap1007"/></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[DCString]" Alias="[Extent2]" Column="DCDistributionBoxID"/></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="N'[IN ROW]'"/></ScalarOperator></Intrinsic></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp><RelOp NodeId="13" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="2876.43" EstimateIO="0.0231944" EstimateCPU="0.00410608" AvgRowSize="15" EstimatedTotalSubtreeCost="6.62604" TableCardinality="2.37653e+008" Parallel="1" Partitioned="1" EstimateRebinds="241.458" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[powerdoo-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="[powerdoo-portal]" Schema="[dbo]" Table="[StringData]" Alias="[Extent1]" Column="TimeStamp"/></DefinedValue></DefinedValues><Object Database="[powerdoo-portal]" Schema="[dbo]" Table="[StringData]" Index="[TimeStamp_DCCurrent-NonClusteredIndex]" Alias="[Extent1]" IndexKind="NonClustered" 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><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[StringData]" Alias="[Extent1]" Column="DCStringID"/></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[powerdoo-portal].[dbo].[DCString].[ID] as [Extent2].[ID]"><Identifier><ColumnReference Database="[powerdoo-portal]" Schema="[dbo]" Table="[DCString]" Alias="[Extent2]" Column="ID"/></Identifier></ScalarOperator></RangeExpressions></Prefix><StartRange ScanType="GE"><RangeColumns><ColumnReference Database="[powerdoo-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></StartRange><EndRange ScanType="LT"><RangeColumns><ColumnReference Database="[powerdoo-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></EndRange></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp></Parallelism></RelOp></Hash></RelOp></Parallelism></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
