SHARE
TWEET

QueryStore_Plan_With_Missing_Index

fvanderhaegen Apr 24th, 2018 (edited) 60 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.5" Build="13.0.4466.4"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT A.[f1],A.[f2],A.[f3],A.[f4],A.[f5],A.[f6],A.[f7],A.[f8],A.[f9],A.[f10],A.[f11],A.[f12],A.[f13],A.[f14]&#xd;&#xa;FROM [dbo].[Table1] A&#xd;&#xa;WHERE ((A.[f7] = @SV1 AND A.[f8] = @SV2 AND A.[f9] BETWEEN @SV3 AND @SV4) AND (A.[f4] = @SV5 AND (A.[f4] &lt;&gt; @SV6 OR A.[f4] is null) AND (A.[f2] = @SV7 OR  A.[f2] = @SV8 OR  A.[f2] = @SV9 OR  A.[f2] = @SV10 OR  A.[f2] = @SV11 OR  A.[f2] = @SV12 OR  A.[f2] = @SV13 OR  A.[f2] = @SV14 OR  A.[f2] = @SV15 OR  (A.[f2] = @SV16 AND (A.[f12] IS NULL OR A.[f12] LIKE &apos;&apos;))) AND (CHARINDEX(@SV17,A.[f5])&gt;0 OR  CHARINDEX(@SV18,A.[f5])&gt;0 OR  CHARINDEX(@SV19,A.[f5])&gt;0 OR  CHARINDEX(@SV20,A.[f5])&gt;0)))&#xd;&#xa;ORDER BY A.[f7] ASC,A.[f8] ASC,A.[f9] ASC,A.[f14] ASC&#xd;&#xa;OPTION (KEEP PLAN, KEEPFIXED PLAN, LOOP JOIN)" StatementId="1" StatementCompId="5" StatementType="SELECT" StatementSqlHandle="0x09003374CBAA11BDB76F38B5E85B7F8833B50000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="2" ParentObjectId="0" StatementParameterizationType="1" RetrievedFromCache="true" StatementSubTreeCost="0.625885" StatementEstRows="149.481" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xEBA2C3AD4E05BF0D" QueryPlanHash="0xD71490A6DBD79091" 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 NonParallelPlanReason="MaxDOPSetToOne" CachedPlanSize="64" CompileTime="7" CompileCPU="7" CompileMemory="960"><MissingIndexes><MissingIndexGroup Impact="87.3106"><MissingIndex Database="[DB1]" Schema="[dbo]" Table="[Table1]"><ColumnGroup Usage="EQUALITY"><Column Name="[f4]" ColumnId="4"></Column><Column Name="[f7]" ColumnId="7"></Column><Column Name="[f8]" ColumnId="8"></Column></ColumnGroup><ColumnGroup Usage="INEQUALITY"><Column Name="[f9]" ColumnId="9"></Column></ColumnGroup><ColumnGroup Usage="INCLUDE"><Column Name="[f1]" ColumnId="1"></Column><Column Name="[f2]" ColumnId="2"></Column><Column Name="[f3]" ColumnId="3"></Column><Column Name="[f5]" ColumnId="5"></Column><Column Name="[f6]" ColumnId="6"></Column><Column Name="[f10]" ColumnId="10"></Column><Column Name="[f11]" ColumnId="11"></Column><Column Name="[f12]" ColumnId="12"></Column><Column Name="[f13]" ColumnId="13"></Column><Column Name="[f14]" ColumnId="14"></Column></ColumnGroup></MissingIndex></MissingIndexGroup></MissingIndexes><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="730700" EstimatedPagesCached="1461401" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="152355824"></OptimizerHardwareDependentProperties><RelOp NodeId="0" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="149.481" EstimateIO="0" EstimateCPU="0.00153394" AvgRowSize="4185" EstimatedTotalSubtreeCost="0.625885" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f1"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f2"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f3"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f4"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f5"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f6"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f7"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f8"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f9"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f10"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f11"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f12"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f13"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f14"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="1" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="189.844" EstimateIO="0" EstimateCPU="0.000793549" AvgRowSize="4185" EstimatedTotalSubtreeCost="0.624351" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f1"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f2"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f3"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f4"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f5"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f6"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f7"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f8"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f9"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f10"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f11"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f12"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f13"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f14"></ColumnReference></OutputList><NestedLoops Optimized="0" WithOrderedPrefetch="1"><OuterReferences><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f2"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f6"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f8"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f9"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f14"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference></OuterReferences><RelOp NodeId="3" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="189.844" EstimatedRowsRead="189.844" EstimateIO="0.0038311" EstimateCPU="0.000365829" AvgRowSize="76" EstimatedTotalSubtreeCost="0.00419692" TableCardinality="747816" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f2"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f6"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f7"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f8"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f9"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f14"></ColumnReference></OutputList><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><Definedf5><DefinedValue><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f2"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f6"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f7"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f8"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f9"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f14"></ColumnReference></DefinedValue></Definedf5><Object Database="[DB1]" Schema="[dbo]" Table="[Table1]" Index="[idx1]" Alias="[A]" IndexKind="NonClustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f7"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f8"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[@SV1]"><Identifier><ColumnReference Column="@SV1"></ColumnReference></Identifier></ScalarOperator><ScalarOperator ScalarString="[@SV2]"><Identifier><ColumnReference Column="@SV2"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix><StartRange ScanType="GE"><RangeColumns><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f9"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[@SV3]"><Identifier><ColumnReference Column="@SV3"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></StartRange><EndRange ScanType="LE"><RangeColumns><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f9"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[@SV4]"><Identifier><ColumnReference Column="@SV4"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></EndRange></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp><RelOp NodeId="5" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="149.481" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="4116" EstimatedTotalSubtreeCost="0.61936" TableCardinality="747816" Parallel="0" EstimateRebinds="188.844" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f1"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f3"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f4"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f5"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f10"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f11"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f12"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f13"></ColumnReference></OutputList><IndexScan Lookup="1" Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><Definedf5><DefinedValue><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f1"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f3"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f4"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f5"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f10"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f11"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f12"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f13"></ColumnReference></DefinedValue></Definedf5><Object Database="[DB1]" Schema="[dbo]" Table="[Table1]" Index="[idx2]" Alias="[A]" TableReferenceId="-1" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f6"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f2"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f8"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f9"></ColumnReference><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f14"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[DB1].[dbo].[Table1].[f6] as [A].[f6]"><Identifier><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f6"></ColumnReference></Identifier></ScalarOperator><ScalarOperator ScalarString="[DB1].[dbo].[Table1].[f2] as [A].[f2]"><Identifier><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f2"></ColumnReference></Identifier></ScalarOperator><ScalarOperator ScalarString="[DB1].[dbo].[Table1].[f8] as [A].[f8]"><Identifier><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f8"></ColumnReference></Identifier></ScalarOperator><ScalarOperator ScalarString="[DB1].[dbo].[Table1].[f9] as [A].[f9]"><Identifier><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f9"></ColumnReference></Identifier></ScalarOperator><ScalarOperator ScalarString="[DB1].[dbo].[Table1].[f14] as [A].[f14]"><Identifier><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f14"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates><Predicate><ScalarOperator ScalarString="[DB1].[dbo].[Table1].[f4] as [A].[f4]=[@SV5] AND ([DB1].[dbo].[Table1].[f4] as [A].[f4]&lt;&gt;[@SV6] OR [DB1].[dbo].[Table1].[f4] as [A].[f4] IS NULL) AND ([DB1].[dbo].[Table1].[f2] as [A].[f2]=[@SV7] OR [DB1].[dbo].[Table1].[f2] as [A].[f2]=[@SV8] OR [DB1].[dbo].[Table1].[f2] as [A].[f2]=[@SV9] OR [DB1].[dbo].[Table1].[f2] as [A].[f2]=[@SV10] OR [DB1].[dbo].[Table1].[f2] as [A].[f2]=[@SV11] OR [DB1].[dbo].[Table1].[f2] as [A].[f2]=[@SV12] OR [DB1].[dbo].[Table1].[f2] as [A].[f2]=[@SV13] OR [DB1].[dbo].[Table1].[f2] as [A].[f2]=[@SV14] OR [DB1].[dbo].[Table1].[f2] as [A].[f2]=[@SV15] OR [DB1].[dbo].[Table1].[f2] as [A].[f2]=[@SV16] AND ([DB1].[dbo].[Table1].[f12] as [A].[f12] IS NULL OR [DB1].[dbo].[Table1].[f12] as [A].[f12] like N&apos;&apos;))"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f4"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@SV5"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="NE"><ScalarOperator><Identifier><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f4"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@SV6"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f4"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f2"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@SV7"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f2"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@SV8"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f2"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@SV9"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f2"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@SV10"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f2"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@SV11"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f2"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@SV12"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f2"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@SV13"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f2"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@SV14"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f2"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@SV15"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f2"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@SV16"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f12"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Intrinsic FunctionName="like"><ScalarOperator><Identifier><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f12"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="N&apos;&apos;"></Const></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></NestedLoops></RelOp><Predicate><ScalarOperator ScalarString="charindex(CONVERT_IMPLICIT(nvarchar(4000),[@SV17],0),[DB1].[dbo].[Table1].[f5] as [A].[f5])&gt;(0) OR charindex(CONVERT_IMPLICIT(nvarchar(4000),[@SV18],0),[DB1].[dbo].[Table1].[f5] as [A].[f5])&gt;(0) OR charindex(CONVERT_IMPLICIT(nvarchar(4000),[@SV19],0),[DB1].[dbo].[Table1].[f5] as [A].[f5])&gt;(0) OR charindex(CONVERT_IMPLICIT(nvarchar(4000),[@SV20],0),[DB1].[dbo].[Table1].[f5] as [A].[f5])&gt;(0)"><Logical Operation="OR"><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Intrinsic FunctionName="charindex"><ScalarOperator><Identifier><ColumnReference Column="ConstExpr1001"><ScalarOperator><Convert DataType="nvarchar" Length="8000" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="@SV17"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f5"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue=""></Const></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Intrinsic FunctionName="charindex"><ScalarOperator><Identifier><ColumnReference Column="ConstExpr1002"><ScalarOperator><Convert DataType="nvarchar" Length="8000" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="@SV18"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f5"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue=""></Const></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Intrinsic FunctionName="charindex"><ScalarOperator><Identifier><ColumnReference Column="ConstExpr1003"><ScalarOperator><Convert DataType="nvarchar" Length="8000" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="@SV19"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f5"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue=""></Const></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Intrinsic FunctionName="charindex"><ScalarOperator><Identifier><ColumnReference Column="ConstExpr1004"><ScalarOperator><Convert DataType="nvarchar" Length="8000" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="@SV20"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DB1]" Schema="[dbo]" Table="[Table1]" Alias="[A]" Column="f5"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue=""></Const></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp><ParameterList><ColumnReference Column="@SV20" ParameterDataType="nvarchar(max)" ParameterCompiledValue="N&apos;CVD,&apos;"></ColumnReference><ColumnReference Column="@SV19" ParameterDataType="nvarchar(max)" ParameterCompiledValue="N&apos;EtCO2mmHg,&apos;"></ColumnReference><ColumnReference Column="@SV18" ParameterDataType="nvarchar(max)" ParameterCompiledValue="N&apos;Temp2,&apos;"></ColumnReference><ColumnReference Column="@SV17" ParameterDataType="nvarchar(max)" ParameterCompiledValue="N&apos;Temp,&apos;"></ColumnReference><ColumnReference Column="@SV16" ParameterDataType="nvarchar(1)" ParameterCompiledValue="N&apos;E&apos;"></ColumnReference><ColumnReference Column="@SV15" ParameterDataType="nvarchar(1)" ParameterCompiledValue="N&apos;N&apos;"></ColumnReference><ColumnReference Column="@SV14" ParameterDataType="nvarchar(1)" ParameterCompiledValue="N&apos;Z&apos;"></ColumnReference><ColumnReference Column="@SV13" ParameterDataType="nvarchar(1)" ParameterCompiledValue="N&apos;T&apos;"></ColumnReference><ColumnReference Column="@SV12" ParameterDataType="nvarchar(1)" ParameterCompiledValue="N&apos;K&apos;"></ColumnReference><ColumnReference Column="@SV11" ParameterDataType="nvarchar(1)" ParameterCompiledValue="N&apos;S&apos;"></ColumnReference><ColumnReference Column="@SV10" ParameterDataType="nvarchar(1)" ParameterCompiledValue="N&apos;V&apos;"></ColumnReference><ColumnReference Column="@SV9" ParameterDataType="nvarchar(1)" ParameterCompiledValue="N&apos;C&apos;"></ColumnReference><ColumnReference Column="@SV8" ParameterDataType="nvarchar(1)" ParameterCompiledValue="N&apos;U&apos;"></ColumnReference><ColumnReference Column="@SV7" ParameterDataType="nvarchar(1)" ParameterCompiledValue="N&apos;D&apos;"></ColumnReference><ColumnReference Column="@SV6" ParameterDataType="nvarchar(1)" ParameterCompiledValue="N&apos;X&apos;"></ColumnReference><ColumnReference Column="@SV5" ParameterDataType="nvarchar(1)" ParameterCompiledValue="N&apos;P&apos;"></ColumnReference><ColumnReference Column="@SV4" ParameterDataType="nvarchar(8)" ParameterCompiledValue="N&apos;17:00:00&apos;"></ColumnReference><ColumnReference Column="@SV3" ParameterDataType="nvarchar(8)" ParameterCompiledValue="N&apos;08:00:00&apos;"></ColumnReference><ColumnReference Column="@SV2" ParameterDataType="datetime" ParameterCompiledValue="&apos;2018-04-23 00:00:00.000&apos;"></ColumnReference><ColumnReference Column="@SV1" ParameterDataType="nvarchar(13)" ParameterCompiledValue="N&apos;5805146023&apos;"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top