Dawood Awan mdawood1991
mdawood1991
/ Execution Plan Journey
Created
March 26, 2016 12:07
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) 
&#x |
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="158416" StatementId="9" StatementOptmLevel="FULL" StatementSubTreeCost="30.4422" 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] = sS |
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] = sSt |