Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <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]
FROM [dbo].[Table1] A
WHERE ((A.[f7] = @SV1 AND A.[f8] = @SV2 AND A.[f9] BETWEEN @SV3 AND @SV4) AND (A.[f4] = @SV5 AND (A.[f4] <> @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 ''))) AND (CHARINDEX(@SV17,A.[f5])>0 OR CHARINDEX(@SV18,A.[f5])>0 OR CHARINDEX(@SV19,A.[f5])>0 OR CHARINDEX(@SV20,A.[f5])>0)))
ORDER BY A.[f7] ASC,A.[f8] ASC,A.[f9] ASC,A.[f14] ASC
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.0683838" StatementEstRows="16.2566" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xEBA2C3AD4E05BF0D" QueryPlanHash="0xA5D49D15idx22108FA" 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="6" CompileCPU="6" CompileMemory="928"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="730700" EstimatedPagesCached="1461401" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="152607736"></OptimizerHardwareDependentProperties><RelOp NodeId="0" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="16.2566" EstimateIO="0" EstimateCPU="0.000167251" AvgRowSize="4185" EstimatedTotalSubtreeCost="0.0683838" 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="20.6994" EstimateIO="0" EstimateCPU="8.65236e-005" AvgRowSize="4185" EstimatedTotalSubtreeCost="0.0682166" 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"><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></OuterReferences><RelOp NodeId="2" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="20.6994" EstimatedRowsRead="20.6994" EstimateIO="0.003125" EstimateCPU="0.000179769" AvgRowSize="76" EstimatedTotalSubtreeCost="0.00330477" TableCardinality="764376" 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="4" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="16.2566" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="4116" EstimatedTotalSubtreeCost="0.0648253" TableCardinality="764376" Parallel="0" EstimateRebinds="19.6994" 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]<>[@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''))"><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''"></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])>(0) OR charindex(CONVERT_IMPLICIT(nvarchar(4000),[@SV18],0),[DB1].[dbo].[Table1].[f5] as [A].[f5])>(0) OR charindex(CONVERT_IMPLICIT(nvarchar(4000),[@SV19],0),[DB1].[dbo].[Table1].[f5] as [A].[f5])>(0) OR charindex(CONVERT_IMPLICIT(nvarchar(4000),[@SV20],0),[DB1].[dbo].[Table1].[f5] as [A].[f5])>(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'CVD,'"></ColumnReference><ColumnReference Column="@SV19" ParameterDataType="nvarchar(max)" ParameterCompiledValue="N'EtCO2mmHg,'"></ColumnReference><ColumnReference Column="@SV18" ParameterDataType="nvarchar(max)" ParameterCompiledValue="N'Temp2,'"></ColumnReference><ColumnReference Column="@SV17" ParameterDataType="nvarchar(max)" ParameterCompiledValue="N'Temp,'"></ColumnReference><ColumnReference Column="@SV16" ParameterDataType="nvarchar(1)" ParameterCompiledValue="N'E'"></ColumnReference><ColumnReference Column="@SV15" ParameterDataType="nvarchar(1)" ParameterCompiledValue="N'N'"></ColumnReference><ColumnReference Column="@SV14" ParameterDataType="nvarchar(1)" ParameterCompiledValue="N'Z'"></ColumnReference><ColumnReference Column="@SV13" ParameterDataType="nvarchar(1)" ParameterCompiledValue="N'T'"></ColumnReference><ColumnReference Column="@SV12" ParameterDataType="nvarchar(1)" ParameterCompiledValue="N'K'"></ColumnReference><ColumnReference Column="@SV11" ParameterDataType="nvarchar(1)" ParameterCompiledValue="N'S'"></ColumnReference><ColumnReference Column="@SV10" ParameterDataType="nvarchar(1)" ParameterCompiledValue="N'V'"></ColumnReference><ColumnReference Column="@SV9" ParameterDataType="nvarchar(1)" ParameterCompiledValue="N'C'"></ColumnReference><ColumnReference Column="@SV8" ParameterDataType="nvarchar(1)" ParameterCompiledValue="N'U'"></ColumnReference><ColumnReference Column="@SV7" ParameterDataType="nvarchar(1)" ParameterCompiledValue="N'D'"></ColumnReference><ColumnReference Column="@SV6" ParameterDataType="nvarchar(1)" ParameterCompiledValue="N'X'"></ColumnReference><ColumnReference Column="@SV5" ParameterDataType="nvarchar(1)" ParameterCompiledValue="N'P'"></ColumnReference><ColumnReference Column="@SV4" ParameterDataType="nvarchar(8)" ParameterCompiledValue="N'18:00:00'"></ColumnReference><ColumnReference Column="@SV3" ParameterDataType="nvarchar(8)" ParameterCompiledValue="N'09:00:00'"></ColumnReference><ColumnReference Column="@SV2" ParameterDataType="datetime" ParameterCompiledValue="'2018-04-23 00:00:00.000'"></ColumnReference><ColumnReference Column="@SV1" ParameterDataType="nvarchar(13)" ParameterCompiledValue="N'3905281055'"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
Add Comment
Please, Sign In to add comment
