<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.518" Build="13.0.
6300.2">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementText="SELECT TOP 200 [CustomerId] FROM [WCloud].[dbo].[WCloud_CustomerRelationShip] WHERE DsId =
100 AND CreateDate > DATEADD(dd, -
60, GETDATE()) AND Channel IS NULL AND Up = 1" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="0.20
6484" StatementEstRows="5.38322" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xBC387DCA77
6D092C" QueryPlanHash="0x9518
60482D88434C" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="130"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan CachedPlanSize="24" CompileTime="3" CompileCPU="3" CompileMemory="352"><MissingIndexes><MissingIndexGroup Impact="93.
1052"><MissingIndex Database="[WCloud]" Schema="[dbo]" Table="[WCloud_CustomerRelationShip]"><ColumnGroup Usage="EQUALITY"><Column Name="[Channel]" ColumnId="23"></Column><Column Name="[Up]" ColumnId="27"></Column></ColumnGroup><ColumnGroup Usage="INEQUALITY"><Column Name="[CreateDate]" ColumnId="17"></Column></ColumnGroup><ColumnGroup Usage="INCLUDE"><Column Name="[CustomerId]" ColumnId="2"></Column><Column Name="[DsId]" ColumnId="1
6"></Column></ColumnGroup></MissingIndex></MissingIndexGroup></MissingIndexes><Warnings><PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(int,[WCloud].[dbo].[WCloud_CustomerRelationShip].[DsId],0)"></PlanAffectingConvert><PlanAffectingConvert ConvertIssue="Seek Plan" Expression="CONVERT_IMPLICIT(int,[WCloud].[dbo].[WCloud_CustomerRelationShip].[DsId],0)=(
100)"></PlanAffectingConvert></Warnings><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="209702" EstimatedPagesCached="
104851" EstimatedAvailableDegreeOfParallelism="4" MaxCompileMemory="20333
60"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2024-
10-29T11:51:18.84" ModificationCount="587" SamplingPercent="
100" Statistics="[NonClusteredIndex-20170
625-124525]" Table="[WCloud_CustomerRelationShip]" Schema="[dbo]" Database="[WCloud]"></StatisticsInfo><StatisticsInfo LastUpdate="2024-11-0
6T1
6:30:20.43" ModificationCount="501" SamplingPercent="
100" Statistics="[_WA_Sys_00000011_19DFD9
6B]" Table="[WCloud_CustomerRelationShip]" Schema="[dbo]" Database="[WCloud]"></StatisticsInfo><StatisticsInfo LastUpdate="2024-
10-29T11:51:18.87" ModificationCount="587" SamplingPercent="
100" Statistics="[_WA_Sys_00000017_19DFD9
6B]" Table="[WCloud_CustomerRelationShip]" Schema="[dbo]" Database="[WCloud]"></StatisticsInfo><StatisticsInfo LastUpdate="2024-11-0
6T1
6:30:20.44" ModificationCount="501" SamplingPercent="
100" Statistics="[_WA_Sys_0000001B_19DFD9
6B]" Table="[WCloud_CustomerRelationShip]" Schema="[dbo]" Database="[WCloud]"></StatisticsInfo><StatisticsInfo LastUpdate="2024-
10-29T11:51:18.82" ModificationCount="587" SamplingPercent="
100" Statistics="[_WA_Sys_000000
10_19DFD9
6B]" Table="[WCloud_CustomerRelationShip]" Schema="[dbo]" Database="[WCloud]"></StatisticsInfo><StatisticsInfo LastUpdate="2025-02-23T12:09:59.
68" ModificationCount="283" SamplingPercent="
100" Statistics="[NonClusteredIndex-
20190426-14423
6]" Table="[WCloud_CustomerRelationShip]" Schema="[dbo]" Database="[WCloud]"></StatisticsInfo></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Top" LogicalOp="Top" EstimateRows="5.38322" EstimateIO="0" EstimateCPU="5.38322e-007" AvgRowSize="11" EstimatedTotalSubtreeCost="0.20
6484" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[WCloud]" Schema="[dbo]" Table="[WCloud_CustomerRelationShip]" Column="CustomerId"></ColumnReference></OutputList><Top RowCount="0" IsPercent="0" WithTies="0"><TopExpression><ScalarOperator ScalarString="(200)"><Const ConstValue="(200)"></Const></ScalarOperator></TopExpression><RelOp NodeId="2" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="5.38322" EstimatedRowsRead="7828" EstimateIO="0.185347" EstimateCPU="0.0087
678" AvgRowSize="
62" EstimatedTotalSubtreeCost="0.194115" TableCardinality="7828" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[WCloud]" Schema="[dbo]" Table="[WCloud_CustomerRelationShip]" Column="CustomerId"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[WCloud]" Schema="[dbo]" Table="[WCloud_CustomerRelationShip]" Column="CustomerId"></ColumnReference></DefinedValue></DefinedValues><Object Database="[WCloud]" Schema="[dbo]" Table="[WCloud_CustomerRelationShip]" Index="[PK_WCLOUD_CUSTOMERRELATIONSHIP]" IndexKind="Clustered" Storage="RowStore"></Object><Predicate><ScalarOperator ScalarString="[WCloud].[dbo].[WCloud_CustomerRelationShip].[CreateDate]>dateadd(day,(-
60),getdate()) AND [WCloud].[dbo].[WCloud_CustomerRelationShip].[Up]=(1) AND [WCloud].[dbo].[WCloud_CustomerRelationShip].[Channel] IS NULL AND CONVERT_IMPLICIT(int,[WCloud].[dbo].[WCloud_CustomerRelationShip].[DsId],0)=(
100)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Database="[WCloud]" Schema="[dbo]" Table="[WCloud_CustomerRelationShip]" Column="CreateDate"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="ConstExpr
1002"><ScalarOperator><Intrinsic FunctionName="dateadd"><ScalarOperator><Const ConstValue="(4)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(-
60)"></Const></ScalarOperator><ScalarOperator><Intrinsic FunctionName="getdate"></Intrinsic></ScalarOperator></Intrinsic></ScalarOperator></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[WCloud]" Schema="[dbo]" Table="[WCloud_CustomerRelationShip]" Column="Up"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[WCloud]" Schema="[dbo]" Table="[WCloud_CustomerRelationShip]" Column="Channel"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[WCloud]" Schema="[dbo]" Table="[WCloud_CustomerRelationShip]" Column="DsId"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue="(
100)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Top></RelOp></QueryPlan></StmtSimpl帮我解析一下这个执行计划
扫一扫
131
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
