Created
March 25, 2016 10:19
-
-
Save mdawood1991/33817f95aad40d42631b to your computer and use it in GitHub Desktop.
ExecutionPlan With Map URl
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="43" StatementEstRows="154399" StatementId="9" StatementOptmLevel="FULL" StatementSubTreeCost="30.421" StatementText="Select
 OverspeedReportId = ol.iVehicleMonitoringId,
 AssetId = iAssetId,
 Registration = sReference,
 CategoryId = iCategoryId,
 CategoryName = sCategoryName,
 SiteId = iSiteId,
 SiteName = sSiteName,
 OverspeedDate = FORMAT(dtutcDateTime, 'dd-MMM-yyyy HH:mm:ss'),
 DistanceTraveledSinceLastOverSpeed = DistanceCoveredKM,
 TimeDifferenceDDDHHMMSS = SUBSTRING(dbo.xPT_ConvertTimeToDDHHMMSS(DiffSeconds,'s'),1,12),
 SpeedKM = fSpeed,
 [Address] = sState +', '+ sDistrict +', ' +sPoi +', ' + sRoad +', '+sPoi,
 MapUrl = @sUrlHeader+'/Report/ReportOnMap/?id='
 +CONVERT(VARCHAR(10), @iCompanyId)+'&ReportName=OverspeedReport'
 +'&AssetId='+ CONVERT(VARCHAR(10), iAssetId)
 +'&MaxSpeed='+ CONVERT(VARCHAR(10), fSpeed) 
 +'&OverspeedingDate=' + FORMAT(dtutcDateTime, 'dd-MMM-yyyy HH:mm:ss')
 +'&VehicleMonitoringLogId='+ CONVERT(VARCHAR, ol.iVehicleMonitoringId),
 [Locate] = 'Locate'

 FROM #overspeedLogs ol
 LEFT JOIN VehicleGISAddressLog gis on gis.iVehicleMonitoringId = ol.iVehicleMonitoringId
 ORDER BY ol.iAssetId, ol.dtUtcDateTime


 /********************Report Header Details*********************/
" StatementType="SELECT" QueryHash="0xBBCEC95439F06680" QueryPlanHash="0x470CE0DB90CE4B40" 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="0" NonParallelPlanReason="CouldNotGenerateValidParallelPlan" CachedPlanSize="56" CompileTime="156" CompileCPU="147" CompileMemory="608"> | |
| <Warnings> | |
| <PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT(varchar(30),[ol].[iVehicleMonitoringId],0)" /> | |
| </Warnings> | |
| <MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" /> | |
| <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="419264" EstimatedPagesCached="209632" EstimatedAvailableDegreeOfParallelism="4" /> | |
| <RelOp AvgRowSize="9304" EstimateCPU="0.0154399" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="154399" LogicalOp="Compute Scalar" NodeId="0" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="30.421"> | |
| <OutputList> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="iVehicleMonitoringId" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="fSpeed" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="iAssetId" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="sReference" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="iCategoryId" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="sCategoryName" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="iSiteId" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="sSiteName" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="dtUtcDateTime" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="DistanceCoveredKM" /> | |
| <ColumnReference Column="Expr1006" /> | |
| <ColumnReference Column="Expr1007" /> | |
| <ColumnReference Column="Expr1008" /> | |
| <ColumnReference Column="Expr1009" /> | |
| <ColumnReference Column="Expr1010" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="121861" ActualEndOfScans="1" ActualExecutions="1" /> | |
| </RunTimeInformation> | |
| <ComputeScalar> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Column="Expr1007" /> | |
| <ScalarOperator ScalarString="substring([TBCompany_265].[dbo].[xPT_ConvertTimeToDDHHMMSS]([Expr1012],'s'),(1),(12))"> | |
| <Intrinsic FunctionName="substring"> | |
| <ScalarOperator> | |
| <UserDefinedFunction FunctionName="[TBCompany_265].[dbo].[xPT_ConvertTimeToDDHHMMSS]"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Column="Expr1012" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="'s'" /> | |
| </ScalarOperator> | |
| </UserDefinedFunction> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="(1)" /> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="(12)" /> | |
| </ScalarOperator> | |
| </Intrinsic> | |
| </ScalarOperator> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Expr1008" /> | |
| <ScalarOperator ScalarString="[TBCompany_265].[dbo].[VehicleGISAddressLog].[sState] as [gis].[sState]+', '+[TBCompany_265].[dbo].[VehicleGISAddressLog].[sDistrict] as [gis].[sDistrict]+', '+[TBCompany_265].[dbo].[VehicleGISAddressLog].[sPOI] as [gis].[sPOI]+', '+[TBCompany_265].[dbo].[VehicleGISAddressLog].[sRoad] as [gis].[sRoad]+', '+[TBCompany_265].[dbo].[VehicleGISAddressLog].[sPOI] as [gis].[sPOI]"> | |
| <Arithmetic Operation="ADD"> | |
| <ScalarOperator> | |
| <Arithmetic Operation="ADD"> | |
| <ScalarOperator> | |
| <Arithmetic Operation="ADD"> | |
| <ScalarOperator> | |
| <Arithmetic Operation="ADD"> | |
| <ScalarOperator> | |
| <Arithmetic Operation="ADD"> | |
| <ScalarOperator> | |
| <Arithmetic Operation="ADD"> | |
| <ScalarOperator> | |
| <Arithmetic Operation="ADD"> | |
| <ScalarOperator> | |
| <Arithmetic Operation="ADD"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[TBCompany_265]" Schema="[dbo]" Table="[VehicleGISAddressLog]" Alias="[gis]" Column="sState" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="', '" /> | |
| </ScalarOperator> | |
| </Arithmetic> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[TBCompany_265]" Schema="[dbo]" Table="[VehicleGISAddressLog]" Alias="[gis]" Column="sDistrict" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Arithmetic> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="', '" /> | |
| </ScalarOperator> | |
| </Arithmetic> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[TBCompany_265]" Schema="[dbo]" Table="[VehicleGISAddressLog]" Alias="[gis]" Column="sPOI" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Arithmetic> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="', '" /> | |
| </ScalarOperator> | |
| </Arithmetic> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[TBCompany_265]" Schema="[dbo]" Table="[VehicleGISAddressLog]" Alias="[gis]" Column="sRoad" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Arithmetic> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="', '" /> | |
| </ScalarOperator> | |
| </Arithmetic> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[TBCompany_265]" Schema="[dbo]" Table="[VehicleGISAddressLog]" Alias="[gis]" Column="sPOI" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Arithmetic> | |
| </ScalarOperator> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Expr1009" /> | |
| <ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(618),[@sUrlHeader]+'/Report/ReportOnMap/?id='+CONVERT(varchar(10),[@iCompanyId],0)+'&ReportName=OverspeedReport'+'&AssetId='+[Expr1013]+'&MaxSpeed='+[Expr1014]+'&OverspeedingDate=',0)+[Expr1006]+N'&VehicleMonitoringLogId='+[Expr1015]"> | |
| <Arithmetic Operation="ADD"> | |
| <ScalarOperator> | |
| <Arithmetic Operation="ADD"> | |
| <ScalarOperator> | |
| <Arithmetic Operation="ADD"> | |
| <ScalarOperator> | |
| <Convert DataType="nvarchar" Length="1236" Style="0" Implicit="true"> | |
| <ScalarOperator> | |
| <Arithmetic Operation="ADD"> | |
| <ScalarOperator> | |
| <Arithmetic Operation="ADD"> | |
| <ScalarOperator> | |
| <Arithmetic Operation="ADD"> | |
| <ScalarOperator> | |
| <Arithmetic Operation="ADD"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Column="ConstExpr1011"> | |
| <ScalarOperator> | |
| <Arithmetic Operation="ADD"> | |
| <ScalarOperator> | |
| <Arithmetic Operation="ADD"> | |
| <ScalarOperator> | |
| <Arithmetic Operation="ADD"> | |
| <ScalarOperator> | |
| <Arithmetic Operation="ADD"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Column="@sUrlHeader" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="'/Report/ReportOnMap/?id='" /> | |
| </ScalarOperator> | |
| </Arithmetic> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Convert DataType="varchar" Length="10" Style="0" Implicit="false"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Column="@iCompanyId" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Convert> | |
| </ScalarOperator> | |
| </Arithmetic> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="'&ReportName=OverspeedReport'" /> | |
| </ScalarOperator> | |
| </Arithmetic> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="'&AssetId='" /> | |
| </ScalarOperator> | |
| </Arithmetic> | |
| </ScalarOperator> | |
| </ColumnReference> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Column="Expr1013" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Arithmetic> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="'&MaxSpeed='" /> | |
| </ScalarOperator> | |
| </Arithmetic> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Column="Expr1014" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Arithmetic> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="'&OverspeedingDate='" /> | |
| </ScalarOperator> | |
| </Arithmetic> | |
| </ScalarOperator> | |
| </Convert> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Column="Expr1006" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Arithmetic> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="N'&VehicleMonitoringLogId='" /> | |
| </ScalarOperator> | |
| </Arithmetic> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Column="Expr1015" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Arithmetic> | |
| </ScalarOperator> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Expr1010" /> | |
| <ScalarOperator ScalarString="'Locate'"> | |
| <Const ConstValue="'Locate'" /> | |
| </ScalarOperator> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <RelOp AvgRowSize="5226" EstimateCPU="0.645387" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="154399" LogicalOp="Left Outer Join" NodeId="1" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="30.4056"> | |
| <OutputList> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="iVehicleMonitoringId" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="fSpeed" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="iAssetId" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="sReference" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="iCategoryId" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="sCategoryName" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="iSiteId" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="sSiteName" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="dtUtcDateTime" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="DistanceCoveredKM" /> | |
| <ColumnReference Database="[TBCompany_265]" Schema="[dbo]" Table="[VehicleGISAddressLog]" Alias="[gis]" Column="sRoad" /> | |
| <ColumnReference Database="[TBCompany_265]" Schema="[dbo]" Table="[VehicleGISAddressLog]" Alias="[gis]" Column="sState" /> | |
| <ColumnReference Database="[TBCompany_265]" Schema="[dbo]" Table="[VehicleGISAddressLog]" Alias="[gis]" Column="sDistrict" /> | |
| <ColumnReference Database="[TBCompany_265]" Schema="[dbo]" Table="[VehicleGISAddressLog]" Alias="[gis]" Column="sPOI" /> | |
| <ColumnReference Column="Expr1006" /> | |
| <ColumnReference Column="Expr1012" /> | |
| <ColumnReference Column="Expr1013" /> | |
| <ColumnReference Column="Expr1014" /> | |
| <ColumnReference Column="Expr1015" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="121861" ActualEndOfScans="1" ActualExecutions="1" /> | |
| </RunTimeInformation> | |
| <NestedLoops Optimized="false" WithOrderedPrefetch="true"> | |
| <OuterReferences> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="iVehicleMonitoringId" /> | |
| <ColumnReference Column="Expr1016" /> | |
| </OuterReferences> | |
| <RelOp AvgRowSize="4717" EstimateCPU="0.0121861" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="121861" LogicalOp="Compute Scalar" NodeId="3" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="1.45026"> | |
| <OutputList> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="iVehicleMonitoringId" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="fSpeed" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="iAssetId" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="sReference" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="iCategoryId" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="sCategoryName" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="iSiteId" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="sSiteName" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="dtUtcDateTime" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="DistanceCoveredKM" /> | |
| <ColumnReference Column="Expr1006" /> | |
| <ColumnReference Column="Expr1012" /> | |
| <ColumnReference Column="Expr1013" /> | |
| <ColumnReference Column="Expr1014" /> | |
| <ColumnReference Column="Expr1015" /> | |
| </OutputList> | |
| <ComputeScalar> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Column="Expr1006" /> | |
| <ScalarOperator ScalarString="format(CONVERT_IMPLICIT(datetime2(3),[tempdb].[dbo].[#overspeedLogs].[dtUtcDateTime] as [ol].[dtUtcDateTime],0),N'dd-MMM-yyyy HH:mm:ss')"> | |
| <Intrinsic FunctionName="format"> | |
| <ScalarOperator> | |
| <Convert DataType="datetime2" Style="0" Implicit="true"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="dtUtcDateTime" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Convert> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="N'dd-MMM-yyyy HH:mm:ss'" /> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="" /> | |
| </ScalarOperator> | |
| </Intrinsic> | |
| </ScalarOperator> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Expr1012" /> | |
| <ScalarOperator ScalarString="CONVERT_IMPLICIT(decimal(28,3),[tempdb].[dbo].[#overspeedLogs].[DiffSeconds] as [ol].[DiffSeconds],0)"> | |
| <Convert DataType="decimal" Precision="28" Scale="3" Style="0" Implicit="true"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="DiffSeconds" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Convert> | |
| </ScalarOperator> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Expr1013" /> | |
| <ScalarOperator ScalarString="CONVERT(varchar(10),[tempdb].[dbo].[#overspeedLogs].[iAssetId] as [ol].[iAssetId],0)"> | |
| <Convert DataType="varchar" Length="10" Style="0" Implicit="false"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="iAssetId" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Convert> | |
| </ScalarOperator> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Expr1014" /> | |
| <ScalarOperator ScalarString="CONVERT(varchar(10),[tempdb].[dbo].[#overspeedLogs].[fSpeed] as [ol].[fSpeed],0)"> | |
| <Convert DataType="varchar" Length="10" Style="0" Implicit="false"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="fSpeed" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Convert> | |
| </ScalarOperator> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Expr1015" /> | |
| <ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(30),CONVERT(varchar(30),[tempdb].[dbo].[#overspeedLogs].[iVehicleMonitoringId] as [ol].[iVehicleMonitoringId],0),0)"> | |
| <Convert DataType="nvarchar" Length="60" Style="0" Implicit="true"> | |
| <ScalarOperator> | |
| <Convert DataType="varchar" Length="30" Style="0" Implicit="false"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="iVehicleMonitoringId" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Convert> | |
| </ScalarOperator> | |
| </Convert> | |
| </ScalarOperator> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <RelOp AvgRowSize="664" EstimateCPU="0.134204" EstimateIO="1.30387" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="121861" LogicalOp="Clustered Index Scan" NodeId="4" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="1.43807" TableCardinality="121861"> | |
| <OutputList> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="iVehicleMonitoringId" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="fSpeed" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="iAssetId" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="sReference" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="iCategoryId" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="sCategoryName" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="iSiteId" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="sSiteName" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="dtUtcDateTime" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="DistanceCoveredKM" /> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="DiffSeconds" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="121861" ActualEndOfScans="1" ActualExecutions="1" /> | |
| </RunTimeInformation> | |
| <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="iVehicleMonitoringId" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="fSpeed" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="iAssetId" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="sReference" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="iCategoryId" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="sCategoryName" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="iSiteId" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="sSiteName" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="dtUtcDateTime" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="DistanceCoveredKM" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="DiffSeconds" /> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <Object Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Index="[OL_Index]" Alias="[ol]" IndexKind="Clustered" /> | |
| </IndexScan> | |
| </RelOp> | |
| </ComputeScalar> | |
| </RelOp> | |
| <RelOp AvgRowSize="517" EstimateCPU="0.000158394" EstimateIO="0.003125" EstimateRebinds="121860" EstimateRewinds="0.00121839" EstimatedExecutionMode="Row" EstimateRows="1.26701" LogicalOp="Clustered Index Seek" NodeId="16" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="28.31" TableCardinality="2659850"> | |
| <OutputList> | |
| <ColumnReference Database="[TBCompany_265]" Schema="[dbo]" Table="[VehicleGISAddressLog]" Alias="[gis]" Column="sRoad" /> | |
| <ColumnReference Database="[TBCompany_265]" Schema="[dbo]" Table="[VehicleGISAddressLog]" Alias="[gis]" Column="sState" /> | |
| <ColumnReference Database="[TBCompany_265]" Schema="[dbo]" Table="[VehicleGISAddressLog]" Alias="[gis]" Column="sDistrict" /> | |
| <ColumnReference Database="[TBCompany_265]" Schema="[dbo]" Table="[VehicleGISAddressLog]" Alias="[gis]" Column="sPOI" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="120912" ActualEndOfScans="121861" ActualExecutions="121861" /> | |
| </RunTimeInformation> | |
| <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Database="[TBCompany_265]" Schema="[dbo]" Table="[VehicleGISAddressLog]" Alias="[gis]" Column="sRoad" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[TBCompany_265]" Schema="[dbo]" Table="[VehicleGISAddressLog]" Alias="[gis]" Column="sState" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[TBCompany_265]" Schema="[dbo]" Table="[VehicleGISAddressLog]" Alias="[gis]" Column="sDistrict" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[TBCompany_265]" Schema="[dbo]" Table="[VehicleGISAddressLog]" Alias="[gis]" Column="sPOI" /> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <Object Database="[TBCompany_265]" Schema="[dbo]" Table="[VehicleGISAddressLog]" Index="[VehicleGISAddressLog_iVehicleMonitoringId]" Alias="[gis]" IndexKind="Clustered" /> | |
| <SeekPredicates> | |
| <SeekPredicateNew> | |
| <SeekKeys> | |
| <Prefix ScanType="EQ"> | |
| <RangeColumns> | |
| <ColumnReference Database="[TBCompany_265]" Schema="[dbo]" Table="[VehicleGISAddressLog]" Alias="[gis]" Column="iVehicleMonitoringId" /> | |
| </RangeColumns> | |
| <RangeExpressions> | |
| <ScalarOperator ScalarString="[tempdb].[dbo].[#overspeedLogs].[iVehicleMonitoringId] as [ol].[iVehicleMonitoringId]"> | |
| <Identifier> | |
| <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#overspeedLogs]" Alias="[ol]" Column="iVehicleMonitoringId" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </RangeExpressions> | |
| </Prefix> | |
| </SeekKeys> | |
| </SeekPredicateNew> | |
| </SeekPredicates> | |
| </IndexScan> | |
| </RelOp> | |
| </NestedLoops> | |
| </RelOp> | |
| </ComputeScalar> | |
| </RelOp> | |
| <ParameterList> | |
| <ColumnReference Column="@iCompanyId" ParameterRuntimeValue="(265)" /> | |
| <ColumnReference Column="@sUrlHeader" ParameterRuntimeValue="''" /> | |
| </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