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.5" Build="13.0.811.1004" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
- <BatchSequence>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="5" StatementEstRows="20.8234" StatementId="1" StatementOptmLevel="FULL" CardinalityEstimationModelVersion="70" StatementSubTreeCost="4.04232" StatementText="INSERT INTO @TempTable
 SELECT V.Registration, V.DateTime, V.Latitude, V.Longitude, V.Speed, V.Event, V.Data, NULL, Driver, Trailer
 FROM VehicleData V
 INNER JOIN (
 SELECT Registration, MAX(DateTime) LatestDate, Event
 FROM VehicleData
 WHERE Registration = @Registration AND DateTime < @DateTime
 AND Event in (SELECT Name FROM EventList)
 GROUP BY Registration, Event ) AS L
 ON V.Registration = L.Registration AND V.Event = L.Event AND V.DateTime = L.LatestDate" StatementType="INSERT" QueryHash="0xEAC5E5C600422013" QueryPlanHash="0x21311999418FEB04" RetrievedFromCache="true" StatementSqlHandle="0x09003E726338A08B8CFF4AC6EBEDC7FC9DC30000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="5" ParentObjectId="2133582639" BatchSqlHandle="0x030005002FE32B7F5856DE004FA6000001000000000000000000000000000000000000000000000000000000" StatementParameterizationType="0" SecurityPolicyApplied="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 DegreeOfParallelism="0" NonParallelPlanReason="MaxDOPSetToOne" MemoryGrant="1024" CachedPlanSize="64" CompileTime="18" CompileCPU="18" CompileMemory="1016">
- <Warnings>
- <MemoryGrantWarning GrantWarningKind="Excessive Grant" RequestedMemory="1024" GrantedMemory="1024" MaxUsedMemory="0" />
- </Warnings>
- <MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="544" RequiredMemory="512" DesiredMemory="544" RequestedMemory="1024" GrantWaitTime="0" GrantedMemory="1024" MaxUsedMemory="0" MaxQueryMemory="552320" />
- <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="17616030" EstimatedPagesCached="1101001" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="2313264" />
- <RelOp AvgRowSize="9" EstimateCPU="5.83056E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="20.8234" LogicalOp="Assert" NodeId="1" Parallel="false" PhysicalOp="Assert" EstimatedTotalSubtreeCost="4.04232">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="2152" ActualCPUms="169" />
- </RunTimeInformation>
- <Assert StartupExpression="false">
- <RelOp AvgRowSize="11" EstimateCPU="2.08234E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="20.8234" LogicalOp="Compute Scalar" NodeId="2" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="4.04231">
- <OutputList>
- <ColumnReference Column="Expr1012" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1012" />
- <ScalarOperator ScalarString="CASE WHEN [Latitude]<(-9.000000000000000e+001) OR [Latitude]>(9.000000000000000e+001) THEN (0) ELSE CASE WHEN [Longitude]<(-1.800000000000000e+002) OR [Longitude]>(1.800000000000000e+002) THEN (1) ELSE NULL END END">
- <IF>
- <Condition>
- <ScalarOperator>
- <Logical Operation="OR">
- <ScalarOperator>
- <Compare CompareOp="LT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Latitude" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(-9.000000000000000e+001)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Latitude" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(9.000000000000000e+001)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Const ConstValue="(0)" />
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <IF>
- <Condition>
- <ScalarOperator>
- <Logical Operation="OR">
- <ScalarOperator>
- <Compare CompareOp="LT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Longitude" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(-1.800000000000000e+002)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Longitude" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1.800000000000000e+002)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="23" EstimateCPU="2.08234E-05" EstimateIO="0.144543" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="20.8234" LogicalOp="Insert" NodeId="3" Parallel="false" PhysicalOp="Table Insert" EstimatedTotalSubtreeCost="4.04231">
- <OutputList>
- <ColumnReference Column="Latitude" />
- <ColumnReference Column="Longitude" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="2152" ActualCPUms="169" ActualScans="0" ActualLogicalReads="3" ActualPhysicalReads="1" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <Update DMLRequestSort="false">
- <Object Table="[@TempTable]" Storage="RowStore" />
- <SetPredicate>
- <ScalarOperator ScalarString="[Registration] = [StockSmartDatabase].[dbo].[VehicleData].[Registration] as [V].[Registration],[DateTime] = [StockSmartDatabase].[dbo].[VehicleData].[DateTime] as [V].[DateTime],[Latitude] = [StockSmartDatabase].[dbo].[VehicleData].[Latitude] as [V].[Latitude],[Longitude] = [StockSmartDatabase].[dbo].[VehicleData].[Longitude] as [V].[Longitude],[Speed] = [StockSmartDatabase].[dbo].[VehicleData].[Speed] as [V].[Speed],[Event] = [StockSmartDatabase].[dbo].[VehicleData].[Event] as [V].[Event],[Data] = [StockSmartDatabase].[dbo].[VehicleData].[Data] as [V].[Data],[PlaceName] = [Expr1011],[Driver] = [StockSmartDatabase].[dbo].[VehicleData].[Driver] as [V].[Driver],[Trailer] = [StockSmartDatabase].[dbo].[VehicleData].[Trailer] as [V].[Trailer]">
- <ScalarExpressionList>
- <ScalarOperator>
- <MultipleAssign>
- <Assign>
- <ColumnReference Column="Registration" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Registration" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Column="DateTime" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="DateTime" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Column="Latitude" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Latitude" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Column="Longitude" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Longitude" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Column="Speed" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Speed" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Column="Event" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Event" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Column="Data" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Data" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Column="PlaceName" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1011" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Column="Driver" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Driver" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Column="Trailer" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Trailer" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- </MultipleAssign>
- </ScalarOperator>
- </ScalarExpressionList>
- </ScalarOperator>
- </SetPredicate>
- <RelOp AvgRowSize="8227" EstimateCPU="2.08234E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="20.8234" LogicalOp="Compute Scalar" NodeId="4" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="3.89775">
- <OutputList>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Registration" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="DateTime" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Latitude" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Longitude" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Speed" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Event" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Data" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Driver" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Trailer" />
- <ColumnReference Column="Expr1011" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1011" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="4201" EstimateCPU="2.08234E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="20.8234" LogicalOp="Top" NodeId="5" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="3.89775">
- <OutputList>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Registration" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="DateTime" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Latitude" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Longitude" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Speed" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Event" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Data" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Driver" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Trailer" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="2151" ActualCPUms="169" />
- </RunTimeInformation>
- <Top RowCount="true" IsPercent="false" WithTies="false">
- <TopExpression>
- <ScalarOperator ScalarString="(0)">
- <Const ConstValue="(0)" />
- </ScalarOperator>
- </TopExpression>
- <RelOp AvgRowSize="4201" EstimateCPU="8.70419E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="20.8234" LogicalOp="Inner Join" NodeId="6" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="3.89774">
- <OutputList>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Registration" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="DateTime" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Latitude" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Longitude" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Speed" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Event" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Data" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Driver" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Trailer" />
- </OutputList>
- <MemoryFractions Input="0" Output="1" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="2151" ActualCPUms="169" />
- </RunTimeInformation>
- <NestedLoops Optimized="true">
- <OuterReferences>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Column="Event" />
- <ColumnReference Column="Expr1010" />
- </OuterReferences>
- <RelOp AvgRowSize="32" EstimateCPU="7.942E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="18" LogicalOp="Inner Join" NodeId="9" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="3.83845">
- <OutputList>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Column="Event" />
- <ColumnReference Column="Expr1010" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1110" ActualCPUms="169" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Column="Event" />
- </OuterReferences>
- <RelOp AvgRowSize="32" EstimateCPU="0.295075" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="19" LogicalOp="Aggregate" NodeId="10" Parallel="false" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="3.83224">
- <OutputList>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Column="Event" />
- <ColumnReference Column="Expr1010" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1110" ActualCPUms="169" />
- </RunTimeInformation>
- <StreamAggregate>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1010" />
- <ScalarOperator ScalarString="MAX([StockSmartDatabase].[dbo].[VehicleData].[DateTime])">
- <Aggregate AggType="MAX" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Column="DateTime" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <GroupBy>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Column="Event" />
- </GroupBy>
- <RelOp AvgRowSize="36" EstimateCPU="0.541111" EstimateIO="2.76001" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="491776" LogicalOp="Index Seek" NodeId="11" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="3.30112" TableCardinality="175937000">
- <OutputList>
- <ColumnReference Column="Uniq1006" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Column="DateTime" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Column="Event" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="279753" ActualRowsRead="296348" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1038" ActualCPUms="97" ActualScans="1" ActualLogicalReads="2256" ActualPhysicalReads="15" ActualReadAheads="434" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Uniq1006" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Column="DateTime" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Column="Event" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Index="[IDX_VehicleData_Registration_Event_DateTime]" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Column="Registration" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[@Registration]">
- <Identifier>
- <ColumnReference Column="@Registration" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="[StockSmartDatabase].[dbo].[VehicleData].[DateTime]<[@DateTime]">
- <Compare CompareOp="LT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Column="DateTime" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@DateTime" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </StreamAggregate>
- </RelOp>
- <RelOp AvgRowSize="9" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="18" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="15" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0061289" TableCardinality="28">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="3" ActualRowsRead="3" Batches="0" ActualEndOfScans="0" ActualExecutions="3" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="6" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues />
- <Object Database="[StockSmartDatabase]" Schema="[dbo]" Table="[EventList]" Index="[UQ__EventLis__737584F61720504C]" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[EventList]" Column="Name" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[StockSmartDatabase].[dbo].[VehicleData].[Event]">
- <Identifier>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Column="Event" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="4201" EstimateCPU="0.000158206" EstimateIO="0.003125" EstimateRebinds="18" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.09597" LogicalOp="Clustered Index Seek" NodeId="17" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0591939" TableCardinality="175937000">
- <OutputList>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Registration" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="DateTime" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Latitude" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Longitude" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Speed" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Event" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Data" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Driver" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Trailer" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="3" ActualRowsRead="3" Batches="0" ActualEndOfScans="3" ActualExecutions="3" ActualExecutionMode="Row" ActualElapsedms="1040" ActualCPUms="0" ActualScans="3" ActualLogicalReads="12" ActualPhysicalReads="1" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Registration" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="DateTime" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Latitude" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Longitude" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Speed" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Event" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Data" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Driver" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Trailer" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Index="[IDX_Clust_VehicleData_Registration_DateTime]" Alias="[V]" IndexKind="Clustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Registration" />
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="DateTime" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[@Registration]">
- <Identifier>
- <ColumnReference Column="@Registration" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="[Expr1010]">
- <Identifier>
- <ColumnReference Column="Expr1010" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="[StockSmartDatabase].[dbo].[VehicleData].[Event] as [V].[Event]=[StockSmartDatabase].[dbo].[VehicleData].[Event]">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Alias="[V]" Column="Event" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[StockSmartDatabase]" Schema="[dbo]" Table="[VehicleData]" Column="Event" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </Top>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </Update>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- <Predicate>
- <ScalarOperator ScalarString="[Expr1012]">
- <Identifier>
- <ColumnReference Column="Expr1012" />
- </Identifier>
- </ScalarOperator>
- </Predicate>
- </Assert>
- </RelOp>
- <ParameterList>
- <ColumnReference Column="@DateTime" ParameterCompiledValue="'2016-07-01 00:00:00.000'" ParameterRuntimeValue="'2016-06-01 00:00:00.000'" />
- <ColumnReference Column="@Registration" ParameterCompiledValue="N'nd15fxo'" ParameterRuntimeValue="N'nd62tsx'" />
- </ParameterList>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="5" StatementEstRows="2" StatementId="2" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="70" StatementSubTreeCost="0.0554847" StatementText="SELECT Registration, DateTime, 
 CASE 
 WHEN Latitude <> 0 THEN Latitude
 ELSE ISNULL(( SELECT TOP(1) Latitude FROM @DataTable V2
 WHERE Latitude <> 0 AND V2.DateTime >= V1.DateTime
 ORDER BY DateTime ASC),0)
 END AS Latitude,
 CASE 
 WHEN Longitude <> 0 THEN Longitude
 ELSE ISNULL(( SELECT TOP(1) Longitude FROM @DataTable V2
 WHERE Longitude <> 0 AND V2.DateTime >= V1.DateTime
 ORDER BY DateTime ASC),0)
 END AS Longitude,
 
 Speed, Event, Data, PlaceName, Driver, Trailer
 FROM @DataTable V1" StatementType="SELECT" QueryHash="0x4C941EECA1FC1D3" QueryPlanHash="0x55FBF7521C9A3923" RetrievedFromCache="true" StatementSqlHandle="0x09005E1ABEBED6737635A31B3B6F3ABECD510000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="5" ParentObjectId="1845581613" BatchSqlHandle="0x030005002D57016E81D6C4004FA6000001000000000000000000000000000000000000000000000000000000" StatementParameterizationType="0" SecurityPolicyApplied="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 DegreeOfParallelism="0" NonParallelPlanReason="MaxDOPSetToOne" MemoryGrant="1024" CachedPlanSize="40" CompileTime="2" CompileCPU="2" CompileMemory="392">
- <MemoryGrantInfo SerialRequiredMemory="32" SerialDesiredMemory="48" RequiredMemory="32" DesiredMemory="48" RequestedMemory="1024" GrantWaitTime="0" GrantedMemory="1024" MaxUsedMemory="0" MaxQueryMemory="552320" />
- <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="17616030" EstimatedPagesCached="1101001" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="2276768" />
- <RelOp AvgRowSize="8272" EstimateCPU="2E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2" LogicalOp="Compute Scalar" NodeId="0" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0554847">
- <OutputList>
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Registration" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="DateTime" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Speed" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Event" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Data" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="PlaceName" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Driver" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Trailer" />
- <ColumnReference Column="Expr1005" />
- <ColumnReference Column="Expr1009" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1005" />
- <ScalarOperator ScalarString="CASE WHEN @DataTable.[Latitude] as [V1].[Latitude]<>(0.000000000000000e+000) THEN @DataTable.[Latitude] as [V1].[Latitude] ELSE isnull(@DataTable.[Latitude] as [V2].[Latitude],(0.000000000000000e+000)) END">
- <IF>
- <Condition>
- <ScalarOperator>
- <Compare CompareOp="NE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Latitude" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(0.000000000000000e+000)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Latitude" />
- </Identifier>
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <Intrinsic FunctionName="isnull">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="@DataTable" Alias="[V2]" Column="Latitude" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(0.000000000000000e+000)" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1009" />
- <ScalarOperator ScalarString="CASE WHEN @DataTable.[Longitude] as [V1].[Longitude]<>(0.000000000000000e+000) THEN @DataTable.[Longitude] as [V1].[Longitude] ELSE isnull(@DataTable.[Longitude] as [V2].[Longitude],(0.000000000000000e+000)) END">
- <IF>
- <Condition>
- <ScalarOperator>
- <Compare CompareOp="NE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Longitude" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(0.000000000000000e+000)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Longitude" />
- </Identifier>
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <Intrinsic FunctionName="isnull">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="@DataTable" Alias="[V2]" Column="Longitude" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(0.000000000000000e+000)" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="8288" EstimateCPU="8.36E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2" LogicalOp="Left Outer Join" NodeId="1" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0554845">
- <OutputList>
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Registration" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="DateTime" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Latitude" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Longitude" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Speed" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Event" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Data" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="PlaceName" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Driver" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Trailer" />
- <ColumnReference Table="@DataTable" Alias="[V2]" Column="Latitude" />
- <ColumnReference Table="@DataTable" Alias="[V2]" Column="Longitude" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <PassThru>
- <ScalarOperator ScalarString="@DataTable.[Longitude] as [V1].[Longitude]<>(0.000000000000000e+000)">
- <Compare CompareOp="NE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Longitude" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(0.000000000000000e+000)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </PassThru>
- <OuterReferences>
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="DateTime" />
- </OuterReferences>
- <RelOp AvgRowSize="8280" EstimateCPU="8.36E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2" LogicalOp="Left Outer Join" NodeId="2" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0293843">
- <OutputList>
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Registration" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="DateTime" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Latitude" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Longitude" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Speed" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Event" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Data" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="PlaceName" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Driver" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Trailer" />
- <ColumnReference Table="@DataTable" Alias="[V2]" Column="Latitude" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <PassThru>
- <ScalarOperator ScalarString="@DataTable.[Latitude] as [V1].[Latitude]<>(0.000000000000000e+000)">
- <Compare CompareOp="NE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Latitude" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(0.000000000000000e+000)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </PassThru>
- <OuterReferences>
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="DateTime" />
- </OuterReferences>
- <RelOp AvgRowSize="8272" EstimateCPU="0.0001592" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2" LogicalOp="Table Scan" NodeId="3" Parallel="false" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="0.0032842" TableCardinality="2">
- <OutputList>
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Registration" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="DateTime" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Latitude" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Longitude" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Speed" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Event" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Data" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="PlaceName" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Driver" />
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Trailer" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="3" ActualRowsRead="3" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="1" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <TableScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Registration" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="DateTime" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Latitude" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Longitude" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Speed" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Event" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Data" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="PlaceName" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Driver" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="Trailer" />
- </DefinedValue>
- </DefinedValues>
- <Object Table="[@DataTable]" Alias="[V1]" Storage="RowStore" />
- </TableScan>
- </RelOp>
- <RelOp AvgRowSize="23" EstimateCPU="0.000100023" EstimateIO="0.0112613" EstimateRebinds="1" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="TopN Sort" NodeId="4" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.026091">
- <OutputList>
- <ColumnReference Table="@DataTable" Alias="[V2]" Column="DateTime" />
- <ColumnReference Table="@DataTable" Alias="[V2]" Column="Latitude" />
- </OutputList>
- <MemoryFractions Input="0.5" Output="0.5" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="512" OutputMemoryGrant="512" UsedMemoryGrant="0" />
- </RunTimeInformation>
- <TopSort Distinct="false" Rows="1">
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Table="@DataTable" Alias="[V2]" Column="DateTime" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="23" EstimateCPU="8.07E-05" EstimateIO="0.0032035" EstimateRebinds="0" EstimateRewinds="1" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Table Scan" NodeId="5" Parallel="false" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="0.0033649" TableCardinality="2">
- <OutputList>
- <ColumnReference Table="@DataTable" Alias="[V2]" Column="DateTime" />
- <ColumnReference Table="@DataTable" Alias="[V2]" Column="Latitude" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <TableScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Table="@DataTable" Alias="[V2]" Column="DateTime" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="@DataTable" Alias="[V2]" Column="Latitude" />
- </DefinedValue>
- </DefinedValues>
- <Object Table="[@DataTable]" Alias="[V2]" TableReferenceId="1" Storage="RowStore" />
- <Predicate>
- <ScalarOperator ScalarString="@DataTable.[DateTime] as [V2].[DateTime]>=@DataTable.[DateTime] as [V1].[DateTime] AND @DataTable.[Latitude] as [V2].[Latitude]<>(0.000000000000000e+000)">
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="GE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="@DataTable" Alias="[V2]" Column="DateTime" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="DateTime" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="NE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="@DataTable" Alias="[V2]" Column="Latitude" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(0.000000000000000e+000)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </TableScan>
- </RelOp>
- </TopSort>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="23" EstimateCPU="0.000100023" EstimateIO="0.0112613" EstimateRebinds="1" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="TopN Sort" NodeId="6" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.026091">
- <OutputList>
- <ColumnReference Table="@DataTable" Alias="[V2]" Column="DateTime" />
- <ColumnReference Table="@DataTable" Alias="[V2]" Column="Longitude" />
- </OutputList>
- <MemoryFractions Input="0.5" Output="0.5" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="512" OutputMemoryGrant="512" UsedMemoryGrant="0" />
- </RunTimeInformation>
- <TopSort Distinct="false" Rows="1">
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Table="@DataTable" Alias="[V2]" Column="DateTime" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="23" EstimateCPU="8.07E-05" EstimateIO="0.0032035" EstimateRebinds="0" EstimateRewinds="1" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Table Scan" NodeId="7" Parallel="false" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="0.0033649" TableCardinality="2">
- <OutputList>
- <ColumnReference Table="@DataTable" Alias="[V2]" Column="DateTime" />
- <ColumnReference Table="@DataTable" Alias="[V2]" Column="Longitude" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <TableScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Table="@DataTable" Alias="[V2]" Column="DateTime" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="@DataTable" Alias="[V2]" Column="Longitude" />
- </DefinedValue>
- </DefinedValues>
- <Object Table="[@DataTable]" Alias="[V2]" TableReferenceId="2" Storage="RowStore" />
- <Predicate>
- <ScalarOperator ScalarString="@DataTable.[DateTime] as [V2].[DateTime]>=@DataTable.[DateTime] as [V1].[DateTime] AND @DataTable.[Longitude] as [V2].[Longitude]<>(0.000000000000000e+000)">
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="GE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="@DataTable" Alias="[V2]" Column="DateTime" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="@DataTable" Alias="[V1]" Column="DateTime" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="NE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="@DataTable" Alias="[V2]" Column="Longitude" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(0.000000000000000e+000)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </TableScan>
- </RelOp>
- </TopSort>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="6" StatementEstRows="1" StatementId="3" StatementOptmLevel="TRIVIAL" CardinalityEstimationModelVersion="70" StatementSubTreeCost="0.0133504" StatementText="INSERT INTO @ResultsTable
 EXEC StockSmartFillGPS @TempTable" StatementType="INSERT EXEC" QueryHash="0x88931EBD0A18A62A" QueryPlanHash="0xACCCEE8F76D4877B" RetrievedFromCache="true" StatementSqlHandle="0x0900EEFB0E3E4689E814BA1795F04FB3A1860000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="5" ParentObjectId="2133582639" BatchSqlHandle="0x030005002FE32B7F5856DE004FA6000001000000000000000000000000000000000000000000000000000000" StatementParameterizationType="0" SecurityPolicyApplied="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 DegreeOfParallelism="0" NonParallelPlanReason="MaxDOPSetToOne" CachedPlanSize="32" CompileTime="1" CompileCPU="1" CompileMemory="240">
- <MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" />
- <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="17616030" EstimatedPagesCached="1101001" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="2313264" />
- <RelOp AvgRowSize="9" EstimateCPU="1.8E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Assert" NodeId="0" Parallel="false" PhysicalOp="Assert" EstimatedTotalSubtreeCost="0.0133504">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="28" ActualCPUms="0" />
- </RunTimeInformation>
- <Assert StartupExpression="false">
- <RelOp AvgRowSize="23" EstimateCPU="1E-06" EstimateIO="0.010066" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Insert" NodeId="1" Parallel="false" PhysicalOp="Table Insert" EstimatedTotalSubtreeCost="0.0133502">
- <OutputList>
- <ColumnReference Column="Latitude" />
- <ColumnReference Column="Longitude" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="28" ActualCPUms="0" ActualScans="0" ActualLogicalReads="3" ActualPhysicalReads="1" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <Update DMLRequestSort="false">
- <Object Table="[@ResultsTable]" Storage="RowStore" />
- <SetPredicate>
- <ScalarOperator ScalarString="[Registration] = RaiseIfNullInsert([Parameter Table].[Registration] as [ParameterTable].[Registration]),[DateTime] = RaiseIfNullInsert([Parameter Table].[DateTime] as [ParameterTable].[DateTime]),[Latitude] = RaiseIfNullInsert([Parameter Table].[Latitude] as [ParameterTable].[Latitude]),[Longitude] = RaiseIfNullInsert([Parameter Table].[Longitude] as [ParameterTable].[Longitude]),[Speed] = RaiseIfNullInsert([Parameter Table].[Speed] as [ParameterTable].[Speed]),[Event] = RaiseIfNullInsert([Parameter Table].[Event] as [ParameterTable].[Event]),[Data] = [Parameter Table].[Data] as [ParameterTable].[Data],[PlaceName] = [Parameter Table].[PlaceName] as [ParameterTable].[PlaceName],[Driver] = [Parameter Table].[Driver] as [ParameterTable].[Driver],[Trailer] = [Parameter Table].[Trailer] as [ParameterTable].[Trailer]">
- <ScalarExpressionList>
- <ScalarOperator>
- <MultipleAssign>
- <Assign>
- <ColumnReference Column="Registration" />
- <ScalarOperator>
- <Intrinsic FunctionName="RaiseIfNullInsert">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="[Parameter Table]" Alias="[ParameterTable]" Column="Registration" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Column="DateTime" />
- <ScalarOperator>
- <Intrinsic FunctionName="RaiseIfNullInsert">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="[Parameter Table]" Alias="[ParameterTable]" Column="DateTime" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Column="Latitude" />
- <ScalarOperator>
- <Intrinsic FunctionName="RaiseIfNullInsert">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="[Parameter Table]" Alias="[ParameterTable]" Column="Latitude" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Column="Longitude" />
- <ScalarOperator>
- <Intrinsic FunctionName="RaiseIfNullInsert">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="[Parameter Table]" Alias="[ParameterTable]" Column="Longitude" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Column="Speed" />
- <ScalarOperator>
- <Intrinsic FunctionName="RaiseIfNullInsert">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="[Parameter Table]" Alias="[ParameterTable]" Column="Speed" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Column="Event" />
- <ScalarOperator>
- <Intrinsic FunctionName="RaiseIfNullInsert">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="[Parameter Table]" Alias="[ParameterTable]" Column="Event" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Column="Data" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="[Parameter Table]" Alias="[ParameterTable]" Column="Data" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Column="PlaceName" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="[Parameter Table]" Alias="[ParameterTable]" Column="PlaceName" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Column="Driver" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="[Parameter Table]" Alias="[ParameterTable]" Column="Driver" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Column="Trailer" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="[Parameter Table]" Alias="[ParameterTable]" Column="Trailer" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- </MultipleAssign>
- </ScalarOperator>
- </ScalarExpressionList>
- </ScalarOperator>
- </SetPredicate>
- <RelOp AvgRowSize="8272" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Top" NodeId="2" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="0.0032832">
- <OutputList>
- <ColumnReference Table="[Parameter Table]" Alias="[ParameterTable]" Column="Registration" />
- <ColumnReference Table="[Parameter Table]" Alias="[ParameterTable]" Column="DateTime" />
- <ColumnReference Table="[Parameter Table]" Alias="[ParameterTable]" Column="Latitude" />
- <ColumnReference Table="[Parameter Table]" Alias="[ParameterTable]" Column="Longitude" />
- <ColumnReference Table="[Parameter Table]" Alias="[ParameterTable]" Column="Speed" />
- <ColumnReference Table="[Parameter Table]" Alias="[ParameterTable]" Column="Event" />
- <ColumnReference Table="[Parameter Table]" Alias="[ParameterTable]" Column="Data" />
- <ColumnReference Table="[Parameter Table]" Alias="[ParameterTable]" Column="PlaceName" />
- <ColumnReference Table="[Parameter Table]" Alias="[ParameterTable]" Column="Driver" />
- <ColumnReference Table="[Parameter Table]" Alias="[ParameterTable]" Column="Trailer" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <Top RowCount="true" IsPercent="false" WithTies="false">
- <TopExpression>
- <ScalarOperator ScalarString="(0)">
- <Const ConstValue="(0)" />
- </ScalarOperator>
- </TopExpression>
- <RelOp AvgRowSize="8272" EstimateCPU="7.96E-05" EstimateIO="0.0032035" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Parameter Table Scan" NodeId="3" Parallel="false" PhysicalOp="Parameter Table Scan" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="0">
- <OutputList>
- <ColumnReference Table="[Parameter Table]" Alias="[ParameterTable]" Column="Registration" />
- <ColumnReference Table="[Parameter Table]" Alias="[ParameterTable]" Column="DateTime" />
- <ColumnReference Table="[Parameter Table]" Alias="[ParameterTable]" Column="Latitude" />
- <ColumnReference Table="[Parameter Table]" Alias="[ParameterTable]" Column="Longitude" />
- <ColumnReference Table="[Parameter Table]" Alias="[ParameterTable]" Column="Speed" />
- <ColumnReference Table="[Parameter Table]" Alias="[ParameterTable]" Column="Event" />
- <ColumnReference Table="[Parameter Table]" Alias="[ParameterTable]" Column="Data" />
- <ColumnReference Table="[Parameter Table]" Alias="[ParameterTable]" Column="PlaceName" />
- <ColumnReference Table="[Parameter Table]" Alias="[ParameterTable]" Column="Driver" />
- <ColumnReference Table="[Parameter Table]" Alias="[ParameterTable]" Column="Trailer" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <ParameterTableScan />
- </RelOp>
- </Top>
- </RelOp>
- </Update>
- </RelOp>
- <Predicate>
- <ScalarOperator ScalarString="CASE WHEN [Latitude]<(-9.000000000000000e+001) OR [Latitude]>(9.000000000000000e+001) THEN (0) ELSE CASE WHEN [Longitude]<(-1.800000000000000e+002) OR [Longitude]>(1.800000000000000e+002) THEN (1) ELSE NULL END END">
- <IF>
- <Condition>
- <ScalarOperator>
- <Logical Operation="OR">
- <ScalarOperator>
- <Compare CompareOp="LT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Latitude" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(-9.000000000000000e+001)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Latitude" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(9.000000000000000e+001)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Const ConstValue="(0)" />
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <IF>
- <Condition>
- <ScalarOperator>
- <Logical Operation="OR">
- <ScalarOperator>
- <Compare CompareOp="LT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Longitude" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(-1.800000000000000e+002)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Longitude" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1.800000000000000e+002)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </Predicate>
- </Assert>
- </RelOp>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="7" StatementEstRows="1" StatementId="4" StatementOptmLevel="TRIVIAL" CardinalityEstimationModelVersion="70" StatementSubTreeCost="0.0146526" StatementText="SELECT * FROM @ResultsTable
 ORDER BY DateTime DESC" StatementType="SELECT" QueryHash="0xDAA2CA83B73D1350" QueryPlanHash="0xFB4D82058FBCD7EA" RetrievedFromCache="true" StatementSqlHandle="0x09004E1DDFA9404C04D821BCA8F2453113630000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="5" ParentObjectId="2133582639" BatchSqlHandle="0x030005002FE32B7F5856DE004FA6000001000000000000000000000000000000000000000000000000000000" StatementParameterizationType="0" SecurityPolicyApplied="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 DegreeOfParallelism="0" NonParallelPlanReason="MaxDOPSetToOne" MemoryGrant="1024" CachedPlanSize="24" CompileTime="0" CompileCPU="0" CompileMemory="168">
- <MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="560" RequiredMemory="512" DesiredMemory="560" RequestedMemory="1024" GrantWaitTime="0" GrantedMemory="1024" MaxUsedMemory="16" MaxQueryMemory="552320" />
- <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="17616030" EstimatedPagesCached="1101001" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="2313264" />
- <RelOp AvgRowSize="8272" EstimateCPU="0.000108272" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Sort" NodeId="0" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.0146526">
- <OutputList>
- <ColumnReference Column="Registration" />
- <ColumnReference Column="DateTime" />
- <ColumnReference Column="Latitude" />
- <ColumnReference Column="Longitude" />
- <ColumnReference Column="Speed" />
- <ColumnReference Column="Event" />
- <ColumnReference Column="Data" />
- <ColumnReference Column="PlaceName" />
- <ColumnReference Column="Driver" />
- <ColumnReference Column="Trailer" />
- </OutputList>
- <MemoryFractions Input="1" Output="1" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="3" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="1024" OutputMemoryGrant="640" UsedMemoryGrant="16" />
- </RunTimeInformation>
- <Sort Distinct="false">
- <OrderBy>
- <OrderByColumn Ascending="false">
- <ColumnReference Column="DateTime" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="8272" EstimateCPU="7.96E-05" EstimateIO="0.0032035" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Table Scan" NodeId="1" Parallel="false" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="0">
- <OutputList>
- <ColumnReference Column="Registration" />
- <ColumnReference Column="DateTime" />
- <ColumnReference Column="Latitude" />
- <ColumnReference Column="Longitude" />
- <ColumnReference Column="Speed" />
- <ColumnReference Column="Event" />
- <ColumnReference Column="Data" />
- <ColumnReference Column="PlaceName" />
- <ColumnReference Column="Driver" />
- <ColumnReference Column="Trailer" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="3" ActualRowsRead="3" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="1" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <TableScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Registration" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="DateTime" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Latitude" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Longitude" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Speed" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Event" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Data" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="PlaceName" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Driver" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Trailer" />
- </DefinedValue>
- </DefinedValues>
- <Object Table="[@ResultsTable]" Storage="RowStore" />
- </TableScan>
- </RelOp>
- </Sort>
- </RelOp>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- </BatchSequence>
- </ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement