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.481" Build="14.0.3045.24" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
- <BatchSequence>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="0" StatementEstRows="1" StatementId="2" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="140" StatementSubTreeCost="0.00344656" StatementText="SELECT SUM([Amount]) FROM [dbo].[CompanyName$Detailed Cust_ Ledg_ Entry] WHERE [Customer No_]=@1" StatementType="SELECT" QueryHash="0xE2CFCD8D27E25A62" QueryPlanHash="0x436FC48D9368D473" RetrievedFromCache="false" SecurityPolicyApplied="false">
- <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" CachedPlanSize="40" CompileTime="13" CompileCPU="13" CompileMemory="1160">
- <MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" />
- <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1363148" EstimatedPagesCached="340787" EstimatedAvailableDegreeOfParallelism="2" MaxCompileMemory="34964752" />
- <OptimizerStatsUsage>
- <StatisticsInfo Database="[DBName]" Schema="[dbo]" Table="[CompanyName$Detailed Cust_ Ledg_ Entry]" Statistics="[$8]" ModificationCount="0" SamplingPercent="100" LastUpdate="2020-04-23T15:59:37.42" />
- <StatisticsInfo Database="[DBName]" Schema="[dbo]" Table="[CompanyName$Detailed Cust_ Ledg_ Entry]" Statistics="[$1]" ModificationCount="0" SamplingPercent="100" LastUpdate="2020-04-23T15:59:20.03" />
- <StatisticsInfo Database="[DBName]" Schema="[dbo]" Table="[CompanyName$Detailed Cust_ Ledg_ Entry$VSIFT$10]" Statistics="[_WA_Sys_00000003_3575474C]" ModificationCount="93" SamplingPercent="5.07591" LastUpdate="2020-02-08T02:37:40.28" />
- <StatisticsInfo Database="[DBName]" Schema="[dbo]" Table="[CompanyName$Detailed Cust_ Ledg_ Entry$VSIFT$5]" Statistics="[_WA_Sys_00000002_34812313]" ModificationCount="48167" SamplingPercent="3.8518" LastUpdate="2020-02-08T02:37:41.26" />
- <StatisticsInfo Database="[DBName]" Schema="[dbo]" Table="[CompanyName$Detailed Cust_ Ledg_ Entry]" Statistics="[$11]" ModificationCount="0" SamplingPercent="100" LastUpdate="2020-04-23T15:59:53.69" />
- <StatisticsInfo Database="[DBName]" Schema="[dbo]" Table="[CompanyName$Detailed Cust_ Ledg_ Entry]" Statistics="[$6]" ModificationCount="0" SamplingPercent="100" LastUpdate="2020-04-23T15:59:32.5" />
- <StatisticsInfo Database="[DBName]" Schema="[dbo]" Table="[CompanyName$Detailed Cust_ Ledg_ Entry]" Statistics="[$10]" ModificationCount="0" SamplingPercent="100" LastUpdate="2020-04-23T15:59:49.76" />
- <StatisticsInfo Database="[DBName]" Schema="[dbo]" Table="[CompanyName$Detailed Cust_ Ledg_ Entry$VSIFT$5]" Statistics="[_WA_Sys_00000003_34812313]" ModificationCount="48167" SamplingPercent="3.8518" LastUpdate="2020-02-08T02:37:41.4" />
- <StatisticsInfo Database="[DBName]" Schema="[dbo]" Table="[CompanyName$Detailed Cust_ Ledg_ Entry$VSIFT$5]" Statistics="[_WA_Sys_00000005_34812313]" ModificationCount="48167" SamplingPercent="3.8518" LastUpdate="2020-02-08T02:37:41.61" />
- <StatisticsInfo Database="[DBName]" Schema="[dbo]" Table="[CompanyName$Detailed Cust_ Ledg_ Entry]" Statistics="[$4]" ModificationCount="0" SamplingPercent="100" LastUpdate="2020-04-23T15:59:25.1" />
- <StatisticsInfo Database="[DBName]" Schema="[dbo]" Table="[CompanyName$Detailed Cust_ Ledg_ Entry$VSIFT$5]" Statistics="[VSIFTIDX]" ModificationCount="48167" SamplingPercent="3.8518" LastUpdate="2020-02-08T02:37:41.16" />
- <StatisticsInfo Database="[DBName]" Schema="[dbo]" Table="[CompanyName$Detailed Cust_ Ledg_ Entry$VSIFT$5]" Statistics="[_WA_Sys_00000004_34812313]" ModificationCount="48167" SamplingPercent="3.8518" LastUpdate="2020-02-08T02:37:41.5" />
- <StatisticsInfo Database="[DBName]" Schema="[dbo]" Table="[CompanyName$Detailed Cust_ Ledg_ Entry]" Statistics="[$9]" ModificationCount="0" SamplingPercent="100" LastUpdate="2020-04-23T15:59:45.83" />
- <StatisticsInfo Database="[DBName]" Schema="[dbo]" Table="[CompanyName$Detailed Cust_ Ledg_ Entry]" Statistics="[$7]" ModificationCount="0" SamplingPercent="100" LastUpdate="2020-04-23T15:59:34.3" />
- <StatisticsInfo Database="[DBName]" Schema="[dbo]" Table="[CompanyName$Detailed Cust_ Ledg_ Entry$VSIFT$10]" Statistics="[_WA_Sys_00000002_3575474C]" ModificationCount="93" SamplingPercent="5.07591" LastUpdate="2020-02-08T02:37:40.17" />
- <StatisticsInfo Database="[DBName]" Schema="[dbo]" Table="[CompanyName$Detailed Cust_ Ledg_ Entry$VSIFT$10]" Statistics="[VSIFTIDX]" ModificationCount="93" SamplingPercent="5.07591" LastUpdate="2020-02-08T02:37:39.8" />
- <StatisticsInfo Database="[DBName]" Schema="[dbo]" Table="[CompanyName$Detailed Cust_ Ledg_ Entry$VSIFT$5]" Statistics="[_WA_Sys_00000006_34812313]" ModificationCount="48167" SamplingPercent="3.8518" LastUpdate="2020-02-08T02:37:41.73" />
- <StatisticsInfo Database="[DBName]" Schema="[dbo]" Table="[CompanyName$Detailed Cust_ Ledg_ Entry]" Statistics="[$5]" ModificationCount="0" SamplingPercent="100" LastUpdate="2020-04-23T15:59:29.35" />
- </OptimizerStatsUsage>
- <TraceFlags IsCompileTime="true">
- <TraceFlag Value="3226" Scope="Global" />
- <TraceFlag Value="4199" Scope="Global" />
- </TraceFlags>
- <TraceFlags IsCompileTime="false">
- <TraceFlag Value="3226" Scope="Global" />
- <TraceFlag Value="4199" Scope="Global" />
- </TraceFlags>
- <QueryTimeStats CpuTime="1" ElapsedTime="1" />
- <RelOp AvgRowSize="24" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="1" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.00344656">
- <OutputList>
- <ColumnReference Column="Expr1002" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1002" />
- <ScalarOperator ScalarString="CASE WHEN [globalagg1019]=(0) THEN NULL ELSE [globalagg1021] END">
- <IF>
- <Condition>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="globalagg1019" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(0)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="globalagg1021" />
- </Identifier>
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="32" EstimateCPU="1.7E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Aggregate" NodeId="2" Parallel="false" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="0.00344646">
- <OutputList>
- <ColumnReference Column="globalagg1019" />
- <ColumnReference Column="globalagg1021" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <StreamAggregate>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="globalagg1019" />
- <ScalarOperator ScalarString="SUM([partialagg1018])">
- <Aggregate AggType="SUM" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="partialagg1018" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="globalagg1021" />
- <ScalarOperator ScalarString="SUM([partialagg1020])">
- <Aggregate AggType="SUM" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="partialagg1020" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="32" EstimateCPU="5.28331E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2" LogicalOp="Aggregate" NodeId="3" Parallel="false" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="0.00344476">
- <OutputList>
- <ColumnReference Column="partialagg1018" />
- <ColumnReference Column="partialagg1020" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <StreamAggregate>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="partialagg1018" />
- <ScalarOperator ScalarString="SUM([DBName].[dbo].[CompanyName$Detailed Cust_ Ledg_ Entry$VSIFT$5].[$Cnt])">
- <Aggregate AggType="SUM" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[DBName]" Schema="[dbo]" Table="[CompanyName$Detailed Cust_ Ledg_ Entry$VSIFT$5]" Column="$Cnt" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="partialagg1020" />
- <ScalarOperator ScalarString="SUM([DBName].[dbo].[CompanyName$Detailed Cust_ Ledg_ Entry$VSIFT$5].[SUM$Amount])">
- <Aggregate AggType="SUM" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[DBName]" Schema="[dbo]" Table="[CompanyName$Detailed Cust_ Ledg_ Entry$VSIFT$5]" Column="SUM$Amount" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="32" EstimateCPU="0.000252027" EstimateIO="0.0031399" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="86.3885" EstimatedRowsRead="86.3885" LogicalOp="Clustered Index Seek" NodeId="5" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00339193" TableCardinality="3894240">
- <OutputList>
- <ColumnReference Database="[DBName]" Schema="[dbo]" Table="[CompanyName$Detailed Cust_ Ledg_ Entry$VSIFT$5]" Column="$Cnt" />
- <ColumnReference Database="[DBName]" Schema="[dbo]" Table="[CompanyName$Detailed Cust_ Ledg_ Entry$VSIFT$5]" Column="SUM$Amount" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="7" ActualRowsRead="7" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="5" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="true" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[DBName]" Schema="[dbo]" Table="[CompanyName$Detailed Cust_ Ledg_ Entry$VSIFT$5]" Column="$Cnt" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[DBName]" Schema="[dbo]" Table="[CompanyName$Detailed Cust_ Ledg_ Entry$VSIFT$5]" Column="SUM$Amount" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[DBName]" Schema="[dbo]" Table="[CompanyName$Detailed Cust_ Ledg_ Entry$VSIFT$5]" Index="[VSIFTIDX]" IndexKind="ViewClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[DBName]" Schema="[dbo]" Table="[CompanyName$Detailed Cust_ Ledg_ Entry$VSIFT$5]" Column="Customer No_" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="N'XYZ'">
- <Const ConstValue="N'XYZ'" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <IndexedViewInfo>
- <Object Database="[DBName]" Schema="[dbo]" Table="[CompanyName$Detailed Cust_ Ledg_ Entry]" />
- </IndexedViewInfo>
- </IndexScan>
- </RelOp>
- </StreamAggregate>
- </RelOp>
- </StreamAggregate>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- <ParameterList>
- <ColumnReference Column="@1" ParameterDataType="varchar(8000)" ParameterCompiledValue="'XYZ'" ParameterRuntimeValue="'XYZ'" />
- </ParameterList>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- </BatchSequence>
- </ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement