Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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="1" StatementEstRows="1" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="TimeOut" StatementSubTreeCost="0.96327" StatementText="select t.title, count(res.id) fails from testruns as tr
join location loc on tr.location_id = loc.id
join testruntests trt on tr.id = trt.testruns_id
join tests t on trt.tests_id = t.id
join testresults res on trt.id = res.testruntests_id
where 
res.result = 'Fail'
--and tr.location_id = (select id from location where location = 'Derby')
and loc.location = 'Derby'
group by t.title
order by fails desc" StatementType="SELECT" QueryHash="0x95E0A245BA05ACB7" QueryPlanHash="0xA5FE8684826A0EF9" RetrievedFromCache="true">
- <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
- <QueryPlan DegreeOfParallelism="1" MemoryGrant="2176" CachedPlanSize="80" CompileTime="33" CompileCPU="33" CompileMemory="1168">
- <MemoryGrantInfo SerialRequiredMemory="2048" SerialDesiredMemory="2176" RequiredMemory="2048" DesiredMemory="2176" RequestedMemory="2176" GrantWaitTime="0" GrantedMemory="2176" MaxUsedMemory="1664" />
- <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="209703" EstimatedPagesCached="52425" EstimatedAvailableDegreeOfParallelism="2" />
- <RelOp AvgRowSize="46" EstimateCPU="0.000100046" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Sort" NodeId="0" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.96327">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="title" />
- <ColumnReference Column="Expr1010" />
- </OutputList>
- <MemoryFractions Input="0.5" Output="1" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="252" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Sort Distinct="false">
- <OrderBy>
- <OrderByColumn Ascending="false">
- <ColumnReference Column="Expr1010" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="46" EstimateCPU="1.1E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="1" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.951909">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="title" />
- <ColumnReference Column="Expr1010" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1010" />
- <ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr1013],0)">
- <Convert DataType="int" Style="0" Implicit="true">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1013" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="46" EstimateCPU="1.1E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Aggregate" NodeId="2" Parallel="false" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="0.951909">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="title" />
- <ColumnReference Column="Expr1013" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="252" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <StreamAggregate>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1013" />
- <ScalarOperator ScalarString="Count(*)">
- <Aggregate AggType="countstar" Distinct="false" />
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <GroupBy>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="title" />
- </GroupBy>
- <RelOp AvgRowSize="42" EstimateCPU="0.000100042" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Sort" NodeId="3" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.951908">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="title" />
- </OutputList>
- <Warnings>
- <SpillToTempDb SpillLevel="2" />
- </Warnings>
- <MemoryFractions Input="0.25" Output="0.5" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="249393" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Sort Distinct="false">
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="title" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="42" EstimateCPU="0.000572186" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Inner Join" NodeId="4" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.940547">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="title" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="249393" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="true" WithUnorderedPrefetch="true">
- <OuterReferences>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="id" />
- <ColumnReference Column="Expr1012" />
- </OuterReferences>
- <RelOp AvgRowSize="46" EstimateCPU="0.0229742" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="136.887" LogicalOp="Inner Join" NodeId="7" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="0.494906">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="id" />
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="title" />
- </OutputList>
- <Warnings>
- <SpillToTempDb SpillLevel="1" />
- </Warnings>
- <MemoryFractions Input="1" Output="0.5" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="2040577" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Hash>
- <DefinedValues />
- <HashKeysBuild>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="tests_id" />
- </HashKeysBuild>
- <HashKeysProbe>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="id" />
- </HashKeysProbe>
- <RelOp AvgRowSize="15" EstimateCPU="0.000572186" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="136.887" LogicalOp="Inner Join" NodeId="8" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.454465">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="id" />
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="tests_id" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="2040577" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="false" WithUnorderedPrefetch="true">
- <OuterReferences>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="id" />
- <ColumnReference Column="Expr1011" />
- </OuterReferences>
- <RelOp AvgRowSize="11" EstimateCPU="0.000572186" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="136.887" LogicalOp="Inner Join" NodeId="10" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0109033">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="id" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="2040577" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruns]" Alias="[tr]" Column="id" />
- </OuterReferences>
- <RelOp AvgRowSize="11" EstimateCPU="1.254E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Inner Join" NodeId="11" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00689858">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruns]" Alias="[tr]" Column="id" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="14276" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[location]" Alias="[loc]" Column="id" />
- </OuterReferences>
- <RelOp AvgRowSize="11" EstimateCPU="1.44E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3" LogicalOp="Filter" NodeId="12" Parallel="false" PhysicalOp="Filter" EstimatedTotalSubtreeCost="0.00328674">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[location]" Alias="[loc]" Column="id" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Filter StartupExpression="false">
- <RelOp AvgRowSize="83" EstimateCPU="0.0001603" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3" LogicalOp="Clustered Index Scan" NodeId="13" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0032853" TableCardinality="3">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[location]" Alias="[loc]" Column="id" />
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[location]" Alias="[loc]" Column="location" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[location]" Alias="[loc]" Column="id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[location]" Alias="[loc]" Column="location" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[prat_stats]" Schema="[dbo]" Table="[location]" Index="[PK__location__3213E83F15A2172E]" Alias="[loc]" IndexKind="Clustered" />
- </IndexScan>
- </RelOp>
- <Predicate>
- <ScalarOperator ScalarString="[prat_stats].[dbo].[location].[location] as [loc].[location]='Derby'">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[location]" Alias="[loc]" Column="location" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'Derby'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </Filter>
- </RelOp>
- <RelOp AvgRowSize="11" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="2" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="15" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0035993" TableCardinality="26244">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruns]" Alias="[tr]" Column="id" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="14276" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruns]" Alias="[tr]" Column="id" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[prat_stats]" Schema="[dbo]" Table="[testruns]" Index="[idx_testruns_location]" Alias="[tr]" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruns]" Alias="[tr]" Column="location_id" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[prat_stats].[dbo].[location].[id] as [loc].[id]">
- <Identifier>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[location]" Alias="[loc]" Column="id" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="11" EstimateCPU="0.000307575" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="136.887" LogicalOp="Index Seek" NodeId="16" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00343258" TableCardinality="2116600">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="id" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="2040577" ActualEndOfScans="14276" ActualExecutions="14276" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="id" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Index="[idx_testruns_id]" Alias="[trt]" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="testruns_id" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[prat_stats].[dbo].[testruns].[id] as [tr].[id]">
- <Identifier>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruns]" Alias="[tr]" Column="id" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="11" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="135.887" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="18" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.44299" TableCardinality="2116600">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="tests_id" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="2040577" ActualEndOfScans="0" ActualExecutions="2040577" />
- </RunTimeInformation>
- <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="tests_id" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Index="[testruntests_pk]" Alias="[trt]" TableReferenceId="-1" IndexKind="Clustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="id" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[prat_stats].[dbo].[testruntests].[id] as [trt].[id]">
- <Identifier>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="id" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="46" EstimateCPU="0.0010051" EstimateIO="0.0164583" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="771" LogicalOp="Clustered Index Scan" NodeId="22" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0174634" TableCardinality="771">
- <OutputList>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="id" />
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="title" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="771" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Alias="[t]" Column="title" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[prat_stats]" Schema="[dbo]" Table="[tests]" Index="[tests_pk]" Alias="[t]" IndexKind="Clustered" />
- </IndexScan>
- </RelOp>
- </Hash>
- </RelOp>
- <RelOp AvgRowSize="15" EstimateCPU="0.000158331" EstimateIO="0.003125" EstimateRebinds="135.887" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="24" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.444989" TableCardinality="2561580">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="249393" ActualEndOfScans="2040577" ActualExecutions="2040577" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues />
- <Object Database="[prat_stats]" Schema="[dbo]" Table="[testresults]" Index="[testresults_testruntests_idx]" Alias="[res]" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testresults]" Alias="[res]" Column="testruntests_id" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[prat_stats].[dbo].[testruntests].[id] as [trt].[id]">
- <Identifier>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testruntests]" Alias="[trt]" Column="id" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="[prat_stats].[dbo].[testresults].[result] as [res].[result]='Fail'">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[prat_stats]" Schema="[dbo]" Table="[testresults]" Alias="[res]" Column="result" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'Fail'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </Sort>
- </RelOp>
- </StreamAggregate>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </Sort>
- </RelOp>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- </BatchSequence>
- </ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement