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.522" Build="15.0.700.539" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
- <BatchSequence>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="3" StatementEstRows="2.95047" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="70" StatementSubTreeCost="0.103005" StatementText="SELECT 
 Object1.Column1 AS Column1, 
 Object1.Column2 AS Column2, 
 Object1.Column3 AS Column4, 
 Object1.Column5 AS Column3, 
 Object1.Column6 AS Column5, 
 Object1.Column7 AS Column7, 
 Object1.Column4 AS Column6, 
 Object1.Column8 AS Column8, 
 Object1.Column9 AS Column9, 
 Object1.Column10 AS Column10, 
 Object1.Column11 AS Column11, 
 Object1.Column12 AS Column12, 
 Object1.Column13 AS Column13, 
 Object1.Column14 AS Column14, 
 Object1.Column15 AS Column15, 
 Object1.Column16 AS Column16, 
 Object1.Column17 AS Column17, 
 Object1.Column18 AS Column18, 
 Object1.Column19 AS Column19, 
 Object1.Column20 AS Column20, 
 Object1.Column21 AS Column21, 
 Object1.Column22 AS Column22, 
 Object1.Column23 AS Column23, 
 Object1.Column24 AS Column24, 
 Object1.Column25 AS Column25
 FROM ( SELECT 
 Object2.Column2 AS Column2, 
 Object2.Column4 AS Column4, 
 Object2.Column8 AS Column8, 
 Object2.Column1 AS Column1, 
 Object2.Column17 AS Column17, 
 Object2.Column9 AS Column9, 
 Object2.Column19 AS Column19, 
 Object2.Column12 AS Column12, 
 Object2.Column18 AS Column18, 
 Object2.Column14 AS Column14, 
 Object2.Column25 AS Column25, 
 Object2.Column16 AS Column16, 
 Object2.Column15 AS Column15, 
 Object2.Column13 AS Column13, 
 Object3.Column4 AS Column3, 
 Object4.Column4 AS Column5, 
 Object5.Column4 AS Column6, 
 Object6.Column7 AS Column7, 
 Object7.Column10 AS Column10, 
 Object8.Column10 AS Column11, 
 Object9.Column4 AS Column20, 
 CASE WHEN (Variable1 = ?) THEN Object2.Column26 ELSE cast(? as decimal(18)) END AS Column21, 
 CASE WHEN (Variable2 = ?) THEN Object2.Column27 ELSE ? END AS Column22, 
 CASE WHEN (Variable3 = ?) THEN Object2.Column28 ELSE ? END AS Column23, 
 CASE WHEN (Variable4 = ?) THEN Object2.Column29 END AS Column24
 FROM Schema1.Object10 AS Object2
 INNER JOIN Schema1.Object11 AS Object3 ON Object2.Column30 = Object3.Column2
 INNER JOIN Schema1.Object12 AS Object4 ON Object2.Column31 = Object4.Column2
 LEFT OUTER JOIN Schema1.Object10 AS Object5 ON (Object2.Column32 = Object5.Column2) AND (Object5.Column33 = ?)
 LEFT OUTER JOIN Schema1.Object10 AS Object6 ON (Object2.Column34 = Object6.Column2) AND (Object6.Column33 = ?)
 LEFT OUTER JOIN Schema1.Object13 AS Object7 ON Object2.Column35 = Object7.Column2
 LEFT OUTER JOIN Schema1.Object13 AS Object8 ON Object2.Column36 = Object8.Column2
 LEFT OUTER JOIN Schema1.Object14 AS Object9 ON Object2.Column37 = Object9.Column2
 WHERE (Object2.Column33 = ?) AND (? = Object2.Column25)
 ) AS Object1
 ORDER BY Object1.Column14 DESC
 OFFSET ? ROWS FETCH NEXT ? ROWS ONLY" StatementType="SELECT" QueryHash="0x7730A721DA190416" QueryPlanHash="0xBAF256CF7C32349A" RetrievedFromCache="true" StatementSqlHandle="0x0900F8395D93571227DB9990447E71DFD6630000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="8" ParentObjectId="0" StatementParameterizationType="1" SecurityPolicyApplied="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="MaxDOPSetToOne" MemoryGrant="1656" CachedPlanSize="184" CompileTime="39" CompileCPU="39" CompileMemory="3272">
- <MemoryGrantInfo SerialRequiredMemory="1536" SerialDesiredMemory="1656" RequiredMemory="1536" DesiredMemory="1656" RequestedMemory="1656" GrantWaitTime="0" GrantedMemory="1656" MaxUsedMemory="864" MaxQueryMemory="552992" />
- <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="17616030" EstimatedPagesCached="1101001" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="2258952" />
- <WaitStats>
- <Wait WaitType="IO_COMPLETION" WaitTimeMs="1362" WaitCount="67" />
- </WaitStats>
- <QueryTimeStats CpuTime="44" ElapsedTime="1413" />
- <RelOp AvgRowSize="6902" EstimateCPU="2.95047E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2.95047" LogicalOp="Compute Scalar" NodeId="0" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.103005">
- <OutputList>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column2" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column18" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column8" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column1" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column17" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column9" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column19" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column12" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column14" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column16" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column15" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column13" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column25" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Alias="Object3" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object12" Alias="Object4" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object5" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object6" Column="Column7" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object13" Alias="Object7" Column="Column10" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object13" Alias="Object8" Column="Column10" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object14" Alias="Object9" Column="Column4" />
- <ColumnReference Column="Expr1016" />
- <ColumnReference Column="Expr1017" />
- <ColumnReference Column="Expr1018" />
- <ColumnReference Column="Expr1019" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1016" />
- <ScalarOperator ScalarString="ScalarString1">
- <IF>
- <Condition>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Column38" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="Value1" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Convert DataType="decimal" Precision="20" Scale="2" Style="0" Implicit="true">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column26" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <Const ConstValue="Value2" />
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1017" />
- <ScalarOperator ScalarString="ScalarString2">
- <IF>
- <Condition>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Column39" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="Value1" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column27" />
- </Identifier>
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <Const ConstValue="Value3" />
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1018" />
- <ScalarOperator ScalarString="ScalarString3">
- <IF>
- <Condition>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Column40" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="Value1" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column28" />
- </Identifier>
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <Const ConstValue="Value3" />
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1019" />
- <ScalarOperator ScalarString="ScalarString4">
- <IF>
- <Condition>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Column41" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="Value1" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column29" />
- </Identifier>
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <Const ConstValue="Value4" />
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="6898" EstimateCPU="2.95047E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2.95047" LogicalOp="Top" NodeId="1" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="0.103005">
- <OutputList>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column2" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column18" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column8" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column1" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column17" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column9" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column19" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column12" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column14" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column16" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column26" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column15" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column13" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column27" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column28" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column29" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column25" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Alias="Object3" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object12" Alias="Object4" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object5" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object6" Column="Column7" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object13" Alias="Object7" Column="Column10" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object13" Alias="Object8" Column="Column10" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object14" Alias="Object9" Column="Column4" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="100" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1413" ActualCPUms="43" />
- </RunTimeInformation>
- <Top RowCount="false" IsPercent="false" WithTies="false">
- <TopExpression>
- <ScalarOperator ScalarString="ScalarString5">
- <Const ConstValue="Value5" />
- </ScalarOperator>
- </TopExpression>
- <RelOp AvgRowSize="6898" EstimateCPU="1.2333E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2.95047" LogicalOp="Left Outer Join" NodeId="2" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.103005">
- <OutputList>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column2" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column18" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column8" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column1" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column17" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column9" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column19" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column12" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column14" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column16" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column26" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column15" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column13" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column27" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column28" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column29" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column25" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Alias="Object3" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object12" Alias="Object4" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object5" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object6" Column="Column7" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object13" Alias="Object7" Column="Column10" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object13" Alias="Object8" Column="Column10" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object14" Alias="Object9" Column="Column4" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="100" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1413" ActualCPUms="43" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column37" />
- </OuterReferences>
- <RelOp AvgRowSize="2888" EstimateCPU="1.2333E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2.95047" LogicalOp="Left Outer Join" NodeId="3" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0962312">
- <OutputList>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column2" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column18" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column8" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column1" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column17" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column9" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column19" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column12" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column14" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column16" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column26" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column15" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column13" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column37" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column27" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column28" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column29" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column25" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Alias="Object3" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object12" Alias="Object4" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object5" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object6" Column="Column7" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object13" Alias="Object7" Column="Column10" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object13" Alias="Object8" Column="Column10" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="100" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1412" ActualCPUms="43" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column36" />
- </OuterReferences>
- <RelOp AvgRowSize="2390" EstimateCPU="1.2333E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2.95047" LogicalOp="Left Outer Join" NodeId="4" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0892544">
- <OutputList>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column2" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column18" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column8" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column1" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column36" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column17" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column9" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column19" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column12" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column14" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column16" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column26" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column15" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column13" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column37" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column27" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column28" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column29" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column25" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Alias="Object3" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object12" Alias="Object4" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object5" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object6" Column="Column7" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object13" Alias="Object7" Column="Column10" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="100" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1412" ActualCPUms="43" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column35" />
- </OuterReferences>
- <RelOp AvgRowSize="1892" EstimateCPU="1.2333E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2.95047" LogicalOp="Left Outer Join" NodeId="5" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0822776">
- <OutputList>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column2" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column18" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column8" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column1" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column36" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column35" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column17" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column9" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column19" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column12" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column14" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column16" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column26" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column15" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column13" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column37" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column27" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column28" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column29" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column25" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Alias="Object3" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object12" Alias="Object4" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object5" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object6" Column="Column7" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="100" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1412" ActualCPUms="42" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column34" />
- </OuterReferences>
- <RelOp AvgRowSize="1876" EstimateCPU="1.2333E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2.95047" LogicalOp="Left Outer Join" NodeId="6" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0753035">
- <OutputList>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column2" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column18" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column8" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column1" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column34" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column36" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column35" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column17" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column9" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column19" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column12" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column14" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column16" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column26" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column15" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column13" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column37" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column27" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column28" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column29" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column25" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Alias="Object3" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object12" Alias="Object4" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object5" Column="Column4" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="100" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1411" ActualCPUms="42" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column32" />
- </OuterReferences>
- <RelOp AvgRowSize="1590" EstimateCPU="0.000108775" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2.95047" LogicalOp="Sort" NodeId="7" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.0683291">
- <OutputList>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column2" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column18" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column8" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column1" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column32" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column34" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column36" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column35" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column17" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column9" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column19" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column12" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column14" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column16" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column26" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column15" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column13" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column37" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column27" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column28" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column29" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column25" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Alias="Object3" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object12" Alias="Object4" Column="Column4" />
- </OutputList>
- <Warnings>
- <SpillToTempDb SpillLevel="2" SpilledThreadCount="1" />
- <SortSpillDetails GrantedMemoryKb="544" UsedMemoryKb="544" WritesToTempDb="346" ReadsFromTempDb="346" />
- </Warnings>
- <MemoryFractions Input="0.266667" Output="1" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="100" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1411" ActualCPUms="42" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="168" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="544" OutputMemoryGrant="248" UsedMemoryGrant="544" />
- </RunTimeInformation>
- <Sort Distinct="false">
- <OrderBy>
- <OrderByColumn Ascending="false">
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column14" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="1590" EstimateCPU="0.000112338" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2.95047" LogicalOp="Inner Join" NodeId="8" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.056959">
- <OutputList>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column2" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column18" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column8" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column1" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column32" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column34" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column36" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column35" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column17" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column9" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column19" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column12" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column14" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column16" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column26" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column15" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column13" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column37" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column27" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column28" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column29" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column25" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Alias="Object3" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object12" Alias="Object4" Column="Column4" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="3642" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="16" ActualCPUms="16" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column30" />
- </OuterReferences>
- <RelOp AvgRowSize="1568" EstimateCPU="0.0209956" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="26.875" LogicalOp="Inner Join" NodeId="9" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="0.0494728">
- <OutputList>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column2" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column30" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column18" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column8" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column1" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column32" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column34" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column36" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column35" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column17" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column9" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column19" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column12" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column14" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column16" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column26" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column15" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column13" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column37" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column27" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column28" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column29" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column25" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object12" Alias="Object4" Column="Column4" />
- </OutputList>
- <MemoryFractions Input="1" Output="0.733333" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="3642" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="4" ActualCPUms="4" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="1144" OutputMemoryGrant="1112" UsedMemoryGrant="320" />
- </RunTimeInformation>
- <Hash>
- <DefinedValues />
- <HashKeysBuild>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object12" Alias="Object4" Column="Column2" />
- </HashKeysBuild>
- <HashKeysProbe>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column31" />
- </HashKeysProbe>
- <ProbeResidual>
- <ScalarOperator ScalarString="ScalarString6">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column31" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object12" Alias="Object4" Column="Column2" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </ProbeResidual>
- <RelOp AvgRowSize="66" EstimateCPU="0.000165916" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="8.10526" EstimatedRowsRead="8.10526" LogicalOp="Index Seek" NodeId="10" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00329092" TableCardinality="157">
- <OutputList>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object12" Alias="Object4" Column="Column2" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object12" Alias="Object4" Column="Column4" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="17" ActualRowsRead="17" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object12" Alias="Object4" Column="Column2" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object12" Alias="Object4" Column="Column4" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="Database1" Schema="Schema1" Table="Object12" Index="Index1" Alias="Object4" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object12" Alias="Object4" Column="Column42" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="ScalarString7">
- <Convert DataType="nvarchar" Length="256" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="Function1">
- <ScalarOperator>
- <Const ConstValue="Value6" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="1543" EstimateCPU="0.000576724" EstimateIO="0.0246065" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="381.567" EstimatedRowsRead="381.567" LogicalOp="Index Seek" NodeId="11" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0251832" TableCardinality="37013">
- <OutputList>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column2" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column30" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column31" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column18" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column4" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column8" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column1" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column32" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column34" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column36" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column35" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column17" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column9" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column19" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column12" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column14" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column16" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column26" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column15" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column13" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column37" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column27" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column28" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column29" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column25" />
- </OutputList>
- <Warnings>
- <ColumnsWithNoStatistics>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column25" />
- </ColumnsWithNoStatistics>
- </Warnings>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="3642" ActualRowsRead="3642" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="2" ActualCPUms="2" ActualScans="1" ActualLogicalReads="304" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column2" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column30" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column31" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column18" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column4" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column8" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column1" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column32" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column34" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column36" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column35" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column17" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column9" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column19" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column12" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column14" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column16" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column26" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column15" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column13" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column37" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column27" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column28" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column29" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column25" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="Database1" Schema="Schema1" Table="Object10" Index="Index2" Alias="Object2" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column42" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column33" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column25" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="ScalarString7">
- <Convert DataType="nvarchar" Length="256" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="Function1">
- <ScalarOperator>
- <Const ConstValue="Value6" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- <ScalarOperator ScalarString="ScalarString8">
- <Const ConstValue="Value7" />
- </ScalarOperator>
- <ScalarOperator ScalarString="ScalarString9">
- <Const ConstValue="Value3" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </Hash>
- </RelOp>
- <RelOp AvgRowSize="47" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="22.3683" EstimateRewinds="3.50677" EstimatedExecutionMode="Row" EstimateRows="1" EstimatedRowsRead="1" LogicalOp="Index Seek" NodeId="12" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00737394" TableCardinality="32">
- <OutputList>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Alias="Object3" Column="Column4" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="3642" ActualRowsRead="3642" Batches="0" ActualEndOfScans="0" ActualExecutions="3642" ActualExecutionMode="Row" ActualElapsedms="9" ActualCPUms="9" ActualScans="0" ActualLogicalReads="7284" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Alias="Object3" Column="Column4" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="Database1" Schema="Schema1" Table="Object11" Index="Index3" Alias="Object3" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Alias="Object3" Column="Column2" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object11" Alias="Object3" Column="Column42" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="ScalarString10">
- <Identifier>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column30" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="ScalarString7">
- <Convert DataType="nvarchar" Length="256" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="Function1">
- <ScalarOperator>
- <Const ConstValue="Value6" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </Sort>
- </RelOp>
- <RelOp AvgRowSize="311" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1.95047" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimatedRowsRead="1" LogicalOp="Index Seek" NodeId="13" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00696205" TableCardinality="37013">
- <OutputList>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object5" Column="Column4" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="100" ActualRowsRead="100" Batches="0" ActualEndOfScans="0" ActualExecutions="100" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="300" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object5" Column="Column4" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="Database1" Schema="Schema1" Table="Object10" Index="Index4" Alias="Object5" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object5" Column="Column2" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object5" Column="Column42" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object5" Column="Column33" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="ScalarString11">
- <Identifier>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column32" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="ScalarString7">
- <Convert DataType="nvarchar" Length="256" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="Function1">
- <ScalarOperator>
- <Const ConstValue="Value6" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- <ScalarOperator ScalarString="ScalarString12">
- <Const ConstValue="Value8" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="41" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1.95047" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimatedRowsRead="1" LogicalOp="Index Seek" NodeId="14" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00696183" TableCardinality="37013">
- <OutputList>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object6" Column="Column7" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="100" ActualRowsRead="100" Batches="0" ActualEndOfScans="0" ActualExecutions="100" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="300" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object6" Column="Column7" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="Database1" Schema="Schema1" Table="Object10" Index="Index4" Alias="Object6" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object6" Column="Column2" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object6" Column="Column42" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object6" Column="Column33" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="ScalarString13">
- <Identifier>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column34" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="ScalarString7">
- <Convert DataType="nvarchar" Length="256" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="Function1">
- <ScalarOperator>
- <Const ConstValue="Value6" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- <ScalarOperator ScalarString="ScalarString14">
- <Const ConstValue="Value9" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="523" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1.95047" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimatedRowsRead="1" LogicalOp="Index Seek" NodeId="15" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00696442" TableCardinality="67598">
- <OutputList>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object13" Alias="Object7" Column="Column10" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="100" ActualRowsRead="100" Batches="0" ActualEndOfScans="0" ActualExecutions="100" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="300" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object13" Alias="Object7" Column="Column10" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="Database1" Schema="Schema1" Table="Object13" Index="Index5" Alias="Object7" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object13" Alias="Object7" Column="Column2" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object13" Alias="Object7" Column="Column42" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="ScalarString15">
- <Identifier>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column35" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="ScalarString7">
- <Convert DataType="nvarchar" Length="256" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="Function1">
- <ScalarOperator>
- <Const ConstValue="Value6" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="523" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1.95047" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimatedRowsRead="1" LogicalOp="Index Seek" NodeId="16" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00696449" TableCardinality="67598">
- <OutputList>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object13" Alias="Object8" Column="Column10" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="100" ActualRowsRead="100" Batches="0" ActualEndOfScans="0" ActualExecutions="100" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="300" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object13" Alias="Object8" Column="Column10" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="Database1" Schema="Schema1" Table="Object13" Index="Index5" Alias="Object8" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object13" Alias="Object8" Column="Column2" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object13" Alias="Object8" Column="Column42" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="ScalarString16">
- <Identifier>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column36" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="ScalarString7">
- <Convert DataType="nvarchar" Length="256" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="Function1">
- <ScalarOperator>
- <Const ConstValue="Value6" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="4035" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1.95047" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimatedRowsRead="1" LogicalOp="Index Seek" NodeId="17" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00676135" TableCardinality="1332">
- <OutputList>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object14" Alias="Object9" Column="Column4" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="2" ActualRowsRead="2" Batches="0" ActualEndOfScans="98" ActualExecutions="100" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="4" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object14" Alias="Object9" Column="Column4" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="Database1" Schema="Schema1" Table="Object14" Index="Index6" Alias="Object9" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object14" Alias="Object9" Column="Column2" />
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object14" Alias="Object9" Column="Column42" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="ScalarString17">
- <Identifier>
- <ColumnReference Database="Database1" Schema="Schema1" Table="Object10" Alias="Object2" Column="Column37" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="ScalarString7">
- <Convert DataType="nvarchar" Length="256" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="Function1">
- <ScalarOperator>
- <Const ConstValue="Value6" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </Top>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- <ParameterList>
- <ColumnReference Column="Column41" ParameterDataType="bit" ParameterCompiledValue="Value1" ParameterRuntimeValue="Value1" />
- <ColumnReference Column="Column40" ParameterDataType="bit" ParameterCompiledValue="Value1" ParameterRuntimeValue="Value1" />
- <ColumnReference Column="Column39" ParameterDataType="bit" ParameterCompiledValue="Value1" ParameterRuntimeValue="Value1" />
- <ColumnReference Column="Column38" ParameterDataType="bit" ParameterCompiledValue="Value1" ParameterRuntimeValue="Value1" />
- </ParameterList>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- </BatchSequence>
- </ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement