Skip to content

Instantly share code, notes, and snippets.

/gist:696e1c7d49656deeb918

Created January 6, 2016 16:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/696e1c7d49656deeb918 to your computer and use it in GitHub Desktop.
Save anonymous/696e1c7d49656deeb918 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
select
od.[Year],
AvgValue = avg(ObservationValue)
from dbo.ObservationDates od
join dbo.v_Observation o
on o.ObservationDateKey = od.DateKey
where
od.[Year] >= 2000 and od.[Year] < 2006
group by
od.[Year]
option (USE PLAN N'<?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.2" Build="12.0.4436.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementCompId="1" StatementEstRows="60.0079" StatementId="1" StatementOptmLevel="FULL" CardinalityEstimationModelVersion="120" StatementSubTreeCost="1034.33" StatementText="select &#xD;&#xA; od.[Year], &#xD;&#xA; AvgValue = avg(ObservationValue)&#xD;&#xA;from dbo.ObservationDates od&#xD;&#xA;join dbo.v_Observation o&#xD;&#xA; on o.ObservationDateKey = od.DateKey&#xD;&#xA;where &#xD;&#xA; od.[Year] &gt;= 2000 and od.[Year] &lt; 2006&#xD;&#xA;group by &#xD;&#xA; od.[Year]&#xD;&#xA;option (querytraceon 4199)" StatementType="SELECT" QueryHash="0xE01A45FFCD2D134E" QueryPlanHash="0x9EFEF831BB146D" RetrievedFromCache="false">
<StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
<QueryPlan CachedPlanSize="128" CompileTime="76" CompileCPU="76" CompileMemory="3584">
<ThreadStat Branches="1" />
<MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" />
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="52428" EstimatedPagesCached="13107" EstimatedAvailableDegreeOfParallelism="2" />
<RelOp AvgRowSize="28" EstimateCPU="6.00079E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="60.0079" LogicalOp="Compute Scalar" NodeId="1" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="1034.33">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="Year" />
<ColumnReference Column="Expr1037" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1037" />
<ScalarOperator ScalarString="CASE WHEN [globalagg1039]=(0) THEN NULL ELSE [globalagg1041]/CONVERT_IMPLICIT(decimal(19,0),[globalagg1039],0) END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Column="globalagg1039" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Arithmetic Operation="DIV">
<ScalarOperator>
<Identifier>
<ColumnReference Column="globalagg1041" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Convert DataType="decimal" Precision="19" Scale="0" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Column="globalagg1039" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="36" EstimateCPU="0.000102014" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="60.0079" LogicalOp="Aggregate" NodeId="2" Parallel="false" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="1034.33">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="Year" />
<ColumnReference Column="globalagg1039" />
<ColumnReference Column="globalagg1041" />
</OutputList>
<StreamAggregate>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="globalagg1039" />
<ScalarOperator ScalarString="SUM([partialagg1038])">
<Aggregate AggType="SUM" Distinct="false">
<ScalarOperator>
<Identifier>
<ColumnReference Column="partialagg1038" />
</Identifier>
</ScalarOperator>
</Aggregate>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="globalagg1041" />
<ScalarOperator ScalarString="SUM([partialagg1040])">
<Aggregate AggType="SUM" Distinct="false">
<ScalarOperator>
<Identifier>
<ColumnReference Column="partialagg1040" />
</Identifier>
</ScalarOperator>
</Aggregate>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<GroupBy>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="Year" />
</GroupBy>
<RelOp AvgRowSize="36" EstimateCPU="0.029374" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="120.016" LogicalOp="Gather Streams" NodeId="3" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="1034.33">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="Year" />
<ColumnReference Column="partialagg1038" />
<ColumnReference Column="partialagg1040" />
</OutputList>
<Parallelism>
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="Year" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="36" EstimateCPU="59.0507" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="120.016" LogicalOp="Aggregate" NodeId="4" Parallel="true" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="1034.3">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="Year" />
<ColumnReference Column="partialagg1038" />
<ColumnReference Column="partialagg1040" />
</OutputList>
<StreamAggregate>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="partialagg1038" />
<ScalarOperator ScalarString="COUNT_BIG([Union1032])">
<Aggregate AggType="COUNT_BIG" Distinct="false">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Union1032" />
</Identifier>
</ScalarOperator>
</Aggregate>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="partialagg1040" />
<ScalarOperator ScalarString="SUM([Union1032])">
<Aggregate AggType="SUM" Distinct="false">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Union1032" />
</Identifier>
</ScalarOperator>
</Aggregate>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<GroupBy>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="Year" />
</GroupBy>
<RelOp AvgRowSize="24" EstimateCPU="398.94" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="196835000" LogicalOp="Inner Join" NodeId="5" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="975.247">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="Year" />
<ColumnReference Column="Union1032" />
</OutputList>
<NestedLoops Optimized="false">
<OuterReferences>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</OuterReferences>
<RelOp AvgRowSize="15" EstimateCPU="0.00369443" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3600.95" LogicalOp="Index Seek" NodeId="6" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00681943" TableCardinality="73049">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="Year" />
</OutputList>
<Warnings>
<ColumnsWithNoStatistics>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="Year" />
</ColumnsWithNoStatistics>
</Warnings>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="Year" />
</DefinedValue>
</DefinedValues>
<Object Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Index="[ix_ObservationDates]" Alias="[od]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<StartRange ScanType="GE">
<RangeColumns>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="Year" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="(2000)">
<Const ConstValue="(2000)" />
</ScalarOperator>
</RangeExpressions>
</StartRange>
<EndRange ScanType="LT">
<RangeColumns>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="Year" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="(2006)">
<Const ConstValue="(2006)" />
</ScalarOperator>
</RangeExpressions>
</EndRange>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
<Predicate>
<ScalarOperator ScalarString="[SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]&lt;(20300101)">
<Compare CompareOp="LT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(20300101)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
<RelOp AvgRowSize="20" EstimateCPU="0.00530083" EstimateIO="0" EstimateRebinds="3599.95" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="53008.3" LogicalOp="Concatenation" NodeId="7" Parallel="true" PhysicalOp="Concatenation" EstimatedTotalSubtreeCost="576.299">
<OutputList>
<ColumnReference Column="Union1032" />
</OutputList>
<Concat>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Union1032" />
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1800]" Column="ObservationValue" />
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1900]" Column="ObservationValue" />
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1910]" Column="ObservationValue" />
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1920]" Column="ObservationValue" />
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1930]" Column="ObservationValue" />
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1940]" Column="ObservationValue" />
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1950]" Column="ObservationValue" />
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1960]" Column="ObservationValue" />
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1970]" Column="ObservationValue" />
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1980]" Column="ObservationValue" />
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1990]" Column="ObservationValue" />
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_2000]" Column="ObservationValue" />
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_2010]" Column="ObservationValue" />
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_2020]" Column="ObservationValue" />
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="20" EstimateCPU="0.00051628" EstimateIO="0.003125" EstimateRebinds="3599.95" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="326.618" LogicalOp="Filter" NodeId="8" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="10.9599" TableCardinality="4423710">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1800]" Column="ObservationValue" />
</OutputList>
<Filter StartupExpression="true">
<RelOp AvgRowSize="20" EstimateCPU="0.00051628" EstimateIO="0.003125" EstimateRebinds="3599.95" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="326.618" LogicalOp="Clustered Index Seek" NodeId="9" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="10.9599" TableCardinality="4423710">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1800]" Column="ObservationValue" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1800]" Column="ObservationValue" />
</DefinedValue>
</DefinedValues>
<Object Database="[SW]" Schema="[dbo]" Table="[Observation_1800]" Index="[pk_Observation_1800]" IndexKind="Clustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1800]" Column="ObservationDateKey" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]">
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]&lt;(19000101)">
<Compare CompareOp="LT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(19000101)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
<RelOp AvgRowSize="20" EstimateCPU="0.00308318" EstimateIO="0.00608796" EstimateRebinds="3599.95" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2660.16" LogicalOp="Filter" NodeId="11" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="30.9319" TableCardinality="9714910">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1900]" Column="ObservationValue" />
</OutputList>
<Filter StartupExpression="true">
<RelOp AvgRowSize="20" EstimateCPU="0.00308318" EstimateIO="0.00608796" EstimateRebinds="3599.95" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2660.16" LogicalOp="Clustered Index Seek" NodeId="12" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="30.9319" TableCardinality="9714910">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1900]" Column="ObservationValue" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1900]" Column="ObservationValue" />
</DefinedValue>
</DefinedValues>
<Object Database="[SW]" Schema="[dbo]" Table="[Observation_1900]" Index="[pk_Observation_1900]" IndexKind="Clustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1900]" Column="ObservationDateKey" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]">
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]&gt;=(19000101) AND [SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]&lt;(19100101)">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="GE">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(19000101)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="LT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(19100101)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
<RelOp AvgRowSize="20" EstimateCPU="0.00394609" EstimateIO="0.00756944" EstimateRebinds="3599.95" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3444.62" LogicalOp="Filter" NodeId="14" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="39.4131" TableCardinality="12579800">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1910]" Column="ObservationValue" />
</OutputList>
<Filter StartupExpression="true">
<RelOp AvgRowSize="20" EstimateCPU="0.00394609" EstimateIO="0.00756944" EstimateRebinds="3599.95" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3444.62" LogicalOp="Clustered Index Seek" NodeId="15" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="39.4131" TableCardinality="12579800">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1910]" Column="ObservationValue" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1910]" Column="ObservationValue" />
</DefinedValue>
</DefinedValues>
<Object Database="[SW]" Schema="[dbo]" Table="[Observation_1910]" Index="[pk_Observation_1910]" IndexKind="Clustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1910]" Column="ObservationDateKey" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]">
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]&gt;=(19100101) AND [SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]&lt;(19200101)">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="GE">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(19100101)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="LT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(19200101)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
<RelOp AvgRowSize="20" EstimateCPU="0.00440771" EstimateIO="0.00756944" EstimateRebinds="3599.95" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3864.29" LogicalOp="Filter" NodeId="17" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="41.2831" TableCardinality="14116200">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1920]" Column="ObservationValue" />
</OutputList>
<Filter StartupExpression="true">
<RelOp AvgRowSize="20" EstimateCPU="0.00440771" EstimateIO="0.00756944" EstimateRebinds="3599.95" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3864.29" LogicalOp="Clustered Index Seek" NodeId="18" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="41.2831" TableCardinality="14116200">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1920]" Column="ObservationValue" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1920]" Column="ObservationValue" />
</DefinedValue>
</DefinedValues>
<Object Database="[SW]" Schema="[dbo]" Table="[Observation_1920]" Index="[pk_Observation_1920]" IndexKind="Clustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1920]" Column="ObservationDateKey" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]">
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]&gt;=(19200101) AND [SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]&lt;(19300101)">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="GE">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(19200101)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="LT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(19300101)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
<RelOp AvgRowSize="20" EstimateCPU="0.0050001" EstimateIO="0.00831019" EstimateRebinds="3599.95" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="4402.82" LogicalOp="Filter" NodeId="20" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="46.1075" TableCardinality="16079100">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1930]" Column="ObservationValue" />
</OutputList>
<Filter StartupExpression="true">
<RelOp AvgRowSize="20" EstimateCPU="0.0050001" EstimateIO="0.00831019" EstimateRebinds="3599.95" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="4402.82" LogicalOp="Clustered Index Seek" NodeId="21" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="46.1075" TableCardinality="16079100">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1930]" Column="ObservationValue" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1930]" Column="ObservationValue" />
</DefinedValue>
</DefinedValues>
<Object Database="[SW]" Schema="[dbo]" Table="[Observation_1930]" Index="[pk_Observation_1930]" IndexKind="Clustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1930]" Column="ObservationDateKey" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]">
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]&gt;=(19300101) AND [SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]&lt;(19400101)">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="GE">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(19300101)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="LT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(19400101)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
<RelOp AvgRowSize="20" EstimateCPU="0.0053357" EstimateIO="0.00905093" EstimateRebinds="3599.95" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="4707.91" LogicalOp="Filter" NodeId="23" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="49.9244" TableCardinality="17198000">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1940]" Column="ObservationValue" />
</OutputList>
<Filter StartupExpression="true">
<RelOp AvgRowSize="20" EstimateCPU="0.0053357" EstimateIO="0.00905093" EstimateRebinds="3599.95" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="4707.91" LogicalOp="Clustered Index Seek" NodeId="24" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="49.9244" TableCardinality="17198000">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1940]" Column="ObservationValue" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1940]" Column="ObservationValue" />
</DefinedValue>
</DefinedValues>
<Object Database="[SW]" Schema="[dbo]" Table="[Observation_1940]" Index="[pk_Observation_1940]" IndexKind="Clustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1940]" Column="ObservationDateKey" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]">
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]&gt;=(19400101) AND [SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]&lt;(19500101)">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="GE">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(19400101)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="LT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(19500101)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
<RelOp AvgRowSize="20" EstimateCPU="0.00612757" EstimateIO="0.00979167" EstimateRebinds="3599.95" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5427.79" LogicalOp="Filter" NodeId="26" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="55.4908" TableCardinality="19822300">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1950]" Column="ObservationValue" />
</OutputList>
<Filter StartupExpression="true">
<RelOp AvgRowSize="20" EstimateCPU="0.00612757" EstimateIO="0.00979167" EstimateRebinds="3599.95" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5427.79" LogicalOp="Clustered Index Seek" NodeId="27" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="55.4908" TableCardinality="19822300">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1950]" Column="ObservationValue" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1950]" Column="ObservationValue" />
</DefinedValue>
</DefinedValues>
<Object Database="[SW]" Schema="[dbo]" Table="[Observation_1950]" Index="[pk_Observation_1950]" IndexKind="Clustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1950]" Column="ObservationDateKey" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]">
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]&gt;=(19500101) AND [SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]&lt;(19600101)">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="GE">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(19500101)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="LT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(19600101)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
<RelOp AvgRowSize="20" EstimateCPU="0.00627557" EstimateIO="0.00979167" EstimateRebinds="3599.95" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5562.34" LogicalOp="Filter" NodeId="29" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="56.068" TableCardinality="20319200">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1960]" Column="ObservationValue" />
</OutputList>
<Filter StartupExpression="true">
<RelOp AvgRowSize="20" EstimateCPU="0.00627557" EstimateIO="0.00979167" EstimateRebinds="3599.95" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5562.34" LogicalOp="Clustered Index Seek" NodeId="30" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="56.068" TableCardinality="20319200">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1960]" Column="ObservationValue" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1960]" Column="ObservationValue" />
</DefinedValue>
</DefinedValues>
<Object Database="[SW]" Schema="[dbo]" Table="[Observation_1960]" Index="[pk_Observation_1960]" IndexKind="Clustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1960]" Column="ObservationDateKey" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]">
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]&gt;=(19600101) AND [SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]&lt;(19700101)">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="GE">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(19600101)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="LT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(19700101)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
<RelOp AvgRowSize="20" EstimateCPU="0.0063342" EstimateIO="0.00979167" EstimateRebinds="3599.95" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5615.64" LogicalOp="Filter" NodeId="32" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="56.2952" TableCardinality="20508300">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1970]" Column="ObservationValue" />
</OutputList>
<Filter StartupExpression="true">
<RelOp AvgRowSize="20" EstimateCPU="0.0063342" EstimateIO="0.00979167" EstimateRebinds="3599.95" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5615.64" LogicalOp="Clustered Index Seek" NodeId="33" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="56.2952" TableCardinality="20508300">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1970]" Column="ObservationValue" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1970]" Column="ObservationValue" />
</DefinedValue>
</DefinedValues>
<Object Database="[SW]" Schema="[dbo]" Table="[Observation_1970]" Index="[pk_Observation_1970]" IndexKind="Clustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1970]" Column="ObservationDateKey" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]">
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]&gt;=(19700101) AND [SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]&lt;(19800101)">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="GE">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(19700101)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="LT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(19800101)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
<RelOp AvgRowSize="20" EstimateCPU="0.00648228" EstimateIO="0.00979167" EstimateRebinds="3599.95" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5750.25" LogicalOp="Filter" NodeId="35" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="56.8911" TableCardinality="21005700">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1980]" Column="ObservationValue" />
</OutputList>
<Filter StartupExpression="true">
<RelOp AvgRowSize="20" EstimateCPU="0.00648228" EstimateIO="0.00979167" EstimateRebinds="3599.95" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5750.25" LogicalOp="Clustered Index Seek" NodeId="36" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="56.8911" TableCardinality="21005700">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1980]" Column="ObservationValue" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1980]" Column="ObservationValue" />
</DefinedValue>
</DefinedValues>
<Object Database="[SW]" Schema="[dbo]" Table="[Observation_1980]" Index="[pk_Observation_1980]" IndexKind="Clustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1980]" Column="ObservationDateKey" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]">
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]&gt;=(19800101) AND [SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]&lt;(19900101)">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="GE">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(19800101)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="LT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(19900101)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
<RelOp AvgRowSize="20" EstimateCPU="0.00652659" EstimateIO="0.00979167" EstimateRebinds="3599.95" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5790.54" LogicalOp="Filter" NodeId="38" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="57.0671" TableCardinality="21147100">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1990]" Column="ObservationValue" />
</OutputList>
<Filter StartupExpression="true">
<RelOp AvgRowSize="20" EstimateCPU="0.00652659" EstimateIO="0.00979167" EstimateRebinds="3599.95" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5790.54" LogicalOp="Clustered Index Seek" NodeId="39" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="57.0671" TableCardinality="21147100">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1990]" Column="ObservationValue" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1990]" Column="ObservationValue" />
</DefinedValue>
</DefinedValues>
<Object Database="[SW]" Schema="[dbo]" Table="[Observation_1990]" Index="[pk_Observation_1990]" IndexKind="Clustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_1990]" Column="ObservationDateKey" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]">
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]&gt;=(19900101) AND [SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]&lt;(20000101)">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="GE">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(19900101)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="LT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(20000101)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
<RelOp AvgRowSize="20" EstimateCPU="0.00615571" EstimateIO="0.00979167" EstimateRebinds="3599.95" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5453.37" LogicalOp="Filter" NodeId="41" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="55.6334" TableCardinality="19921200">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_2000]" Column="ObservationValue" />
</OutputList>
<Filter StartupExpression="true">
<RelOp AvgRowSize="20" EstimateCPU="0.00615571" EstimateIO="0.00979167" EstimateRebinds="3599.95" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5453.37" LogicalOp="Clustered Index Seek" NodeId="42" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="55.6334" TableCardinality="19921200">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_2000]" Column="ObservationValue" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_2000]" Column="ObservationValue" />
</DefinedValue>
</DefinedValues>
<Object Database="[SW]" Schema="[dbo]" Table="[Observation_2000]" Index="[pk_Observation_2000]" IndexKind="Clustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_2000]" Column="ObservationDateKey" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]">
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]&gt;=(20000101) AND [SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]&lt;(20100101)">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="GE">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(20000101)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="LT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(20100101)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
<RelOp AvgRowSize="20" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="3599.95" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Filter" NodeId="44" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="0.572436" TableCardinality="0">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_2010]" Column="ObservationValue" />
</OutputList>
<Filter StartupExpression="true">
<RelOp AvgRowSize="20" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="3599.95" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="45" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.572436" TableCardinality="0">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_2010]" Column="ObservationValue" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_2010]" Column="ObservationValue" />
</DefinedValue>
</DefinedValues>
<Object Database="[SW]" Schema="[dbo]" Table="[Observation_2010]" Index="[pk_Observation_2010]" IndexKind="Clustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_2010]" Column="ObservationDateKey" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]">
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]&gt;=(20100101) AND [SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]&lt;(20200101)">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="GE">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(20100101)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="LT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(20200101)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
<RelOp AvgRowSize="20" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="3599.95" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Filter" NodeId="47" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="0.572436" TableCardinality="0">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_2020]" Column="ObservationValue" />
</OutputList>
<Filter StartupExpression="true">
<RelOp AvgRowSize="20" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="3599.95" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="48" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.572436" TableCardinality="0">
<OutputList>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_2020]" Column="ObservationValue" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_2020]" Column="ObservationValue" />
</DefinedValue>
</DefinedValues>
<Object Database="[SW]" Schema="[dbo]" Table="[Observation_2020]" Index="[pk_Observation_2020]" IndexKind="Clustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[Observation_2020]" Column="ObservationDateKey" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]">
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]&gt;=(20200101) AND [SW].[dbo].[ObservationDates].[DateKey] as [od].[DateKey]&lt;(20300101)">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="GE">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(20200101)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="LT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SW]" Schema="[dbo]" Table="[ObservationDates]" Alias="[od]" Column="DateKey" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(20300101)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
</Concat>
</RelOp>
</NestedLoops>
</RelOp>
</StreamAggregate>
</RelOp>
</Parallelism>
</RelOp>
</StreamAggregate>
</RelOp>
</ComputeScalar>
</RelOp>
</QueryPlan>
</StmtSimple>
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment