Created
March 26, 2016 12:07
-
-
Save mdawood1991/c7e5bb2191e976d5e839 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?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="11.0.2100.60" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan"> | |
<BatchSequence> | |
<Batch> | |
<Statements> | |
<StmtSimple StatementCompId="40" StatementEstRows="1" StatementId="5" StatementOptmLevel="FULL" StatementSubTreeCost="20.4266" StatementText="SELECT 
 JourneyStartId
 , JourneyEndId
 , AssetId
 , [Event]
 , JourneyStart
 , JourneyEnd
 , GeofenceId
 , JourneyDistance = ROUND((SUM(DistanceCoveredK) / 1000), 3, 1)
 , JourneyTime
 FROM (
 SELECT 
 JourneyStartId = ignOn.iVehicleMonitoringId
 ,JourneyEndId = ignOff.iVehicleMonitoringId
 ,AssetId = ignOn.iAssetId
 ,JourneyStart = DATEADD(hour, @fGmtOffSet, ignOn.dtUTCDateTime) 
 ,JourneyEnd = DATEADD(hour, @fGmtOffSet, ignOff.dtUTCDateTime)
 ,[Event] = ignOff.eEventCode
 ,DistanceCoveredK = p.sptGeoLocaitonPoint.STDistance(
 LEAD(p.sptGeoLocaitonPoint) OVER(PARTITION BY ignOn.iAssetId, ignOn.dtUTCDateTime ORDER BY ignOn.dtUTCDateTime))
 ,GeofenceId = ignOn.iGeofenceId
 ,JourneyTime = DATEDIFF(SECOND, ignOn.dtUTCDateTime, ignOff.dtUTCDateTime)
 FROM VehicleMonitoringLog ignOn
 CROSS APPLY (
 SELECT top(1) iVehicleMonitoringId, eEventCode, dtUTCDateTime, sptGeoLocaitonPoint 
 FROM VehicleMonitoringLog WHERE 
 iAssetId = ignOn.iAssetId AND dtUTCDateTime > ignOn.dtUTCDateTime AND eEventCode = 2
 ORDER by dtUTCDateTime
 ) ignOff
 INNER JOIN VehicleMonitoringLog p ON p.iAssetId = ignOn.iAssetId AND p.dtUTCDateTime >= ignOn.dtUTCDateTime AND p.dtUTCDateTime <= ignOff.dtUTCDateTime
 WHERE 
 ignOn.dtUTCDateTime > @utcStartDate AND ignOn.dtUTCDateTime < @utcEndDate
 AND ignOn.iAssetId in (Select iAssetId FROM #tblAssets)
 AND ignOn.eEventCode = 1
 ) g
 
 GROUP BY AssetId, [Event], GeofenceId, JourneyStart, JourneyEnd, JourneyTime, JourneyStartId, JourneyEndId
 --
 --INSERT INTO #journeyResultLogs
 -- SELECT
 -- jl.JourneyStartId,
 -- jl.JourneyEndId,
 -- jl.AssetId,
 -- ta.sReference,
 -- ta.iCategoryID,
 -- ta.sCategoryName,
 -- ta.iSiteID,
 -- ta.sSiteName,
 -- jl.[Event],
 -- jl.JourneyStart,
 -- jl.JourneyEnd,
 -- jl.GeofenceId,
 -- jl.JourneyDistanceKM,
 -- jl.JourneyTime
 -- FROM #JourneyLogs jl
 -- INNER JOIN #tblAssets ta on ta.iAssetID = jl.AssetId
 -- WHERE jl.JourneyDistanceKM > @fMinJourneyDistance
 --
 ----Summary Per Site
 --Select 
 -- SiteId,
 -- SiteName,
 -- TotalJournies = Count(*),
 -- TotalDistanceTravelledKM = SUM(JourneyDistanceKM),
 -- TotalJourneyTimeDDDHHMMSS = SUBSTRING(dbo.xPT_ConvertTimeToDDHHMMSS(SUM(JourneyTime),'s'),1,12)
 --From #journeyResultLogs
 --Group by SiteId, SiteName
 --
 ----Summary Per Category
 --Select
 -- CategoryId,
 -- CategoryName,
 -- SiteId,
 -- SiteName,
 -- TotalJournies = Count(*),
 -- TotalDistanceTravelledKM = SUM(JourneyDistanceKM),
 -- TotalJourneyTimeDDDHHMMSS = SUBSTRING(dbo.xPT_ConvertTimeToDDHHMMSS(SUM(JourneyTime),'s'),1,12)
 --From #journeyResultLogs
 -- Group by CategoryId, CategoryName, SiteId, SiteName
 --
 ----Summary Per Asset
 --Select
 -- AssetId,
 -- Reference,
 -- CategoryId,
 -- CategoryName,
 -- SiteId,
 -- SiteName,
 -- TotalJournies = Count(*),
 -- TotalDistanceTravelledKM = SUM(JourneyDistanceKM),
 -- TotalJourneyTimeDDDHHMMSS = SUBSTRING(dbo.xPT_ConvertTimeToDDHHMMSS(SUM(JourneyTime),'s'),1,12)
 --From #journeyResultLogs
 -- Group by AssetId, Reference, CategoryId, CategoryName, SiteId, SiteName
 --
 ----Details Per Asset
 --SELECT 
 -- --iJourneyID AS 'JourneyId',
 -- JourneyId = JourneyStartId
 -- ,AssetId
 -- ,Registration = Reference
 -- ,CategoryId
 -- ,CategoryName
 -- ,SiteId
 -- ,SiteName
 -- ,JourneyStartDate = FORMAT(JourneyStart, 'dd-MMM-yyyy HH:mm:ss')
 -- ,JourneyEndDate = FORMAT(JourneyEnd, 'dd-MMM-yyyy HH:mm:ss')
 -- ,DistanceTravelledKM = JourneyDistanceKM
 -- --,JourneyTime
 -- ,DurationDDDHHMMSS = SUBSTRING(dbo.xPT_ConvertTimeToDDHHMMSS(JourneyTime,'s'),1,12)
 -- --sDriver AS 'Driver',
 -- ,AddressDeparted = gisStart.sRoad + ', ' + gisStart.sTown + ', ' + gisStart.sDistrict + ', ' + gisStart.sState
 -- ,AddressArrived = gisEnd.sRoad + ', ' + gisEnd.sTow" StatementType="SELECT" QueryHash="0x84BB4293DB14BCB1" QueryPlanHash="0xF32040699054114D" RetrievedFromCache="true"> | |
<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="144" CompileTime="42" CompileCPU="42" CompileMemory="1848"> | |
<MemoryGrantInfo SerialRequiredMemory="640" SerialDesiredMemory="704" RequiredMemory="640" DesiredMemory="704" RequestedMemory="1024" GrantWaitTime="0" GrantedMemory="1024" MaxUsedMemory="720" /> | |
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="205855" EstimatedPagesCached="12014" EstimatedAvailableDegreeOfParallelism="2" /> | |
<RelOp AvgRowSize="53" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="0" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="20.4266"> | |
<OutputList> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iVehicleMonitoringId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iGeofenceId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iAssetId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="iVehicleMonitoringId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="eEventCode" /> | |
<ColumnReference Column="Expr1016" /> | |
<ColumnReference Column="Expr1017" /> | |
<ColumnReference Column="Expr1019" /> | |
<ColumnReference Column="Expr1021" /> | |
</OutputList> | |
<ComputeScalar> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Column="Expr1021" /> | |
<ScalarOperator ScalarString="round([Expr1020]/(1.000000000000000e+003),(3),(1))"> | |
<Intrinsic FunctionName="round"> | |
<ScalarOperator> | |
<Arithmetic Operation="DIV"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Column="Expr1020" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Const ConstValue="(1.000000000000000e+003)" /> | |
</ScalarOperator> | |
</Arithmetic> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Const ConstValue="(3)" /> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Const ConstValue="(1)" /> | |
</ScalarOperator> | |
</Intrinsic> | |
</ScalarOperator> | |
</DefinedValue> | |
</DefinedValues> | |
<RelOp AvgRowSize="53" EstimateCPU="1.1E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="1" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="20.4266"> | |
<OutputList> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iVehicleMonitoringId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iGeofenceId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iAssetId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="iVehicleMonitoringId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="eEventCode" /> | |
<ColumnReference Column="Expr1016" /> | |
<ColumnReference Column="Expr1017" /> | |
<ColumnReference Column="Expr1019" /> | |
<ColumnReference Column="Expr1020" /> | |
</OutputList> | |
<ComputeScalar> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Column="Expr1020" /> | |
<ScalarOperator ScalarString="CASE WHEN [Expr1047]=(0) THEN NULL ELSE [Expr1048] END"> | |
<IF> | |
<Condition> | |
<ScalarOperator> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Column="Expr1047" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Const ConstValue="(0)" /> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</Condition> | |
<Then> | |
<ScalarOperator> | |
<Const ConstValue="NULL" /> | |
</ScalarOperator> | |
</Then> | |
<Else> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Column="Expr1048" /> | |
</Identifier> | |
</ScalarOperator> | |
</Else> | |
</IF> | |
</ScalarOperator> | |
</DefinedValue> | |
</DefinedValues> | |
<RelOp AvgRowSize="53" EstimateCPU="1.1E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Aggregate" NodeId="2" Parallel="false" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="20.4266"> | |
<OutputList> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iVehicleMonitoringId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iGeofenceId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iAssetId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="iVehicleMonitoringId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="eEventCode" /> | |
<ColumnReference Column="Expr1016" /> | |
<ColumnReference Column="Expr1017" /> | |
<ColumnReference Column="Expr1019" /> | |
<ColumnReference Column="Expr1047" /> | |
<ColumnReference Column="Expr1048" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="4830" ActualEndOfScans="1" ActualExecutions="1" /> | |
</RunTimeInformation> | |
<StreamAggregate> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Column="Expr1047" /> | |
<ScalarOperator ScalarString="COUNT_BIG([TBCompany_1].[dbo].[VehicleMonitoringLog].[sptGeoLocaitonPoint] as [p].[sptGeoLocaitonPoint].STDistance([Expr1015]))"> | |
<Aggregate AggType="COUNT_BIG" Distinct="false"> | |
<ScalarOperator> | |
<UDTMethod> | |
<CLRFunction Assembly="Microsoft.SqlServer.Types" Class="Microsoft.SqlServer.Types.SqlGeography" Method="STDistance" /> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[p]" Column="sptGeoLocaitonPoint" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Column="Expr1015" /> | |
</Identifier> | |
</ScalarOperator> | |
</UDTMethod> | |
</ScalarOperator> | |
</Aggregate> | |
</ScalarOperator> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Column="Expr1048" /> | |
<ScalarOperator ScalarString="SUM([TBCompany_1].[dbo].[VehicleMonitoringLog].[sptGeoLocaitonPoint] as [p].[sptGeoLocaitonPoint].STDistance([Expr1015]))"> | |
<Aggregate AggType="SUM" Distinct="false"> | |
<ScalarOperator> | |
<UDTMethod> | |
<CLRFunction Assembly="Microsoft.SqlServer.Types" Class="Microsoft.SqlServer.Types.SqlGeography" Method="STDistance" /> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[p]" Column="sptGeoLocaitonPoint" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Column="Expr1015" /> | |
</Identifier> | |
</ScalarOperator> | |
</UDTMethod> | |
</ScalarOperator> | |
</Aggregate> | |
</ScalarOperator> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iAssetId" /> | |
<ScalarOperator ScalarString="ANY([TBCompany_1].[dbo].[VehicleMonitoringLog].[iAssetId] as [ignOn].[iAssetId])"> | |
<Aggregate AggType="ANY" Distinct="false"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iAssetId" /> | |
</Identifier> | |
</ScalarOperator> | |
</Aggregate> | |
</ScalarOperator> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="eEventCode" /> | |
<ScalarOperator ScalarString="ANY([TBCompany_1].[dbo].[VehicleMonitoringLog].[eEventCode])"> | |
<Aggregate AggType="ANY" Distinct="false"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="eEventCode" /> | |
</Identifier> | |
</ScalarOperator> | |
</Aggregate> | |
</ScalarOperator> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iGeofenceId" /> | |
<ScalarOperator ScalarString="ANY([TBCompany_1].[dbo].[VehicleMonitoringLog].[iGeofenceId] as [ignOn].[iGeofenceId])"> | |
<Aggregate AggType="ANY" Distinct="false"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iGeofenceId" /> | |
</Identifier> | |
</ScalarOperator> | |
</Aggregate> | |
</ScalarOperator> | |
</DefinedValue> | |
</DefinedValues> | |
<GroupBy> | |
<ColumnReference Column="Expr1016" /> | |
<ColumnReference Column="Expr1017" /> | |
<ColumnReference Column="Expr1019" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iVehicleMonitoringId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="iVehicleMonitoringId" /> | |
</GroupBy> | |
<RelOp AvgRowSize="8099" EstimateCPU="0.000108099" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Sort" NodeId="3" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="20.4266"> | |
<OutputList> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iVehicleMonitoringId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iGeofenceId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iAssetId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="iVehicleMonitoringId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="eEventCode" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[p]" Column="sptGeoLocaitonPoint" /> | |
<ColumnReference Column="Expr1015" /> | |
<ColumnReference Column="Expr1016" /> | |
<ColumnReference Column="Expr1017" /> | |
<ColumnReference Column="Expr1019" /> | |
</OutputList> | |
<Warnings> | |
<SpillToTempDb SpillLevel="2" /> | |
</Warnings> | |
<MemoryFractions Input="0.5" Output="1" /> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="141710" ActualEndOfScans="1" ActualExecutions="1" /> | |
</RunTimeInformation> | |
<Sort Distinct="false"> | |
<OrderBy> | |
<OrderByColumn Ascending="true"> | |
<ColumnReference Column="Expr1016" /> | |
</OrderByColumn> | |
<OrderByColumn Ascending="true"> | |
<ColumnReference Column="Expr1017" /> | |
</OrderByColumn> | |
<OrderByColumn Ascending="true"> | |
<ColumnReference Column="Expr1019" /> | |
</OrderByColumn> | |
<OrderByColumn Ascending="true"> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iVehicleMonitoringId" /> | |
</OrderByColumn> | |
<OrderByColumn Ascending="true"> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="iVehicleMonitoringId" /> | |
</OrderByColumn> | |
</OrderBy> | |
<RelOp AvgRowSize="8099" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="4" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="20.4153"> | |
<OutputList> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iVehicleMonitoringId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iGeofenceId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iAssetId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="iVehicleMonitoringId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="eEventCode" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[p]" Column="sptGeoLocaitonPoint" /> | |
<ColumnReference Column="Expr1015" /> | |
<ColumnReference Column="Expr1016" /> | |
<ColumnReference Column="Expr1017" /> | |
<ColumnReference Column="Expr1019" /> | |
</OutputList> | |
<ComputeScalar> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Column="Expr1016" /> | |
<ScalarOperator ScalarString="dateadd(hour,CONVERT_IMPLICIT(int,[@fGmtOffSet],0),[TBCompany_1].[dbo].[VehicleMonitoringLog].[dtUTCDateTime] as [ignOn].[dtUTCDateTime])"> | |
<Intrinsic FunctionName="dateadd"> | |
<ScalarOperator> | |
<Const ConstValue="(6)" /> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Column="ConstExpr1022"> | |
<ScalarOperator> | |
<Convert DataType="int" Style="0" Implicit="true"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Column="@fGmtOffSet" /> | |
</Identifier> | |
</ScalarOperator> | |
</Convert> | |
</ScalarOperator> | |
</ColumnReference> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="dtUTCDateTime" /> | |
</Identifier> | |
</ScalarOperator> | |
</Intrinsic> | |
</ScalarOperator> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Column="Expr1017" /> | |
<ScalarOperator ScalarString="dateadd(hour,CONVERT_IMPLICIT(int,[@fGmtOffSet],0),[TBCompany_1].[dbo].[VehicleMonitoringLog].[dtUTCDateTime])"> | |
<Intrinsic FunctionName="dateadd"> | |
<ScalarOperator> | |
<Const ConstValue="(6)" /> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Column="ConstExpr1023"> | |
<ScalarOperator> | |
<Convert DataType="int" Style="0" Implicit="true"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Column="@fGmtOffSet" /> | |
</Identifier> | |
</ScalarOperator> | |
</Convert> | |
</ScalarOperator> | |
</ColumnReference> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="dtUTCDateTime" /> | |
</Identifier> | |
</ScalarOperator> | |
</Intrinsic> | |
</ScalarOperator> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Column="Expr1019" /> | |
<ScalarOperator ScalarString="datediff(second,[TBCompany_1].[dbo].[VehicleMonitoringLog].[dtUTCDateTime] as [ignOn].[dtUTCDateTime],[TBCompany_1].[dbo].[VehicleMonitoringLog].[dtUTCDateTime])"> | |
<Intrinsic FunctionName="datediff"> | |
<ScalarOperator> | |
<Const ConstValue="(8)" /> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="dtUTCDateTime" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="dtUTCDateTime" /> | |
</Identifier> | |
</ScalarOperator> | |
</Intrinsic> | |
</ScalarOperator> | |
</DefinedValue> | |
</DefinedValues> | |
<RelOp AvgRowSize="4101" EstimateCPU="6.28E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Aggregate" NodeId="5" Parallel="false" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="20.4153"> | |
<OutputList> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iVehicleMonitoringId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iGeofenceId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iAssetId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="dtUTCDateTime" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="iVehicleMonitoringId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="dtUTCDateTime" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="eEventCode" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[p]" Column="sptGeoLocaitonPoint" /> | |
<ColumnReference Column="Expr1015" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="141710" ActualEndOfScans="1" ActualExecutions="1" /> | |
</RunTimeInformation> | |
<StreamAggregate> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Column="Expr1015" /> | |
<ScalarOperator ScalarString="LAST_VALUE([TBCompany_1].[dbo].[VehicleMonitoringLog].[sptGeoLocaitonPoint] as [p].[sptGeoLocaitonPoint])"> | |
<Aggregate AggType="LAST_VALUE" Distinct="false"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[p]" Column="sptGeoLocaitonPoint" /> | |
</Identifier> | |
</ScalarOperator> | |
</Aggregate> | |
</ScalarOperator> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iVehicleMonitoringId" /> | |
<ScalarOperator ScalarString="ANY([TBCompany_1].[dbo].[VehicleMonitoringLog].[iVehicleMonitoringId] as [ignOn].[iVehicleMonitoringId])"> | |
<Aggregate AggType="ANY" Distinct="false"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iVehicleMonitoringId" /> | |
</Identifier> | |
</ScalarOperator> | |
</Aggregate> | |
</ScalarOperator> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iGeofenceId" /> | |
<ScalarOperator ScalarString="ANY([TBCompany_1].[dbo].[VehicleMonitoringLog].[iGeofenceId] as [ignOn].[iGeofenceId])"> | |
<Aggregate AggType="ANY" Distinct="false"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iGeofenceId" /> | |
</Identifier> | |
</ScalarOperator> | |
</Aggregate> | |
</ScalarOperator> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="iVehicleMonitoringId" /> | |
<ScalarOperator ScalarString="ANY([TBCompany_1].[dbo].[VehicleMonitoringLog].[iVehicleMonitoringId])"> | |
<Aggregate AggType="ANY" Distinct="false"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="iVehicleMonitoringId" /> | |
</Identifier> | |
</ScalarOperator> | |
</Aggregate> | |
</ScalarOperator> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="dtUTCDateTime" /> | |
<ScalarOperator ScalarString="ANY([TBCompany_1].[dbo].[VehicleMonitoringLog].[dtUTCDateTime])"> | |
<Aggregate AggType="ANY" Distinct="false"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="dtUTCDateTime" /> | |
</Identifier> | |
</ScalarOperator> | |
</Aggregate> | |
</ScalarOperator> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="eEventCode" /> | |
<ScalarOperator ScalarString="ANY([TBCompany_1].[dbo].[VehicleMonitoringLog].[eEventCode])"> | |
<Aggregate AggType="ANY" Distinct="false"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="eEventCode" /> | |
</Identifier> | |
</ScalarOperator> | |
</Aggregate> | |
</ScalarOperator> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[p]" Column="sptGeoLocaitonPoint" /> | |
<ScalarOperator ScalarString="ANY([TBCompany_1].[dbo].[VehicleMonitoringLog].[sptGeoLocaitonPoint] as [p].[sptGeoLocaitonPoint])"> | |
<Aggregate AggType="ANY" Distinct="false"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[p]" Column="sptGeoLocaitonPoint" /> | |
</Identifier> | |
</ScalarOperator> | |
</Aggregate> | |
</ScalarOperator> | |
</DefinedValue> | |
</DefinedValues> | |
<GroupBy> | |
<ColumnReference Column="WindowCount1046" /> | |
</GroupBy> | |
<RelOp AvgRowSize="4101" EstimateCPU="2.198E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2" LogicalOp="Window Spool" NodeId="6" Parallel="false" PhysicalOp="Window Spool" EstimatedTotalSubtreeCost="20.4153"> | |
<OutputList> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iVehicleMonitoringId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iGeofenceId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iAssetId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="dtUTCDateTime" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="iVehicleMonitoringId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="dtUTCDateTime" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="eEventCode" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[p]" Column="sptGeoLocaitonPoint" /> | |
<ColumnReference Column="RowNumber1028" /> | |
<ColumnReference Column="WindowCount1046" /> | |
<ColumnReference Column="Segment1045" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="278590" ActualEndOfScans="1" ActualExecutions="1" /> | |
</RunTimeInformation> | |
<WindowSpool> | |
<RelOp AvgRowSize="4101" EstimateCPU="6.28E-08" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Segment" NodeId="7" Parallel="false" PhysicalOp="Segment" EstimatedTotalSubtreeCost="20.4153"> | |
<OutputList> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iVehicleMonitoringId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iGeofenceId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iAssetId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="dtUTCDateTime" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="iVehicleMonitoringId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="dtUTCDateTime" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="eEventCode" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[p]" Column="sptGeoLocaitonPoint" /> | |
<ColumnReference Column="RowNumber1028" /> | |
<ColumnReference Column="TopRowNumber1029" /> | |
<ColumnReference Column="BottomRowNumber1030" /> | |
<ColumnReference Column="Segment1045" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="141710" ActualEndOfScans="1" ActualExecutions="1" /> | |
</RunTimeInformation> | |
<Segment> | |
<GroupBy> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iAssetId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="dtUTCDateTime" /> | |
</GroupBy> | |
<SegmentColumn> | |
<ColumnReference Column="Segment1045" /> | |
</SegmentColumn> | |
<RelOp AvgRowSize="4093" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="8" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="20.4153"> | |
<OutputList> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iVehicleMonitoringId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iGeofenceId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iAssetId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="dtUTCDateTime" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="iVehicleMonitoringId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="dtUTCDateTime" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="eEventCode" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[p]" Column="sptGeoLocaitonPoint" /> | |
<ColumnReference Column="RowNumber1028" /> | |
<ColumnReference Column="TopRowNumber1029" /> | |
<ColumnReference Column="BottomRowNumber1030" /> | |
</OutputList> | |
<ComputeScalar> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Column="TopRowNumber1029" /> | |
<ScalarOperator ScalarString="[RowNumber1028]+(1)"> | |
<Arithmetic Operation="ADD"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Column="RowNumber1028" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Const ConstValue="(1)" /> | |
</ScalarOperator> | |
</Arithmetic> | |
</ScalarOperator> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Column="BottomRowNumber1030" /> | |
<ScalarOperator ScalarString="[RowNumber1028]+(1)"> | |
<Arithmetic Operation="ADD"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Column="RowNumber1028" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Const ConstValue="(1)" /> | |
</ScalarOperator> | |
</Arithmetic> | |
</ScalarOperator> | |
</DefinedValue> | |
</DefinedValues> | |
<RelOp AvgRowSize="4077" EstimateCPU="8E-08" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="9" Parallel="false" PhysicalOp="Sequence Project" EstimatedTotalSubtreeCost="20.4153"> | |
<OutputList> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iVehicleMonitoringId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iGeofenceId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iAssetId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="dtUTCDateTime" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="iVehicleMonitoringId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="dtUTCDateTime" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="eEventCode" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[p]" Column="sptGeoLocaitonPoint" /> | |
<ColumnReference Column="RowNumber1028" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="141710" ActualEndOfScans="1" ActualExecutions="1" /> | |
</RunTimeInformation> | |
<SequenceProject> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Column="RowNumber1028" /> | |
<ScalarOperator ScalarString="row_number"> | |
<Sequence FunctionName="row_number" /> | |
</ScalarOperator> | |
</DefinedValue> | |
</DefinedValues> | |
<RelOp AvgRowSize="4077" EstimateCPU="2E-08" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Segment" NodeId="10" Parallel="false" PhysicalOp="Segment" EstimatedTotalSubtreeCost="20.4153"> | |
<OutputList> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iVehicleMonitoringId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iGeofenceId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iAssetId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="dtUTCDateTime" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="iVehicleMonitoringId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="dtUTCDateTime" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="eEventCode" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[p]" Column="sptGeoLocaitonPoint" /> | |
<ColumnReference Column="Segment1044" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="141710" ActualEndOfScans="1" ActualExecutions="1" /> | |
</RunTimeInformation> | |
<Segment> | |
<GroupBy> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iAssetId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="dtUTCDateTime" /> | |
</GroupBy> | |
<SegmentColumn> | |
<ColumnReference Column="Segment1044" /> | |
</SegmentColumn> | |
<RelOp AvgRowSize="4068" EstimateCPU="0.0135447" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Inner Join" NodeId="11" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="20.4153"> | |
<OutputList> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iVehicleMonitoringId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iGeofenceId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iAssetId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="dtUTCDateTime" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="iVehicleMonitoringId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="dtUTCDateTime" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="eEventCode" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[p]" Column="sptGeoLocaitonPoint" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="141710" ActualEndOfScans="1" ActualExecutions="1" /> | |
</RunTimeInformation> | |
<NestedLoops Optimized="false" WithOrderedPrefetch="true"> | |
<OuterReferences> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iAssetId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="dtUTCDateTime" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="dtUTCDateTime" /> | |
<ColumnReference Column="Expr1043" /> | |
</OuterReferences> | |
<RelOp AvgRowSize="40" EstimateCPU="0.0135447" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3240.36" LogicalOp="Inner Join" NodeId="13" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="10.5883"> | |
<OutputList> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iVehicleMonitoringId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iGeofenceId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iAssetId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="dtUTCDateTime" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="iVehicleMonitoringId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="dtUTCDateTime" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="eEventCode" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="4830" ActualEndOfScans="1" ActualExecutions="1" /> | |
</RunTimeInformation> | |
<NestedLoops Optimized="false" WithOrderedPrefetch="true"> | |
<OuterReferences> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iAssetId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="dtUTCDateTime" /> | |
<ColumnReference Column="Expr1042" /> | |
</OuterReferences> | |
<RelOp AvgRowSize="27" EstimateCPU="0.0135447" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3240.36" LogicalOp="Inner Join" NodeId="16" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="9.90827"> | |
<OutputList> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iVehicleMonitoringId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iGeofenceId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iAssetId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="dtUTCDateTime" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="4830" ActualEndOfScans="1" ActualExecutions="1" /> | |
</RunTimeInformation> | |
<NestedLoops Optimized="false" WithOrderedPrefetch="true"> | |
<OuterReferences> | |
<ColumnReference Column="Uniq1002" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iAssetId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="dtUTCDateTime" /> | |
<ColumnReference Column="Expr1041" /> | |
</OuterReferences> | |
<RelOp AvgRowSize="27" EstimateCPU="0.0135447" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3240.36" LogicalOp="Inner Join" NodeId="18" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.222218"> | |
<OutputList> | |
<ColumnReference Column="Uniq1002" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iGeofenceId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iAssetId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="dtUTCDateTime" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="4830" ActualEndOfScans="1" ActualExecutions="1" /> | |
</RunTimeInformation> | |
<NestedLoops Optimized="false" WithOrderedPrefetch="true"> | |
<OuterReferences> | |
<ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#tblAssets]" Column="iAssetID" /> | |
<ColumnReference Column="Expr1040" /> | |
</OuterReferences> | |
<RelOp AvgRowSize="11" EstimateCPU="0.000641449" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="59" LogicalOp="Distinct Sort" NodeId="20" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.0152496"> | |
<OutputList> | |
<ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#tblAssets]" Column="iAssetID" /> | |
</OutputList> | |
<MemoryFractions Input="1" Output="0.5" /> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="59" ActualEndOfScans="1" ActualExecutions="1" /> | |
</RunTimeInformation> | |
<Sort Distinct="true"> | |
<OrderBy> | |
<OrderByColumn Ascending="true"> | |
<ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#tblAssets]" Column="iAssetID" /> | |
</OrderByColumn> | |
</OrderBy> | |
<RelOp AvgRowSize="11" EstimateCPU="0.0002219" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="59" LogicalOp="Table Scan" NodeId="21" Parallel="false" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="0.0033469" TableCardinality="59"> | |
<OutputList> | |
<ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#tblAssets]" Column="iAssetID" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="59" ActualEndOfScans="1" ActualExecutions="1" /> | |
</RunTimeInformation> | |
<TableScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false"> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#tblAssets]" Column="iAssetID" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[tempdb]" Schema="[dbo]" Table="[#tblAssets]" IndexKind="Heap" /> | |
</TableScan> | |
</RelOp> | |
</Sort> | |
</RelOp> | |
<RelOp AvgRowSize="27" EstimateCPU="0.000217413" EstimateIO="0.003125" EstimateRebinds="58" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="54.9213" LogicalOp="Index Seek" NodeId="22" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.193423" TableCardinality="1162990"> | |
<OutputList> | |
<ColumnReference Column="Uniq1002" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iGeofenceId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iAssetId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="dtUTCDateTime" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="4830" ActualEndOfScans="59" ActualExecutions="59" /> | |
</RunTimeInformation> | |
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Column="Uniq1002" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iGeofenceId" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iAssetId" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="dtUTCDateTime" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Index="[IX_VehicleMonitoringLog_iAssetId_eEventCode_NonClustered]" Alias="[ignOn]" IndexKind="NonClustered" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iAssetId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="eEventCode" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="[tempdb].[dbo].[#tblAssets].[iAssetID]"> | |
<Identifier> | |
<ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#tblAssets]" Column="iAssetID" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator ScalarString="(1)"> | |
<Const ConstValue="(1)" /> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
<StartRange ScanType="GT"> | |
<RangeColumns> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="dtUTCDateTime" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="[@utcStartDate]"> | |
<Identifier> | |
<ColumnReference Column="@utcStartDate" /> | |
</Identifier> | |
</ScalarOperator> | |
</RangeExpressions> | |
</StartRange> | |
<EndRange ScanType="LT"> | |
<RangeColumns> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="dtUTCDateTime" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="[@utcEndDate]"> | |
<Identifier> | |
<ColumnReference Column="@utcEndDate" /> | |
</Identifier> | |
</ScalarOperator> | |
</RangeExpressions> | |
</EndRange> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
</IndexScan> | |
</RelOp> | |
</NestedLoops> | |
</RelOp> | |
<RelOp AvgRowSize="11" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="3239.36" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="24" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="9.6725" TableCardinality="1162990"> | |
<OutputList> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iVehicleMonitoringId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="4830" ActualEndOfScans="0" ActualExecutions="4830" /> | |
</RunTimeInformation> | |
<IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iVehicleMonitoringId" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Index="[VehicleMonitoringLog_Asset_dtmUTCDateTime_ClusteredIndex]" Alias="[ignOn]" TableReferenceId="-1" IndexKind="Clustered" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iAssetId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="dtUTCDateTime" /> | |
<ColumnReference Column="Uniq1002" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="[TBCompany_1].[dbo].[VehicleMonitoringLog].[iAssetId] as [ignOn].[iAssetId]"> | |
<Identifier> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iAssetId" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator ScalarString="[TBCompany_1].[dbo].[VehicleMonitoringLog].[dtUTCDateTime] as [ignOn].[dtUTCDateTime]"> | |
<Identifier> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="dtUTCDateTime" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator ScalarString="[Uniq1002]"> | |
<Identifier> | |
<ColumnReference Column="Uniq1002" /> | |
</Identifier> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
</IndexScan> | |
</RelOp> | |
</NestedLoops> | |
</RelOp> | |
<RelOp AvgRowSize="20" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="3239.36" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Top" NodeId="29" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="0.666452"> | |
<OutputList> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="iVehicleMonitoringId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="dtUTCDateTime" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="eEventCode" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="4830" ActualEndOfScans="0" ActualExecutions="4830" /> | |
</RunTimeInformation> | |
<Top RowCount="false" IsPercent="false" WithTies="false"> | |
<TopExpression> | |
<ScalarOperator ScalarString="(1)"> | |
<Const ConstValue="(1)" /> | |
</ScalarOperator> | |
</TopExpression> | |
<RelOp AvgRowSize="24" EstimateCPU="0.00888881" EstimateIO="0.0979398" EstimateRebinds="3239.36" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="30" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.660393" TableCardinality="1162990"> | |
<OutputList> | |
<ColumnReference Column="Uniq1005" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="iVehicleMonitoringId" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="dtUTCDateTime" /> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="eEventCode" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="4830" ActualEndOfScans="0" ActualExecutions="4830" /> | |
</RunTimeInformation> | |
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Column="Uniq1005" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="iVehicleMonitoringId" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="dtUTCDateTime" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="eEventCode" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Index="[VehicleMonitoringLog_Asset_dtmUTCDateTime_ClusteredIndex]" IndexKind="Clustered" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="iAssetId" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="[TBCompany_1].[dbo].[VehicleMonitoringLog].[iAssetId] as [ignOn].[iAssetId]"> | |
<Identifier> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iAssetId" /> | |
</Identifier> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
<StartRange ScanType="GT"> | |
<RangeColumns> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="dtUTCDateTime" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="[TBCompany_1].[dbo].[VehicleMonitoringLog].[dtUTCDateTime] as [ignOn].[dtUTCDateTime]"> | |
<Identifier> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="dtUTCDateTime" /> | |
</Identifier> | |
</ScalarOperator> | |
</RangeExpressions> | |
</StartRange> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
<Predicate> | |
<ScalarOperator ScalarString="[TBCompany_1].[dbo].[VehicleMonitoringLog].[eEventCode]=(2)"> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="eEventCode" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Const ConstValue="(2)" /> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</Predicate> | |
</IndexScan> | |
</RelOp> | |
</Top> | |
</RelOp> | |
</NestedLoops> | |
</RelOp> | |
<RelOp AvgRowSize="4035" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="3239.36" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="32" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="9.81346" TableCardinality="1162990"> | |
<OutputList> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[p]" Column="sptGeoLocaitonPoint" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="141710" ActualEndOfScans="4830" ActualExecutions="4830" /> | |
</RunTimeInformation> | |
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[p]" Column="sptGeoLocaitonPoint" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Index="[VehicleMonitoringLog_Asset_dtmUTCDateTime_ClusteredIndex]" Alias="[p]" IndexKind="Clustered" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[p]" Column="iAssetId" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="[TBCompany_1].[dbo].[VehicleMonitoringLog].[iAssetId] as [ignOn].[iAssetId]"> | |
<Identifier> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="iAssetId" /> | |
</Identifier> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
<StartRange ScanType="GE"> | |
<RangeColumns> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[p]" Column="dtUTCDateTime" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="[TBCompany_1].[dbo].[VehicleMonitoringLog].[dtUTCDateTime] as [ignOn].[dtUTCDateTime]"> | |
<Identifier> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[ignOn]" Column="dtUTCDateTime" /> | |
</Identifier> | |
</ScalarOperator> | |
</RangeExpressions> | |
</StartRange> | |
<EndRange ScanType="LE"> | |
<RangeColumns> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Alias="[p]" Column="dtUTCDateTime" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="[TBCompany_1].[dbo].[VehicleMonitoringLog].[dtUTCDateTime]"> | |
<Identifier> | |
<ColumnReference Database="[TBCompany_1]" Schema="[dbo]" Table="[VehicleMonitoringLog]" Column="dtUTCDateTime" /> | |
</Identifier> | |
</ScalarOperator> | |
</RangeExpressions> | |
</EndRange> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
</IndexScan> | |
</RelOp> | |
</NestedLoops> | |
</RelOp> | |
</Segment> | |
</RelOp> | |
</SequenceProject> | |
</RelOp> | |
</ComputeScalar> | |
</RelOp> | |
</Segment> | |
</RelOp> | |
</WindowSpool> | |
</RelOp> | |
</StreamAggregate> | |
</RelOp> | |
</ComputeScalar> | |
</RelOp> | |
</Sort> | |
</RelOp> | |
</StreamAggregate> | |
</RelOp> | |
</ComputeScalar> | |
</RelOp> | |
</ComputeScalar> | |
</RelOp> | |
<ParameterList> | |
<ColumnReference Column="@fGmtOffSet" ParameterRuntimeValue="(5.000000000000000e+000)" /> | |
<ColumnReference Column="@utcEndDate" ParameterRuntimeValue="'2016-01-30 18:59:00.000'" /> | |
<ColumnReference Column="@utcStartDate" ParameterRuntimeValue="'2015-11-30 19:00:00.000'" /> | |
</ParameterList> | |
</QueryPlan> | |
</StmtSimple> | |
</Statements> | |
</Batch> | |
</BatchSequence> | |
</ShowPlanXML> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment