Created
October 9, 2015 03:57
-
-
Save anonymous/d6ac970b45eb75a88b99 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.9231.104" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan"> | |
<BatchSequence> | |
<Batch> | |
<Statements> | |
<StmtSimple StatementCompId="3" StatementEstRows="3.73938" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" StatementSubTreeCost="0.0507006" StatementText="WITH AggregateStepData_CTE AS
 (
 SELECT
 [UA].[UserId]
 , [UA].[DeviceId]
 , SUM(ISNULL([UA].[LatestSteps], 0)) AS [Steps]
 FROM [User].[UserStatus] [UA]
 INNER JOIN [User].[CurrentConnections] [M] ON [M].[Monitored] = [UA].[UserId] AND [M].[Monitor] = @UserId
 WHERE
 [M].[ShareSteps] = 1 -- Only use step data if we are allowed to see.
 AND
 CAST([UA].[ReportedLocalTime] AS DATE) = CAST(DATEADD(MINUTE, DATEPART(TZOFFSET, [UA].[ReportedLocalTime]), @Now) AS DATE) -- Aggregate the steps for today based on the device's time zone. 
 GROUP BY
 [UA].[UserId]
 , [UA].[DeviceId]
 )
 SELECT
 [UA].[UserId]
 , [UA].[ReportedLocalTime]
 , CASE WHEN [M].[ShareLocation] = 1 THEN [UA].[Latitude] ELSE NULL END AS [Latitude]
 , CASE WHEN [M].[ShareLocation] = 1 THEN [UA].[Longitude] ELSE NULL END AS [Longitude]
 , CASE WHEN [M].[ShareLocation] = 1 THEN [UA].[LocationAccuracy] ELSE NULL END AS [LocationAccuracy]
 , CASE WHEN [M].[ShareSteps] = 1 THEN ISNULL([SD].[Steps], 0) ELSE NULL END AS [Steps]
 , CASE WHEN [M].[ShareBattery] = 1 THEN [UA].[BatteryPercentage] ELSE NULL END AS [BatteryPercentage]
 , CASE WHEN [M].[ShareBattery] = 1 THEN [UA].[IsDraining] ELSE NULL END AS [IsDraining]
 , [PD].[DeviceName]
 FROM [User].[LatestUserStatus] [UA]
 INNER JOIN [User].[CurrentConnections] [M] WITH (NOEXPAND) ON [M].[Monitored] = [UA].[UserId] AND [M].[Monitor] = @UserId
 INNER JOIN [User].[PushDevice] [PD] ON [PD].[PushDeviceId] = [UA].[DeviceId]
 LEFT JOIN [AggregateStepData_CTE] [SD] ON [M].[Monitored] = [SD].[UserId] AND [SD].[DeviceId] = [UA].[DeviceId]
 ORDER BY 
 [UA].[UserId]
 , [UA].[ReportedLocalTime] DESC" StatementType="SELECT" QueryHash="0x92B895FCAC9ED428" QueryPlanHash="0x7A61179325A41AEA" 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="88" CompileTime="34" CompileCPU="33" CompileMemory="2264"> | |
<MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" /> | |
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1244765" EstimatedPagesCached="855776" EstimatedAvailableDegreeOfParallelism="5" /> | |
<RelOp AvgRowSize="173" EstimateCPU="3.73938E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3.73938" LogicalOp="Compute Scalar" NodeId="0" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0507006"> | |
<OutputList> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="UserId" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="ReportedLocalTime" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[PushDevice]" Alias="[PD]" Column="DeviceName" /> | |
<ColumnReference Column="Expr1011" /> | |
<ColumnReference Column="Expr1012" /> | |
<ColumnReference Column="Expr1013" /> | |
<ColumnReference Column="Expr1014" /> | |
<ColumnReference Column="Expr1015" /> | |
<ColumnReference Column="Expr1016" /> | |
</OutputList> | |
<ComputeScalar> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Column="Expr1011" /> | |
<ScalarOperator ScalarString="CASE WHEN [Ever_Production].[User].[CurrentConnections].[ShareLocation] as [M].[ShareLocation]=(1) THEN [Ever_Production].[User].[LatestUserStatus].[Latitude] as [UA].[Latitude] ELSE NULL END"> | |
<IF> | |
<Condition> | |
<ScalarOperator> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Alias="[M]" Column="ShareLocation" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Const ConstValue="(1)" /> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</Condition> | |
<Then> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="Latitude" /> | |
</Identifier> | |
</ScalarOperator> | |
</Then> | |
<Else> | |
<ScalarOperator> | |
<Const ConstValue="NULL" /> | |
</ScalarOperator> | |
</Else> | |
</IF> | |
</ScalarOperator> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Column="Expr1012" /> | |
<ScalarOperator ScalarString="CASE WHEN [Ever_Production].[User].[CurrentConnections].[ShareLocation] as [M].[ShareLocation]=(1) THEN [Ever_Production].[User].[LatestUserStatus].[Longitude] as [UA].[Longitude] ELSE NULL END"> | |
<IF> | |
<Condition> | |
<ScalarOperator> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Alias="[M]" Column="ShareLocation" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Const ConstValue="(1)" /> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</Condition> | |
<Then> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="Longitude" /> | |
</Identifier> | |
</ScalarOperator> | |
</Then> | |
<Else> | |
<ScalarOperator> | |
<Const ConstValue="NULL" /> | |
</ScalarOperator> | |
</Else> | |
</IF> | |
</ScalarOperator> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Column="Expr1013" /> | |
<ScalarOperator ScalarString="CASE WHEN [Ever_Production].[User].[CurrentConnections].[ShareLocation] as [M].[ShareLocation]=(1) THEN [Ever_Production].[User].[LatestUserStatus].[LocationAccuracy] as [UA].[LocationAccuracy] ELSE NULL END"> | |
<IF> | |
<Condition> | |
<ScalarOperator> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Alias="[M]" Column="ShareLocation" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Const ConstValue="(1)" /> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</Condition> | |
<Then> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="LocationAccuracy" /> | |
</Identifier> | |
</ScalarOperator> | |
</Then> | |
<Else> | |
<ScalarOperator> | |
<Const ConstValue="NULL" /> | |
</ScalarOperator> | |
</Else> | |
</IF> | |
</ScalarOperator> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Column="Expr1014" /> | |
<ScalarOperator ScalarString="CASE WHEN [Ever_Production].[User].[CurrentConnections].[ShareSteps] as [M].[ShareSteps]=(1) THEN isnull([Expr1010],(0)) ELSE NULL END"> | |
<IF> | |
<Condition> | |
<ScalarOperator> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Alias="[M]" Column="ShareSteps" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Const ConstValue="(1)" /> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</Condition> | |
<Then> | |
<ScalarOperator> | |
<Intrinsic FunctionName="isnull"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Column="Expr1010" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Const ConstValue="(0)" /> | |
</ScalarOperator> | |
</Intrinsic> | |
</ScalarOperator> | |
</Then> | |
<Else> | |
<ScalarOperator> | |
<Const ConstValue="NULL" /> | |
</ScalarOperator> | |
</Else> | |
</IF> | |
</ScalarOperator> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Column="Expr1015" /> | |
<ScalarOperator ScalarString="CASE WHEN [Ever_Production].[User].[CurrentConnections].[ShareBattery] as [M].[ShareBattery]=(1) THEN [Ever_Production].[User].[LatestUserStatus].[BatteryPercentage] as [UA].[BatteryPercentage] ELSE NULL END"> | |
<IF> | |
<Condition> | |
<ScalarOperator> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Alias="[M]" Column="ShareBattery" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Const ConstValue="(1)" /> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</Condition> | |
<Then> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="BatteryPercentage" /> | |
</Identifier> | |
</ScalarOperator> | |
</Then> | |
<Else> | |
<ScalarOperator> | |
<Const ConstValue="NULL" /> | |
</ScalarOperator> | |
</Else> | |
</IF> | |
</ScalarOperator> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Column="Expr1016" /> | |
<ScalarOperator ScalarString="CASE WHEN [Ever_Production].[User].[CurrentConnections].[ShareBattery] as [M].[ShareBattery]=(1) THEN [Ever_Production].[User].[LatestUserStatus].[IsDraining] as [UA].[IsDraining] ELSE NULL END"> | |
<IF> | |
<Condition> | |
<ScalarOperator> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Alias="[M]" Column="ShareBattery" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Const ConstValue="(1)" /> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</Condition> | |
<Then> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="IsDraining" /> | |
</Identifier> | |
</ScalarOperator> | |
</Then> | |
<Else> | |
<ScalarOperator> | |
<Const ConstValue="NULL" /> | |
</ScalarOperator> | |
</Else> | |
</IF> | |
</ScalarOperator> | |
</DefinedValue> | |
</DefinedValues> | |
<RelOp AvgRowSize="173" EstimateCPU="1.56306E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3.73938" LogicalOp="Left Outer Join" NodeId="1" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0507003"> | |
<OutputList> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="UserId" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="ReportedLocalTime" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="Latitude" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="Longitude" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="LocationAccuracy" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="BatteryPercentage" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="IsDraining" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Alias="[M]" Column="ShareBattery" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Alias="[M]" Column="ShareLocation" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Alias="[M]" Column="ShareSteps" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[PushDevice]" Alias="[PD]" Column="DeviceName" /> | |
<ColumnReference Column="Expr1010" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="9" ActualEndOfScans="1" ActualExecutions="1" /> | |
</RunTimeInformation> | |
<NestedLoops Optimized="false"> | |
<OuterReferences> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="DeviceId" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Alias="[M]" Column="Monitored" /> | |
</OuterReferences> | |
<RelOp AvgRowSize="177" EstimateCPU="1.56306E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3.73938" LogicalOp="Inner Join" NodeId="2" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0178242"> | |
<OutputList> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="UserId" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="DeviceId" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="ReportedLocalTime" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="Latitude" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="Longitude" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="LocationAccuracy" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="BatteryPercentage" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="IsDraining" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Alias="[M]" Column="Monitored" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Alias="[M]" Column="ShareBattery" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Alias="[M]" Column="ShareLocation" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Alias="[M]" Column="ShareSteps" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[PushDevice]" Alias="[PD]" Column="DeviceName" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="9" ActualEndOfScans="1" ActualExecutions="1" /> | |
</RunTimeInformation> | |
<NestedLoops Optimized="false"> | |
<OuterReferences> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="DeviceId" /> | |
</OuterReferences> | |
<RelOp AvgRowSize="45" EstimateCPU="1.56306E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3.73938" LogicalOp="Inner Join" NodeId="3" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00955854"> | |
<OutputList> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="UserId" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="DeviceId" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="ReportedLocalTime" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="Latitude" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="Longitude" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="LocationAccuracy" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="BatteryPercentage" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="IsDraining" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Alias="[M]" Column="Monitored" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Alias="[M]" Column="ShareBattery" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Alias="[M]" Column="ShareLocation" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Alias="[M]" Column="ShareSteps" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="9" ActualEndOfScans="1" ActualExecutions="1" /> | |
</RunTimeInformation> | |
<NestedLoops Optimized="false"> | |
<OuterReferences> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Alias="[M]" Column="Monitored" /> | |
</OuterReferences> | |
<RelOp AvgRowSize="12" EstimateCPU="0.000160672" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3.33784" LogicalOp="Clustered Index Seek" NodeId="4" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00328567" TableCardinality="494"> | |
<OutputList> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Alias="[M]" Column="Monitored" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Alias="[M]" Column="ShareBattery" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Alias="[M]" Column="ShareLocation" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Alias="[M]" Column="ShareSteps" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="4" ActualEndOfScans="1" ActualExecutions="1" /> | |
</RunTimeInformation> | |
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="true" Storage="RowStore"> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Alias="[M]" Column="Monitored" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Alias="[M]" Column="ShareBattery" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Alias="[M]" Column="ShareLocation" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Alias="[M]" Column="ShareSteps" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Index="[IDX_User_CurrentConnections_Monitor_Monitored]" Alias="[M]" IndexKind="ViewClustered" Storage="RowStore" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Alias="[M]" Column="Monitor" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="[@userid]"> | |
<Identifier> | |
<ColumnReference Column="@userid" /> | |
</Identifier> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
</IndexScan> | |
</RelOp> | |
<RelOp AvgRowSize="40" EstimateCPU="0.000158232" EstimateIO="0.003125" EstimateRebinds="2.33784" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.1203" LogicalOp="Index Seek" NodeId="5" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00625724" TableCardinality="298"> | |
<OutputList> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="UserId" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="DeviceId" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="ReportedLocalTime" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="Latitude" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="Longitude" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="LocationAccuracy" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="BatteryPercentage" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="IsDraining" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="9" ActualEndOfScans="4" ActualExecutions="4" /> | |
</RunTimeInformation> | |
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="UserId" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="DeviceId" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="ReportedLocalTime" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="Latitude" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="Longitude" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="LocationAccuracy" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="BatteryPercentage" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="IsDraining" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Index="[IDX_User_LatestUserStatus_UserId_ReportedLocalTime]" Alias="[UA]" IndexKind="NonClustered" Storage="RowStore" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="UserId" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="[Ever_Production].[User].[CurrentConnections].[Monitored] as [M].[Monitored]"> | |
<Identifier> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Alias="[M]" Column="Monitored" /> | |
</Identifier> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
</IndexScan> | |
</RelOp> | |
</NestedLoops> | |
</RelOp> | |
<RelOp AvgRowSize="139" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="2.73938" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="6" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00825005" TableCardinality="287"> | |
<OutputList> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[PushDevice]" Alias="[PD]" Column="DeviceName" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="9" ActualEndOfScans="0" ActualExecutions="9" /> | |
</RunTimeInformation> | |
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[PushDevice]" Alias="[PD]" Column="DeviceName" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[Ever_Production]" Schema="[User]" Table="[PushDevice]" Index="[PK__PushDevi__211E424FEFED7171]" Alias="[PD]" IndexKind="Clustered" Storage="RowStore" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[PushDevice]" Alias="[PD]" Column="PushDeviceId" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="[Ever_Production].[User].[LatestUserStatus].[DeviceId] as [UA].[DeviceId]"> | |
<Identifier> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="DeviceId" /> | |
</Identifier> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
</IndexScan> | |
</RelOp> | |
</NestedLoops> | |
</RelOp> | |
<RelOp AvgRowSize="11" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="2.73938" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="7" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0328604"> | |
<OutputList> | |
<ColumnReference Column="Expr1010" /> | |
</OutputList> | |
<ComputeScalar> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Column="Expr1010" /> | |
<ScalarOperator ScalarString="[Expr1007]"> | |
<Identifier> | |
<ColumnReference Column="Expr1007" /> | |
</Identifier> | |
</ScalarOperator> | |
</DefinedValue> | |
</DefinedValues> | |
<RelOp AvgRowSize="11" EstimateCPU="2.3766E-05" EstimateIO="0" EstimateRebinds="2.73938" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Aggregate" NodeId="8" Parallel="false" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="0.03286"> | |
<OutputList> | |
<ColumnReference Column="Expr1007" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="2" ActualEndOfScans="7" ActualExecutions="9" /> | |
</RunTimeInformation> | |
<StreamAggregate> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Column="Expr1007" /> | |
<ScalarOperator ScalarString="SUM([Expr1029])"> | |
<Aggregate AggType="SUM" Distinct="false"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Column="Expr1029" /> | |
</Identifier> | |
</ScalarOperator> | |
</Aggregate> | |
</ScalarOperator> | |
</DefinedValue> | |
</DefinedValues> | |
<RelOp AvgRowSize="11" EstimateCPU="0.000162087" EstimateIO="0" EstimateRebinds="2.73938" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="38.7767" LogicalOp="Inner Join" NodeId="9" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0327712"> | |
<OutputList> | |
<ColumnReference Column="Expr1029" /> | |
</OutputList> | |
<Warnings NoJoinPredicate="true" /> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="100" ActualEndOfScans="9" ActualExecutions="9" /> | |
</RunTimeInformation> | |
<NestedLoops Optimized="false"> | |
<RelOp AvgRowSize="9" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="2.73938" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.38701" LogicalOp="Inner Join" NodeId="11" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0165174"> | |
<OutputList /> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="9" ActualEndOfScans="2" ActualExecutions="9" /> | |
</RunTimeInformation> | |
<NestedLoops Optimized="false"> | |
<OuterReferences> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[Monitoring]" Alias="[M]" Column="MonitoringId" /> | |
</OuterReferences> | |
<RelOp AvgRowSize="17" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="2.73938" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Inner Join" NodeId="12" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0115946"> | |
<OutputList> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[Monitoring]" Alias="[M]" Column="MonitoringId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="9" ActualEndOfScans="2" ActualExecutions="9" /> | |
</RunTimeInformation> | |
<NestedLoops Optimized="false"> | |
<OuterReferences> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[Monitoring]" Alias="[M]" Column="MonitoringId" /> | |
</OuterReferences> | |
<RelOp AvgRowSize="12" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="2.73938" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="13" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0037162" TableCardinality="669"> | |
<OutputList> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[Monitoring]" Alias="[M]" Column="MonitoringId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="9" ActualEndOfScans="2" ActualExecutions="9" /> | |
</RunTimeInformation> | |
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[Monitoring]" Alias="[M]" Column="MonitoringId" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[Ever_Production]" Schema="[User]" Table="[Monitoring]" Index="[IDX_User_Monitoring_Monitor_Monitored_Unique_When_Active]" Filtered="true" Alias="[M]" IndexKind="NonClustered" Storage="RowStore" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[Monitoring]" Alias="[M]" Column="Monitor" /> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[Monitoring]" Alias="[M]" Column="Monitored" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="[@userid]"> | |
<Identifier> | |
<ColumnReference Column="@userid" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator ScalarString="[Ever_Production].[User].[CurrentConnections].[Monitored] as [M].[Monitored]"> | |
<Identifier> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Alias="[M]" Column="Monitored" /> | |
</Identifier> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
<Predicate> | |
<ScalarOperator ScalarString="[Ever_Production].[User].[Monitoring].[ShareSteps] as [M].[ShareSteps]=(1)"> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[Monitoring]" Alias="[M]" Column="ShareSteps" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Const ConstValue="(1)" /> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</Predicate> | |
</IndexScan> | |
</RelOp> | |
<RelOp AvgRowSize="13" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="2.73938" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="15" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00786101" TableCardinality="669"> | |
<OutputList /> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="9" ActualEndOfScans="0" ActualExecutions="9" /> | |
</RunTimeInformation> | |
<IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
<DefinedValues /> | |
<Object Database="[Ever_Production]" Schema="[User]" Table="[Monitoring]" Index="[PK__tmp_ms_x__CAC3C0577E9EB07A]" Alias="[M]" TableReferenceId="-1" IndexKind="Clustered" Storage="RowStore" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[Monitoring]" Alias="[M]" Column="MonitoringId" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="[Ever_Production].[User].[Monitoring].[MonitoringId] as [M].[MonitoringId]"> | |
<Identifier> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[Monitoring]" Alias="[M]" Column="MonitoringId" /> | |
</Identifier> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
<Predicate> | |
<ScalarOperator ScalarString="[Ever_Production].[User].[Monitoring].[ArchivedOn] as [M].[ArchivedOn] IS NULL"> | |
<Compare CompareOp="IS"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[Monitoring]" Alias="[M]" Column="ArchivedOn" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Const ConstValue="NULL" /> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</Predicate> | |
</IndexScan> | |
</RelOp> | |
</NestedLoops> | |
</RelOp> | |
<RelOp AvgRowSize="9" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="2.73938" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="17" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00490532" TableCardinality="494"> | |
<OutputList /> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="9" ActualEndOfScans="0" ActualExecutions="9" /> | |
</RunTimeInformation> | |
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="true" Storage="RowStore"> | |
<DefinedValues /> | |
<Object Database="[Ever_Production]" Schema="[User]" Table="[CurrentAlertThreshold]" Index="[IDX_User_CurrentAlertThreshold_MonitoringId]" IndexKind="ViewClustered" Storage="RowStore" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentAlertThreshold]" Column="MonitoringId" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="[Ever_Production].[User].[Monitoring].[MonitoringId] as [M].[MonitoringId]"> | |
<Identifier> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[Monitoring]" Alias="[M]" Column="MonitoringId" /> | |
</Identifier> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
<IndexedViewInfo> | |
<Object Database="[Ever_Production]" Schema="[User]" Table="[AlertThreshold]" Alias="AT" /> | |
</IndexedViewInfo> | |
</IndexScan> | |
</RelOp> | |
</NestedLoops> | |
</RelOp> | |
<RelOp AvgRowSize="11" EstimateCPU="2.7957E-06" EstimateIO="0" EstimateRebinds="2.73938" EstimateRewinds="1.44719" EstimatedExecutionMode="Row" EstimateRows="27.957" LogicalOp="Compute Scalar" NodeId="19" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0156477"> | |
<OutputList> | |
<ColumnReference Column="Expr1029" /> | |
</OutputList> | |
<ComputeScalar> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Column="Expr1029" /> | |
<ScalarOperator ScalarString="isnull([Ever_Production].[User].[UserStatus].[LatestSteps] as [UA].[LatestSteps],(0))"> | |
<Intrinsic FunctionName="isnull"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[UserStatus]" Alias="[UA]" Column="LatestSteps" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Const ConstValue="(0)" /> | |
</ScalarOperator> | |
</Intrinsic> | |
</ScalarOperator> | |
</DefinedValue> | |
</DefinedValues> | |
<RelOp AvgRowSize="23" EstimateCPU="0.000493194" EstimateIO="0.00386574" EstimateRebinds="2.73938" EstimateRewinds="1.44719" EstimatedExecutionMode="Row" EstimateRows="27.957" LogicalOp="Index Seek" NodeId="20" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0131286" TableCardinality="85247"> | |
<OutputList> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[UserStatus]" Alias="[UA]" Column="LatestSteps" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="100" ActualEndOfScans="9" ActualExecutions="9" /> | |
</RunTimeInformation> | |
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[UserStatus]" Alias="[UA]" Column="LatestSteps" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[Ever_Production]" Schema="[User]" Table="[UserStatus]" Index="[IDX_User_UserStatus_UserId_ReportedLocalTime]" Alias="[UA]" IndexKind="NonClustered" Storage="RowStore" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[UserStatus]" Alias="[UA]" Column="UserId" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="[Ever_Production].[User].[CurrentConnections].[Monitored] as [M].[Monitored]"> | |
<Identifier> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[CurrentConnections]" Alias="[M]" Column="Monitored" /> | |
</Identifier> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
<Predicate> | |
<ScalarOperator ScalarString="[Ever_Production].[User].[UserStatus].[DeviceId] as [UA].[DeviceId]=[Ever_Production].[User].[LatestUserStatus].[DeviceId] as [UA].[DeviceId] AND CONVERT(date,[Ever_Production].[User].[UserStatus].[ReportedLocalTime] as [UA].[ReportedLocalTime],0)=CONVERT(date,dateadd(minute,datepart(tzoffset,[Ever_Production].[User].[UserStatus].[ReportedLocalTime] as [UA].[ReportedLocalTime]),[@Now]),0)"> | |
<Logical Operation="AND"> | |
<ScalarOperator> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[UserStatus]" Alias="[UA]" Column="DeviceId" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[LatestUserStatus]" Alias="[UA]" Column="DeviceId" /> | |
</Identifier> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Convert DataType="date" Style="0" Implicit="false"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[UserStatus]" Alias="[UA]" Column="ReportedLocalTime" /> | |
</Identifier> | |
</ScalarOperator> | |
</Convert> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Convert DataType="date" Style="0" Implicit="false"> | |
<ScalarOperator> | |
<Intrinsic FunctionName="dateadd"> | |
<ScalarOperator> | |
<Const ConstValue="(7)" /> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Intrinsic FunctionName="datepart"> | |
<ScalarOperator> | |
<Const ConstValue="(14)" /> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Ever_Production]" Schema="[User]" Table="[UserStatus]" Alias="[UA]" Column="ReportedLocalTime" /> | |
</Identifier> | |
</ScalarOperator> | |
</Intrinsic> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Column="@Now" /> | |
</Identifier> | |
</ScalarOperator> | |
</Intrinsic> | |
</ScalarOperator> | |
</Convert> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</Logical> | |
</ScalarOperator> | |
</Predicate> | |
</IndexScan> | |
</RelOp> | |
</ComputeScalar> | |
</RelOp> | |
</NestedLoops> | |
</RelOp> | |
</StreamAggregate> | |
</RelOp> | |
</ComputeScalar> | |
</RelOp> | |
</NestedLoops> | |
</RelOp> | |
</ComputeScalar> | |
</RelOp> | |
<ParameterList> | |
<ColumnReference Column="@Now" ParameterRuntimeValue="'2015-10-09 03:49:19.0516827'" /> | |
<ColumnReference Column="@userid" ParameterRuntimeValue="(2)" /> | |
</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