Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?xml version="1.0" encoding="utf-16"?>
- <ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.1" Build="10.50.2550.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
- <BatchSequence>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="3" StatementEstRows="1" StatementId="1" StatementOptmLevel="TRIVIAL" StatementSubTreeCost="0.0100022" StatementText="INSERT INTO @MyStatuts VALUES(1, 10) 
" StatementType="INSERT" QueryHash="0xE4CB2490845A8C01" QueryPlanHash="0xEB99FF71ED2283CD">
- <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
- <QueryPlan DegreeOfParallelism="0" CachedPlanSize="8" CompileTime="0" CompileCPU="0" CompileMemory="128">
- <RelOp AvgRowSize="9" EstimateCPU="1E-06" EstimateIO="0.01" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Insert" NodeId="0" Parallel="false" PhysicalOp="Table Insert" EstimatedTotalSubtreeCost="0.0100022">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <ScalarInsert>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1004" />
- <ScalarOperator ScalarString="(1)">
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1005" />
- <ScalarOperator ScalarString="(10)">
- <Const ConstValue="(10)" />
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <Object Table="[@MyStatuts]" />
- <SetPredicate>
- <ScalarOperator ScalarString="[StatutOrder] = [Expr1004],[StatutValue] = [Expr1005]">
- <ScalarExpressionList>
- <ScalarOperator>
- <MultipleAssign>
- <Assign>
- <ColumnReference Column="StatutOrder" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1004" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Column="StatutValue" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1005" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- </MultipleAssign>
- </ScalarOperator>
- </ScalarExpressionList>
- </ScalarOperator>
- </SetPredicate>
- </ScalarInsert>
- </RelOp>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="4" StatementEstRows="1" StatementId="2" StatementOptmLevel="TRIVIAL" StatementSubTreeCost="0.0100022" StatementText="INSERT INTO @MyStatuts VALUES(2, 9) 
" StatementType="INSERT" QueryHash="0xE4CB2490845A8C01" QueryPlanHash="0xEB99FF71ED2283CD">
- <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
- <QueryPlan DegreeOfParallelism="0" CachedPlanSize="8" CompileTime="0" CompileCPU="0" CompileMemory="128">
- <RelOp AvgRowSize="9" EstimateCPU="1E-06" EstimateIO="0.01" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Insert" NodeId="0" Parallel="false" PhysicalOp="Table Insert" EstimatedTotalSubtreeCost="0.0100022">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <ScalarInsert>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1004" />
- <ScalarOperator ScalarString="(2)">
- <Const ConstValue="(2)" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1005" />
- <ScalarOperator ScalarString="(9)">
- <Const ConstValue="(9)" />
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <Object Table="[@MyStatuts]" />
- <SetPredicate>
- <ScalarOperator ScalarString="[StatutOrder] = [Expr1004],[StatutValue] = [Expr1005]">
- <ScalarExpressionList>
- <ScalarOperator>
- <MultipleAssign>
- <Assign>
- <ColumnReference Column="StatutOrder" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1004" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Column="StatutValue" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1005" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- </MultipleAssign>
- </ScalarOperator>
- </ScalarExpressionList>
- </ScalarOperator>
- </SetPredicate>
- </ScalarInsert>
- </RelOp>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="5" StatementEstRows="1" StatementId="3" StatementOptmLevel="TRIVIAL" StatementSubTreeCost="0.0100022" StatementText="INSERT INTO @MyStatuts VALUES(3, 1) 

--SELECT TOP 10 Security, Date, Statut, Value 
--FROM [MARKETDATA].[Close] as c
--JOIN @MyStatuts as s on c.Statut = s.StatutValue
--WHERE Security = 'USDEUR' AND Date <= '30/04/2014' ORDER BY Date DESC, StatutOrder ASC

--SELECT Security, Date, Statut, Value 
--FROM (
--SELECT data.Security, data.Date, data.Statut, data.Value, s.StatutOrder, MIN(s.StatutOrder) OVER(PARTITION BY data.Date) As MinStatutOrder
--FROM [MARKETDATA].[Close] as data
--JOIN @MyStatuts as s on data.Statut = s.StatutValue
--WHERE Security = 'USDEUR' AND Date >= '01/01/2012' AND Date <= '30/04/2014') AS T
--WHERE T.StatutOrder = T.MinStatutOrder ORDER BY T.Date DESC

" StatementType="INSERT" QueryHash="0xE4CB2490845A8C01" QueryPlanHash="0xEB99FF71ED2283CD">
- <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
- <QueryPlan DegreeOfParallelism="0" CachedPlanSize="8" CompileTime="1" CompileCPU="0" CompileMemory="128">
- <RelOp AvgRowSize="9" EstimateCPU="1E-06" EstimateIO="0.01" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Insert" NodeId="0" Parallel="false" PhysicalOp="Table Insert" EstimatedTotalSubtreeCost="0.0100022">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <ScalarInsert>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1004" />
- <ScalarOperator ScalarString="(3)">
- <Const ConstValue="(3)" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1005" />
- <ScalarOperator ScalarString="(1)">
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <Object Table="[@MyStatuts]" />
- <SetPredicate>
- <ScalarOperator ScalarString="[StatutOrder] = [Expr1004],[StatutValue] = [Expr1005]">
- <ScalarExpressionList>
- <ScalarOperator>
- <MultipleAssign>
- <Assign>
- <ColumnReference Column="StatutOrder" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1004" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Column="StatutValue" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1005" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- </MultipleAssign>
- </ScalarOperator>
- </ScalarExpressionList>
- </ScalarOperator>
- </SetPredicate>
- </ScalarInsert>
- </RelOp>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="6" StatementEstRows="1" StatementId="4" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" StatementSubTreeCost="0.058286" StatementText="SELECT TOP 1 Security, Date, Statut, Value 
FROM (
SELECT data.Security, data.Date, data.Statut, data.Value, s.StatutOrder, MIN(s.StatutOrder) OVER(PARTITION BY data.Date) As MinStatutOrder
FROM [MARKETDATA].[Close] as data
JOIN @MyStatuts as s on data.Statut = s.StatutValue
WHERE Security = 'USDEUR' AND Date <= '24/04/2014') AS T
WHERE T.StatutOrder = T.MinStatutOrder ORDER BY T.Date DESC" StatementType="SELECT" QueryHash="0x0A52912ACE3F97A8" QueryPlanHash="0x6CA59CE8CFA3500E">
- <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
- <QueryPlan DegreeOfParallelism="1" MemoryGrant="1024" CachedPlanSize="40" CompileTime="8" CompileCPU="8" CompileMemory="344">
- <RelOp AvgRowSize="34" EstimateCPU="0.000610196" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="TopN Sort" NodeId="0" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.058286">
- <OutputList>
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Security" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Date" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Statut" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Value" />
- </OutputList>
- <MemoryFractions Input="0.0769231" Output="0.0769231" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <TopSort Distinct="false" Rows="1">
- <OrderBy>
- <OrderByColumn Ascending="false">
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Date" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="34" EstimateCPU="0.000270001" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="56.2502" LogicalOp="Filter" NodeId="1" Parallel="false" PhysicalOp="Filter" EstimatedTotalSubtreeCost="0.0464146">
- <OutputList>
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Security" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Date" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Statut" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Value" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="3996" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Filter StartupExpression="false">
- <RelOp AvgRowSize="36" EstimateCPU="0.0121275" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="562.502" LogicalOp="Inner Join" NodeId="2" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0461446">
- <OutputList>
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Security" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Date" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Statut" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Value" />
- <ColumnReference Table="@MyStatuts" Alias="[s]" Column="StatutOrder" />
- <ColumnReference Column="Expr1005" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="4354" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <RelOp AvgRowSize="35" EstimateCPU="0" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="562.502" LogicalOp="Lazy Spool" NodeId="3" Parallel="false" PhysicalOp="Table Spool" EstimatedTotalSubtreeCost="0.0335445">
- <OutputList>
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Security" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Date" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Statut" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Value" />
- <ColumnReference Table="@MyStatuts" Alias="[s]" Column="StatutOrder" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="3997" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Spool>
- <RelOp AvgRowSize="35" EstimateCPU="0.00157501" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="562.502" LogicalOp="Segment" NodeId="4" Parallel="false" PhysicalOp="Segment" EstimatedTotalSubtreeCost="0.0319695">
- <OutputList>
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Security" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Date" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Statut" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Value" />
- <ColumnReference Table="@MyStatuts" Alias="[s]" Column="StatutOrder" />
- <ColumnReference Column="Segment1006" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="4354" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Segment>
- <GroupBy>
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Date" />
- </GroupBy>
- <SegmentColumn>
- <ColumnReference Column="Segment1006" />
- </SegmentColumn>
- <RelOp AvgRowSize="35" EstimateCPU="0.00811666" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="562.502" LogicalOp="Sort" NodeId="5" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.0303945">
- <OutputList>
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Security" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Date" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Statut" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Value" />
- <ColumnReference Table="@MyStatuts" Alias="[s]" Column="StatutOrder" />
- </OutputList>
- <MemoryFractions Input="0.923077" Output="0.923077" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="4354" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Sort Distinct="false">
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Date" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="35" EstimateCPU="0.00235126" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="562.502" LogicalOp="Inner Join" NodeId="6" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0110166">
- <OutputList>
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Security" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Date" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Statut" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Value" />
- <ColumnReference Table="@MyStatuts" Alias="[s]" Column="StatutOrder" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="4354" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Table="@MyStatuts" Alias="[s]" Column="StatutValue" />
- </OuterReferences>
- <RelOp AvgRowSize="9" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Table Scan" NodeId="7" Parallel="false" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="0">
- <OutputList>
- <ColumnReference Table="@MyStatuts" Alias="[s]" Column="StatutOrder" />
- <ColumnReference Table="@MyStatuts" Alias="[s]" Column="StatutValue" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <TableScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Table="@MyStatuts" Alias="[s]" Column="StatutOrder" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="@MyStatuts" Alias="[s]" Column="StatutValue" />
- </DefinedValue>
- </DefinedValues>
- <Object Table="[@MyStatuts]" Alias="[s]" TableReferenceId="-1" />
- </TableScan>
- </RelOp>
- <RelOp AvgRowSize="34" EstimateCPU="0.000775752" EstimateIO="0.00460648" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="562.502" LogicalOp="Index Seek" NodeId="8" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00538223" TableCardinality="2976100">
- <OutputList>
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Security" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Date" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Statut" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Value" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="4354" ActualEndOfScans="3" ActualExecutions="3" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Security" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Date" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Statut" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Value" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Index="[INDEX_Global]" Alias="[data]" TableReferenceId="-1" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Security" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Statut" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="'USDEUR'">
- <Const ConstValue="'USDEUR'" />
- </ScalarOperator>
- <ScalarOperator ScalarString="@MyStatuts.[StatutValue] as [s].[StatutValue]">
- <Identifier>
- <ColumnReference Table="@MyStatuts" Alias="[s]" Column="StatutValue" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- <EndRange ScanType="LE">
- <RangeColumns>
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Date" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="'2014-04-24'">
- <Const ConstValue="'2014-04-24'" />
- </ScalarOperator>
- </RangeExpressions>
- </EndRange>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </Sort>
- </RelOp>
- </Segment>
- </RelOp>
- </Spool>
- </RelOp>
- <RelOp AvgRowSize="35" EstimateCPU="0.000157501" EstimateIO="0" EstimateRebinds="562.502" EstimateRewinds="0" EstimateRows="1" LogicalOp="Inner Join" NodeId="9" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.000315001">
- <OutputList>
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Security" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Date" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Statut" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Value" />
- <ColumnReference Table="@MyStatuts" Alias="[s]" Column="StatutOrder" />
- <ColumnReference Column="Expr1005" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="4354" ActualEndOfScans="3997" ActualExecutions="3997" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <Predicate>
- <ScalarOperator ScalarString="(1)">
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Predicate>
- <RelOp AvgRowSize="35" EstimateCPU="0.000157501" EstimateIO="0" EstimateRebinds="562.502" EstimateRewinds="0" EstimateRows="1" LogicalOp="Aggregate" NodeId="10" Parallel="false" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="0.000157501">
- <OutputList>
- <ColumnReference Column="Expr1005" />
- <ColumnReference Column="Expr1005" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="3996" ActualEndOfScans="3997" ActualExecutions="3997" />
- </RunTimeInformation>
- <StreamAggregate>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1005" />
- <ScalarOperator ScalarString="MIN(@MyStatuts.[StatutOrder] as [s].[StatutOrder])">
- <Aggregate AggType="MIN" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="@MyStatuts" Alias="[s]" Column="StatutOrder" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="35" EstimateCPU="0" EstimateIO="0" EstimateRebinds="562.502" EstimateRewinds="0" EstimateRows="1" LogicalOp="Lazy Spool" NodeId="11" Parallel="false" PhysicalOp="Table Spool" EstimatedTotalSubtreeCost="0">
- <OutputList>
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Security" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Date" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Statut" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Value" />
- <ColumnReference Table="@MyStatuts" Alias="[s]" Column="StatutOrder" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRebinds="3997" ActualRewinds="0" ActualRows="4354" ActualEndOfScans="3997" ActualExecutions="3997" />
- </RunTimeInformation>
- <Spool PrimaryNodeId="3" />
- </RelOp>
- </StreamAggregate>
- </RelOp>
- <RelOp AvgRowSize="35" EstimateCPU="0" EstimateIO="0" EstimateRebinds="562.502" EstimateRewinds="0" EstimateRows="1" LogicalOp="Lazy Spool" NodeId="15" Parallel="false" PhysicalOp="Table Spool" EstimatedTotalSubtreeCost="0">
- <OutputList>
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Security" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Date" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Statut" />
- <ColumnReference Database="[KQ_DEV]" Schema="[MARKETDATA]" Table="[Close]" Alias="[data]" Column="Value" />
- <ColumnReference Table="@MyStatuts" Alias="[s]" Column="StatutOrder" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="3995" ActualRows="4354" ActualEndOfScans="3996" ActualExecutions="3996" />
- </RunTimeInformation>
- <Spool PrimaryNodeId="3" />
- </RelOp>
- </NestedLoops>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <Predicate>
- <ScalarOperator ScalarString="@MyStatuts.[StatutOrder] as [s].[StatutOrder]=[Expr1005]">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="@MyStatuts" Alias="[s]" Column="StatutOrder" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1005" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </Filter>
- </RelOp>
- </TopSort>
- </RelOp>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- </BatchSequence>
- </ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement