Comments (5)
Can you get the query plan from Sql Server and attach it to the issue and also paste result of
select @@version
?
from linqpad.queryplanvisualizer.
Microsoft SQL Server 2016 (RTM) - 13.0.1601.5 (X64)
Apr 29 2016 23:23:58
Copyright (c) Microsoft Corporation
Express Edition (64-bit) on Windows 10 Pro N 6.3 <X64> (Build 15063: ) (Hypervisor)
and
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.5" Build="13.0.1601.5">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementText="SELECT 
 [Project2].[C1] AS [C1], 
 [Project2].[WorkItemId] AS [WorkItemId], 
 [Project2].[C2] AS [C2], 
 [Project2].[DurationMinutes] AS [DurationMinutes], 
 [Project2].[Id] AS [Id], 
 [Project2].[BillToDate] AS [BillToDate], 
 [Project2].[Description] AS [Description], 
 [Project2].[UserId] AS [UserId], 
 [Project2].[CategoryId] AS [CategoryId], 
 [Project2].[ProjectId] AS [ProjectId], 
 [Project2].[CreateDate] AS [CreateDate], 
 [Project2].[ModifiedDate] AS [ModifiedDate], 
 [Project2].[TimeEntryId] AS [TimeEntryId], 
 [Project2].[WorkItemId1] AS [WorkItemId1]
 FROM ( SELECT 
 [Distinct1].[WorkItemId] AS [WorkItemId], 
 1 AS [C1], 
 [Join2].[Id] AS [Id], 
 [Join2].[BillToDate] AS [BillToDate], 
 [Join2].[DurationMinutes] AS [DurationMinutes], 
 [Join2].[Description] AS [Description], 
 [Join2].[UserId] AS [UserId], 
 [Join2].[CategoryId] AS [CategoryId], 
 [Join2].[ProjectId] AS [ProjectId], 
 [Join2].[CreateDate] AS [CreateDate], 
 [Join2].[ModifiedDate] AS [ModifiedDate], 
 [Join2].[TimeEntryId] AS [TimeEntryId], 
 [Join2].[WorkItemId] AS [WorkItemId1], 
 CASE WHEN ([Join2].[DurationMinutes] IS NULL) THEN CAST(NULL AS int) ELSE 1 END AS [C2]
 FROM (SELECT DISTINCT 
 [Extent2].[WorkItemId] AS [WorkItemId]
 FROM [dbo].[TimeEntry] AS [Extent1]
 INNER JOIN [dbo].[TimeEntryWorkItemTag] AS [Extent2] ON [Extent1].[Id] = [Extent2].[TimeEntryId]
 WHERE N'43f25e47-3198-4f04-b4cc-691a29e2f939' = [Extent1].[UserId] ) AS [Distinct1]
 LEFT OUTER JOIN (SELECT [Extent3].[Id] AS [Id], [Extent3].[BillToDate] AS [BillToDate], [Extent3].[DurationMinutes] AS [DurationMinutes], [Extent3].[Description] AS [Description], [Extent3].[UserId] AS [UserId], [Extent3].[CategoryId] AS [CategoryId], [Extent3].[ProjectId] AS [ProjectId], [Extent3].[CreateDate] AS [CreateDate], [Extent3].[ModifiedDate] AS [ModifiedDate], [Extent4].[TimeEntryId] AS [TimeEntryId], [Extent4].[WorkItemId] AS [WorkItemId]
 FROM [dbo].[TimeEntry] AS [Extent3]
 INNER JOIN [dbo].[TimeEntryWorkItemTag] AS [Extent4] ON [Extent3].[Id] = [Extent4].[TimeEntryId] ) AS [Join2] ON (N'43f25e47-3198-4f04-b4cc-691a29e2f939' = [Join2].[UserId]) AND ([Distinct1].[WorkItemId] = [Join2].[WorkItemId])
 ) AS [Project2]
 ORDER BY [Project2].[WorkItemId] ASC, [Project2].[C2] ASC" StatementId="1" StatementCompId="2" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.0677074" StatementEstRows="5.51094" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x606CF1E0F39CEF51" QueryPlanHash="0xB92A31E66065E264" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="130">
<StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false">
</StatementSetOptions>
<QueryPlan DegreeOfParallelism="0" MemoryGrant="1024" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="72" CompileTime="6" CompileCPU="6" CompileMemory="896">
<MemoryGrantInfo SerialRequiredMemory="640" SerialDesiredMemory="736" RequiredMemory="640" DesiredMemory="736" RequestedMemory="1024" GrantWaitTime="0" GrantedMemory="1024" MaxUsedMemory="24">
</MemoryGrantInfo>
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="209703" EstimatedPagesCached="52425" EstimatedAvailableDegreeOfParallelism="2">
</OptimizerHardwareDependentProperties>
<RelOp NodeId="1" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="5.51094" EstimateIO="0.0112613" EstimateCPU="0.000125467" AvgRowSize="4298" EstimatedTotalSubtreeCost="0.0677074" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntryWorkItemTag]" Alias="[Extent2]" Column="WorkItemId">
</ColumnReference>
<ColumnReference Column="Expr1004">
</ColumnReference>
<ColumnReference Column="Expr1005">
</ColumnReference>
<ColumnReference Column="Expr1006">
</ColumnReference>
<ColumnReference Column="Expr1007">
</ColumnReference>
<ColumnReference Column="Expr1008">
</ColumnReference>
<ColumnReference Column="Expr1009">
</ColumnReference>
<ColumnReference Column="Expr1010">
</ColumnReference>
<ColumnReference Column="Expr1011">
</ColumnReference>
<ColumnReference Column="Expr1012">
</ColumnReference>
<ColumnReference Column="Expr1014">
</ColumnReference>
<ColumnReference Column="Expr1015">
</ColumnReference>
<ColumnReference Column="Expr1016">
</ColumnReference>
</OutputList>
<MemoryFractions Input="0.666667" Output="1">
</MemoryFractions>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="768" OutputMemoryGrant="512" UsedMemoryGrant="16">
</RunTimeCountersPerThread>
</RunTimeInformation>
<Sort Distinct="0">
<OrderBy>
<OrderByColumn Ascending="1">
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntryWorkItemTag]" Alias="[Extent2]" Column="WorkItemId">
</ColumnReference>
</OrderByColumn>
<OrderByColumn Ascending="1">
<ColumnReference Column="Expr1016">
</ColumnReference>
</OrderByColumn>
</OrderBy>
<RelOp NodeId="2" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="5.51094" EstimateIO="0" EstimateCPU="5.51094e-007" AvgRowSize="4298" EstimatedTotalSubtreeCost="0.0563207" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntryWorkItemTag]" Alias="[Extent2]" Column="WorkItemId">
</ColumnReference>
<ColumnReference Column="Expr1004">
</ColumnReference>
<ColumnReference Column="Expr1005">
</ColumnReference>
<ColumnReference Column="Expr1006">
</ColumnReference>
<ColumnReference Column="Expr1007">
</ColumnReference>
<ColumnReference Column="Expr1008">
</ColumnReference>
<ColumnReference Column="Expr1009">
</ColumnReference>
<ColumnReference Column="Expr1010">
</ColumnReference>
<ColumnReference Column="Expr1011">
</ColumnReference>
<ColumnReference Column="Expr1012">
</ColumnReference>
<ColumnReference Column="Expr1013">
</ColumnReference>
<ColumnReference Column="Expr1014">
</ColumnReference>
<ColumnReference Column="Expr1015">
</ColumnReference>
<ColumnReference Column="Expr1016">
</ColumnReference>
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1015">
</ColumnReference>
<ScalarOperator ScalarString="(1)">
<Const ConstValue="(1)">
</Const>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1016">
</ColumnReference>
<ScalarOperator ScalarString="CASE WHEN [Expr1006] IS NULL THEN NULL ELSE (1) END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1006">
</ColumnReference>
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL">
</Const>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="NULL">
</Const>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="(1)">
</Const>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="3" PhysicalOp="Nested Loops" LogicalOp="Left Outer Join" EstimateRows="5.51094" EstimateIO="0" EstimateCPU="2.29684e-005" AvgRowSize="4290" EstimatedTotalSubtreeCost="0.0563201" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntryWorkItemTag]" Alias="[Extent2]" Column="WorkItemId">
</ColumnReference>
<ColumnReference Column="Expr1004">
</ColumnReference>
<ColumnReference Column="Expr1005">
</ColumnReference>
<ColumnReference Column="Expr1006">
</ColumnReference>
<ColumnReference Column="Expr1007">
</ColumnReference>
<ColumnReference Column="Expr1008">
</ColumnReference>
<ColumnReference Column="Expr1009">
</ColumnReference>
<ColumnReference Column="Expr1010">
</ColumnReference>
<ColumnReference Column="Expr1011">
</ColumnReference>
<ColumnReference Column="Expr1012">
</ColumnReference>
<ColumnReference Column="Expr1013">
</ColumnReference>
<ColumnReference Column="Expr1014">
</ColumnReference>
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1">
</RunTimeCountersPerThread>
</RunTimeInformation>
<NestedLoops Optimized="0">
<OuterReferences>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntryWorkItemTag]" Alias="[Extent2]" Column="WorkItemId">
</ColumnReference>
</OuterReferences>
<RelOp NodeId="4" PhysicalOp="Sort" LogicalOp="Distinct Sort" EstimateRows="5.49484" EstimateIO="0.0112613" EstimateCPU="0.000122343" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0246167" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntryWorkItemTag]" Alias="[Extent2]" Column="WorkItemId">
</ColumnReference>
</OutputList>
<MemoryFractions Input="1" Output="0.333333">
</MemoryFractions>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="896" OutputMemoryGrant="256" UsedMemoryGrant="16">
</RunTimeCountersPerThread>
</RunTimeInformation>
<Sort Distinct="1">
<OrderBy>
<OrderByColumn Ascending="1">
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntryWorkItemTag]" Alias="[Extent2]" Column="WorkItemId">
</ColumnReference>
</OrderByColumn>
</OrderBy>
<RelOp NodeId="5" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="5.69884" EstimateIO="0" EstimateCPU="2.38212e-005" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0132331" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntryWorkItemTag]" Alias="[Extent2]" Column="WorkItemId">
</ColumnReference>
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1">
</RunTimeCountersPerThread>
</RunTimeInformation>
<NestedLoops Optimized="0">
<OuterReferences>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent1]" Column="Id">
</ColumnReference>
</OuterReferences>
<RelOp NodeId="6" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="5.47965" EstimateIO="0.003125" EstimateCPU="0.000163028" AvgRowSize="23" EstimatedTotalSubtreeCost="0.00328803" TableCardinality="404" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent1]" Column="Id">
</ColumnReference>
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="7" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="7" ActualEndOfScans="1" ActualExecutions="1">
</RunTimeCountersPerThread>
</RunTimeInformation>
<IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent1]" Column="Id">
</ColumnReference>
</DefinedValue>
</DefinedValues>
<Object Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Index="[IX_UserId]" Alias="[Extent1]" IndexKind="NonClustered" Storage="RowStore">
</Object>
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent1]" Column="UserId">
</ColumnReference>
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="N'43f25e47-3198-4f04-b4cc-691a29e2f939'">
<Const ConstValue="N'43f25e47-3198-4f04-b4cc-691a29e2f939'">
</Const>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
<RelOp NodeId="7" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1.04" EstimateIO="0.003125" EstimateCPU="0.000158144" AvgRowSize="23" EstimatedTotalSubtreeCost="0.00992127" TableCardinality="416" Parallel="0" EstimateRebinds="4.47965" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntryWorkItemTag]" Alias="[Extent2]" Column="WorkItemId">
</ColumnReference>
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="7" ActualLogicalReads="14" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="4" ActualEndOfScans="7" ActualExecutions="7">
</RunTimeCountersPerThread>
</RunTimeInformation>
<IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntryWorkItemTag]" Alias="[Extent2]" Column="WorkItemId">
</ColumnReference>
</DefinedValue>
</DefinedValues>
<Object Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntryWorkItemTag]" Index="[IX_TimeEntryId]" Alias="[Extent2]" IndexKind="NonClustered" Storage="RowStore">
</Object>
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntryWorkItemTag]" Alias="[Extent2]" Column="TimeEntryId">
</ColumnReference>
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[Meazure_demo].[dbo].[TimeEntry].[Id] as [Extent1].[Id]">
<Identifier>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent1]" Column="Id">
</ColumnReference>
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
</Sort>
</RelOp>
<RelOp NodeId="8" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="4274" EstimatedTotalSubtreeCost="0.0316804" Parallel="0" EstimateRebinds="4.49484" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Column="Expr1004">
</ColumnReference>
<ColumnReference Column="Expr1005">
</ColumnReference>
<ColumnReference Column="Expr1006">
</ColumnReference>
<ColumnReference Column="Expr1007">
</ColumnReference>
<ColumnReference Column="Expr1008">
</ColumnReference>
<ColumnReference Column="Expr1009">
</ColumnReference>
<ColumnReference Column="Expr1010">
</ColumnReference>
<ColumnReference Column="Expr1011">
</ColumnReference>
<ColumnReference Column="Expr1012">
</ColumnReference>
<ColumnReference Column="Expr1013">
</ColumnReference>
<ColumnReference Column="Expr1014">
</ColumnReference>
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1004">
</ColumnReference>
<ScalarOperator ScalarString="[Meazure_demo].[dbo].[TimeEntry].[Id] as [Extent3].[Id]">
<Identifier>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="Id">
</ColumnReference>
</Identifier>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1005">
</ColumnReference>
<ScalarOperator ScalarString="[Meazure_demo].[dbo].[TimeEntry].[BillToDate] as [Extent3].[BillToDate]">
<Identifier>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="BillToDate">
</ColumnReference>
</Identifier>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1006">
</ColumnReference>
<ScalarOperator ScalarString="[Meazure_demo].[dbo].[TimeEntry].[DurationMinutes] as [Extent3].[DurationMinutes]">
<Identifier>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="DurationMinutes">
</ColumnReference>
</Identifier>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1007">
</ColumnReference>
<ScalarOperator ScalarString="[Meazure_demo].[dbo].[TimeEntry].[Description] as [Extent3].[Description]">
<Identifier>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="Description">
</ColumnReference>
</Identifier>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1008">
</ColumnReference>
<ScalarOperator ScalarString="[Meazure_demo].[dbo].[TimeEntry].[UserId] as [Extent3].[UserId]">
<Identifier>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="UserId">
</ColumnReference>
</Identifier>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1009">
</ColumnReference>
<ScalarOperator ScalarString="[Meazure_demo].[dbo].[TimeEntry].[CategoryId] as [Extent3].[CategoryId]">
<Identifier>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="CategoryId">
</ColumnReference>
</Identifier>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1010">
</ColumnReference>
<ScalarOperator ScalarString="[Meazure_demo].[dbo].[TimeEntry].[ProjectId] as [Extent3].[ProjectId]">
<Identifier>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="ProjectId">
</ColumnReference>
</Identifier>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1011">
</ColumnReference>
<ScalarOperator ScalarString="[Meazure_demo].[dbo].[TimeEntry].[CreateDate] as [Extent3].[CreateDate]">
<Identifier>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="CreateDate">
</ColumnReference>
</Identifier>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1012">
</ColumnReference>
<ScalarOperator ScalarString="[Meazure_demo].[dbo].[TimeEntry].[ModifiedDate] as [Extent3].[ModifiedDate]">
<Identifier>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="ModifiedDate">
</ColumnReference>
</Identifier>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="9" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="4274" EstimatedTotalSubtreeCost="0.0316799" Parallel="0" EstimateRebinds="4.49484" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="Id">
</ColumnReference>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="BillToDate">
</ColumnReference>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="DurationMinutes">
</ColumnReference>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="Description">
</ColumnReference>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="UserId">
</ColumnReference>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="CategoryId">
</ColumnReference>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="ProjectId">
</ColumnReference>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="CreateDate">
</ColumnReference>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="ModifiedDate">
</ColumnReference>
<ColumnReference Column="Expr1013">
</ColumnReference>
<ColumnReference Column="Expr1014">
</ColumnReference>
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="4" ActualExecutions="4">
</RunTimeCountersPerThread>
</RunTimeInformation>
<NestedLoops Optimized="0">
<OuterReferences>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="Id">
</ColumnReference>
</OuterReferences>
<RelOp NodeId="10" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="2.48411e-005" AvgRowSize="187" EstimatedTotalSubtreeCost="0.0181216" Parallel="0" EstimateRebinds="4.49484" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="Id">
</ColumnReference>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="UserId">
</ColumnReference>
<ColumnReference Column="Expr1013">
</ColumnReference>
<ColumnReference Column="Expr1014">
</ColumnReference>
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="4" ActualExecutions="4">
</RunTimeCountersPerThread>
</RunTimeInformation>
<NestedLoops Optimized="0">
<OuterReferences>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntryWorkItemTag]" Alias="[Extent4]" Column="TimeEntryId">
</ColumnReference>
</OuterReferences>
<RelOp NodeId="11" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="5.94286" EstimateIO="0" EstimateCPU="4.16e-005" AvgRowSize="71" EstimatedTotalSubtreeCost="0.00860009" Parallel="0" EstimateRebinds="0" EstimateRewinds="4.49484" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntryWorkItemTag]" Alias="[Extent4]" Column="TimeEntryId">
</ColumnReference>
<ColumnReference Column="Expr1013">
</ColumnReference>
<ColumnReference Column="Expr1014">
</ColumnReference>
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1013">
</ColumnReference>
<ScalarOperator ScalarString="[Meazure_demo].[dbo].[TimeEntryWorkItemTag].[TimeEntryId] as [Extent4].[TimeEntryId]">
<Identifier>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntryWorkItemTag]" Alias="[Extent4]" Column="TimeEntryId">
</ColumnReference>
</Identifier>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1014">
</ColumnReference>
<ScalarOperator ScalarString="[Meazure_demo].[dbo].[TimeEntryWorkItemTag].[WorkItemId] as [Extent4].[WorkItemId]">
<Identifier>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntryWorkItemTag]" Alias="[Extent4]" Column="WorkItemId">
</ColumnReference>
</Identifier>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="12" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="5.94286" EstimateIO="0.00542572" EstimateCPU="0.0005361" AvgRowSize="39" EstimatedTotalSubtreeCost="0.0083715" TableCardinality="416" Parallel="0" EstimateRebinds="0" EstimateRewinds="4.49484" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntryWorkItemTag]" Alias="[Extent4]" Column="TimeEntryId">
</ColumnReference>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntryWorkItemTag]" Alias="[Extent4]" Column="WorkItemId">
</ColumnReference>
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="43" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="24" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="1664" ActualEndOfScans="4" ActualExecutions="4">
</RunTimeCountersPerThread>
</RunTimeInformation>
<IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntryWorkItemTag]" Alias="[Extent4]" Column="TimeEntryId">
</ColumnReference>
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntryWorkItemTag]" Alias="[Extent4]" Column="WorkItemId">
</ColumnReference>
</DefinedValue>
</DefinedValues>
<Object Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntryWorkItemTag]" Index="[PK_dbo.TimeEntryWorkItemTag]" Alias="[Extent4]" IndexKind="Clustered" Storage="RowStore">
</Object>
<Predicate>
<ScalarOperator ScalarString="[Meazure_demo].[dbo].[TimeEntryWorkItemTag].[WorkItemId] as [Extent4].[WorkItemId]=[Meazure_demo].[dbo].[TimeEntryWorkItemTag].[WorkItemId] as [Extent2].[WorkItemId]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntryWorkItemTag]" Alias="[Extent4]" Column="WorkItemId">
</ColumnReference>
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntryWorkItemTag]" Alias="[Extent2]" Column="WorkItemId">
</ColumnReference>
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</ComputeScalar>
</RelOp>
<RelOp NodeId="18" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="155" EstimatedTotalSubtreeCost="0.00828776" TableCardinality="404" Parallel="0" EstimateRebinds="31.655" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="Id">
</ColumnReference>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="UserId">
</ColumnReference>
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="86" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="4" ActualEndOfScans="39" ActualExecutions="43">
</RunTimeCountersPerThread>
</RunTimeInformation>
<IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="Id">
</ColumnReference>
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="UserId">
</ColumnReference>
</DefinedValue>
</DefinedValues>
<Object Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Index="[IX_UserId]" Alias="[Extent3]" IndexKind="NonClustered" Storage="RowStore">
</Object>
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="UserId">
</ColumnReference>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="Id">
</ColumnReference>
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="N'43f25e47-3198-4f04-b4cc-691a29e2f939'">
<Const ConstValue="N'43f25e47-3198-4f04-b4cc-691a29e2f939'">
</Const>
</ScalarOperator>
<ScalarOperator ScalarString="[Meazure_demo].[dbo].[TimeEntryWorkItemTag].[TimeEntryId] as [Extent4].[TimeEntryId]">
<Identifier>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntryWorkItemTag]" Alias="[Extent4]" Column="TimeEntryId">
</ColumnReference>
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp NodeId="20" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="4095" EstimatedTotalSubtreeCost="0.0135353" TableCardinality="404" Parallel="0" EstimateRebinds="4.49484" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="BillToDate">
</ColumnReference>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="DurationMinutes">
</ColumnReference>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="Description">
</ColumnReference>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="CategoryId">
</ColumnReference>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="ProjectId">
</ColumnReference>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="CreateDate">
</ColumnReference>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="ModifiedDate">
</ColumnReference>
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="8" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="4" ActualEndOfScans="0" ActualExecutions="4">
</RunTimeCountersPerThread>
</RunTimeInformation>
<IndexScan Lookup="1" Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="BillToDate">
</ColumnReference>
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="DurationMinutes">
</ColumnReference>
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="Description">
</ColumnReference>
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="CategoryId">
</ColumnReference>
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="ProjectId">
</ColumnReference>
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="CreateDate">
</ColumnReference>
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="ModifiedDate">
</ColumnReference>
</DefinedValue>
</DefinedValues>
<Object Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Index="[PK_dbo.TimeEntry]" Alias="[Extent3]" TableReferenceId="-1" IndexKind="Clustered" Storage="RowStore">
</Object>
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="Id">
</ColumnReference>
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[Meazure_demo].[dbo].[TimeEntry].[Id] as [Extent3].[Id]">
<Identifier>
<ColumnReference Database="[Meazure_demo]" Schema="[dbo]" Table="[TimeEntry]" Alias="[Extent3]" Column="Id">
</ColumnReference>
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
</ComputeScalar>
</RelOp>
</NestedLoops>
</RelOp>
</ComputeScalar>
</RelOp>
</Sort>
</RelOp>
</QueryPlan>
</StmtSimple>
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>
from linqpad.queryplanvisualizer.
@togakangaroo Can you check if the latest release (1.2.1) fixes this issue?
from linqpad.queryplanvisualizer.
I can't sorry, I no longer have any part of that environment but thank you for looking at it still
from linqpad.queryplanvisualizer.
OK, I will close it in that case.
from linqpad.queryplanvisualizer.
Related Issues (20)
- v1.1 requires EF HOT 2
- v1.1 doesn't like NoLock HOT 2
- Currently does not display "Seek Predicates" at all HOT 5
- Query plan html transformation failing: "The 'MaxQueryMemory' attribute is not declared." HOT 1
- xmlschemavalidationexception HOT 1
- Query Plan Output tab does not respect windows scaling HOT 2
- Can the README explain a bit better how to add it via nuget? HOT 3
- Query Execution Plan Not Showing in v5.22.02 HOT 4
- QueryPlan har invalid child element 'TraceFlags' HOT 4
- Make it compatible with LINQPad 6 (.NET Core version) HOT 3
- Is the visual (graphic) output only available for SQL Server, not PostgreSQL? HOT 11
- Use WebView2 to show Postgres query plan in LINQPad HOT 1
- mysql support
- Cannot load WebView2 assembly HOT 8
- Raw sql support HOT 1
- Multiple requests for query plans should provide multiple visualizers HOT 1
- DumpPlan Hangup LINQPad when the query is the first query and C# Expression is used. HOT 2
- EF 5 is not supported HOT 9
- SQL instances without SHOWPLAN permission granted cause exception to be passed. HOT 9
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from linqpad.queryplanvisualizer.