Skip to content

Instantly share code, notes, and snippets.

@Doogie04

Doogie04/ExecutionPlan - Using Hint

Created October 15, 2012 17:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Doogie04/3893736 to your computer and use it in GitHub Desktop.
Save Doogie04/3893736 to your computer and use it in GitHub Desktop.
Download ZIP
SQLPlans (with/without) HINT - for dba.stackexchange.com question.
Raw
ExecutionPlan - Using Hint
<?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.2" Build="11.0.2100.60" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementCompId="1" StatementEstRows="9.41114" StatementId="1" StatementOptmLevel="TRIVIAL" StatementSubTreeCost="0.00331306" StatementText="SELECT * FROM [TimelineMaterialized] [TM] WITH(noexpand) WHERE [TM].[EmployeeID]=@1 AND [TM].[CultureCode]=@2 AND [TM].[CreateUTC]&gt;@3 AND [TM].[CreateUTC]&lt;@4" StatementType="SELECT" QueryHash="0x1049C20BCA758A9" QueryPlanHash="0xC090D5386FCF0C62" RetrievedFromCache="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="1" CachedPlanSize="32" CompileTime="151" CompileCPU="148" CompileMemory="184">
<MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" />
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="209692" EstimatedPagesCached="19399" EstimatedAvailableDegreeOfParallelism="2" />
<RelOp AvgRowSize="138" EstimateCPU="0.000188057" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="9.41114" LogicalOp="Clustered Index Seek" NodeId="0" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00331306" TableCardinality="48000">
<OutputList>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[TimelineMaterialized]" Alias="[TM]" Column="TimelineID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[TimelineMaterialized]" Alias="[TM]" Column="TimelineTypeID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[TimelineMaterialized]" Alias="[TM]" Column="EmployeeID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[TimelineMaterialized]" Alias="[TM]" Column="CreateUTC" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[TimelineMaterialized]" Alias="[TM]" Column="HrefId" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[TimelineMaterialized]" Alias="[TM]" Column="HrefText" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[TimelineMaterialized]" Alias="[TM]" Column="CultureCode" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="11" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="true" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[TimelineMaterialized]" Alias="[TM]" Column="TimelineID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[TimelineMaterialized]" Alias="[TM]" Column="TimelineTypeID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[TimelineMaterialized]" Alias="[TM]" Column="EmployeeID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[TimelineMaterialized]" Alias="[TM]" Column="CreateUTC" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[TimelineMaterialized]" Alias="[TM]" Column="HrefId" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[TimelineMaterialized]" Alias="[TM]" Column="HrefText" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[TimelineMaterialized]" Alias="[TM]" Column="CultureCode" />
</DefinedValue>
</DefinedValues>
<Object Database="[MST]" Schema="[dbo]" Table="[TimelineMaterialized]" Index="[PK_TimelineMaterialized]" Alias="[TM]" IndexKind="ViewClustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[TimelineMaterialized]" Alias="[TM]" Column="EmployeeID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[@1],0)">
<Identifier>
<ColumnReference Column="ConstExpr1002">
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@1" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
<StartRange ScanType="GT">
<RangeColumns>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[TimelineMaterialized]" Alias="[TM]" Column="CreateUTC" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="CONVERT_IMPLICIT(datetime2(7),[@3],0)">
<Identifier>
<ColumnReference Column="ConstExpr1003">
<ScalarOperator>
<Convert DataType="datetime2" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@3" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
</RangeExpressions>
</StartRange>
<EndRange ScanType="LT">
<RangeColumns>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[TimelineMaterialized]" Alias="[TM]" Column="CreateUTC" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="CONVERT_IMPLICIT(datetime2(7),[@4],0)">
<Identifier>
<ColumnReference Column="ConstExpr1004">
<ScalarOperator>
<Convert DataType="datetime2" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@4" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
</RangeExpressions>
</EndRange>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
<Predicate>
<ScalarOperator ScalarString="[MST].[dbo].[TimelineMaterialized].[CultureCode] as [TM].[CultureCode]=[@2]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[TimelineMaterialized]" Alias="[TM]" Column="CultureCode" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="@2" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
<ParameterList>
<ColumnReference Column="@4" ParameterCompiledValue="'9/11/2012'" ParameterRuntimeValue="'9/11/2012'" />
<ColumnReference Column="@3" ParameterCompiledValue="'9/10/2012'" ParameterRuntimeValue="'9/10/2012'" />
<ColumnReference Column="@2" ParameterCompiledValue="'en-US'" ParameterRuntimeValue="'en-US'" />
<ColumnReference Column="@1" ParameterCompiledValue="(2)" ParameterRuntimeValue="(2)" />
</ParameterList>
</QueryPlan>
</StmtSimple>
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>
Raw
ExecutionPlan - WITHOUT Hint
<?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.2" Build="11.0.2100.60" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementCompId="1" StatementEstRows="1" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" StatementSubTreeCost="0.0527923" StatementText="SELECT * FROM [TimelineMaterialized] [TM] WHERE [TM].[EmployeeID]=@1 AND [TM].[CultureCode]=@2 AND [TM].[CreateUTC]&gt;@3 AND [TM].[CreateUTC]&lt;@4" StatementType="SELECT" QueryHash="0xAB15F4F995A0808" QueryPlanHash="0x3B15CE9DA253FA85" RetrievedFromCache="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="104" CompileTime="28" CompileCPU="28" CompileMemory="1440">
<MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" />
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="209692" EstimatedPagesCached="19345" EstimatedAvailableDegreeOfParallelism="2" />
<RelOp AvgRowSize="139" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="0" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0527923">
<OutputList>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="TimelineID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="TimelineTypeID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="EmployeeID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CreateUTC" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Culture]" Alias="[CUL]" Column="CultureCode" />
<ColumnReference Column="Expr1023" />
<ColumnReference Column="Expr1024" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1024" />
<ScalarOperator ScalarString="CASE WHEN [MST].[dbo].[Timeline].[CustomerMessageID] as [TM].[CustomerMessageID]&gt;(0) THEN isnull([MST].[dbo].[Customer].[FirstName] as [C].[FirstName]+N' '+[MST].[dbo].[Customer].[LastName] as [C].[LastName],N'N/A') ELSE CASE WHEN [MST].[dbo].[Timeline].[CustomerSessionID] as [TM].[CustomerSessionID]&gt;(0) THEN isnull([MST].[dbo].[Customer].[FirstName] as [C].[FirstName]+N' '+[MST].[dbo].[Customer].[LastName] as [C].[LastName],N'N/A') ELSE CASE WHEN [MST].[dbo].[Timeline].[NewsItemTagID] as [TM].[NewsItemTagID]&gt;(0) THEN isnull([MST].[dbo].[NewsItem].[Title] as [NI].[Title],N'N/A') ELSE CASE WHEN [MST].[dbo].[Timeline].[OutfitID] as [TM].[OutfitID]&gt;(0) THEN isnull([MST].[dbo].[Outfit].[Name] as [O].[Name],N'N/A') ELSE CASE WHEN [MST].[dbo].[Timeline].[ProductTransactionID] as [TM].[ProductTransactionID]&gt;(0) THEN [MST].[dbo].[ProductLang].[NameLocalized] as [PT_PL].[NameLocalized] ELSE NULL END END END END END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="GT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerMessageID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Intrinsic FunctionName="isnull">
<ScalarOperator>
<Arithmetic Operation="ADD">
<ScalarOperator>
<Arithmetic Operation="ADD">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Customer]" Alias="[C]" Column="FirstName" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="N' '" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Customer]" Alias="[C]" Column="LastName" />
</Identifier>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="N'N/A'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="GT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerSessionID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Intrinsic FunctionName="isnull">
<ScalarOperator>
<Arithmetic Operation="ADD">
<ScalarOperator>
<Arithmetic Operation="ADD">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Customer]" Alias="[C]" Column="FirstName" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="N' '" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Customer]" Alias="[C]" Column="LastName" />
</Identifier>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="N'N/A'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="GT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="NewsItemTagID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Intrinsic FunctionName="isnull">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[NewsItem]" Alias="[NI]" Column="Title" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="N'N/A'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="GT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="OutfitID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Intrinsic FunctionName="isnull">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Outfit]" Alias="[O]" Column="Name" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="N'N/A'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="GT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="ProductTransactionID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[ProductLang]" Alias="[PT_PL]" Column="NameLocalized" />
</Identifier>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="392" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Inner Join" NodeId="1" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0527922">
<OutputList>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="TimelineID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="TimelineTypeID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="EmployeeID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CreateUTC" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerMessageID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="OutfitID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerSessionID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="ProductTransactionID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="NewsItemTagID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Customer]" Alias="[C]" Column="FirstName" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Customer]" Alias="[C]" Column="LastName" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Outfit]" Alias="[O]" Column="Name" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[ProductLang]" Alias="[PT_PL]" Column="NameLocalized" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Culture]" Alias="[CUL]" Column="CultureCode" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[NewsItem]" Alias="[NI]" Column="Title" />
<ColumnReference Column="Expr1023" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="11" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="false">
<OuterReferences>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[ProductLang]" Alias="[PT_PL]" Column="CultureID" />
</OuterReferences>
<RelOp AvgRowSize="390" EstimateCPU="5.73561E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Inner Join" NodeId="2" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0495041">
<OutputList>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="TimelineID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="TimelineTypeID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="EmployeeID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CreateUTC" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerMessageID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="OutfitID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerSessionID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="ProductTransactionID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="NewsItemTagID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Customer]" Alias="[C]" Column="FirstName" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Customer]" Alias="[C]" Column="LastName" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Outfit]" Alias="[O]" Column="Name" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[ProductLang]" Alias="[PT_PL]" Column="CultureID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[ProductLang]" Alias="[PT_PL]" Column="NameLocalized" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[NewsItem]" Alias="[NI]" Column="Title" />
<ColumnReference Column="Expr1023" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="33" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="false">
<OuterReferences>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="TimelineTypeID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[CustomerSession]" Alias="[CS]" Column="CustomerID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[CustomerMessage]" Alias="[CM]" Column="CustomerID" />
</OuterReferences>
<RelOp AvgRowSize="294" EstimateCPU="5.73561E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="13.7215" LogicalOp="Inner Join" NodeId="3" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0404801">
<OutputList>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="TimelineID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="TimelineTypeID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="EmployeeID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CreateUTC" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerMessageID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="OutfitID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerSessionID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="ProductTransactionID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="NewsItemTagID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[CustomerSession]" Alias="[CS]" Column="CustomerID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[CustomerMessage]" Alias="[CM]" Column="CustomerID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Outfit]" Alias="[O]" Column="Name" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[ProductLang]" Alias="[PT_PL]" Column="CultureID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[ProductLang]" Alias="[PT_PL]" Column="NameLocalized" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[NewsItem]" Alias="[NI]" Column="Title" />
<ColumnReference Column="Expr1023" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="33" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="false">
<OuterReferences>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerSessionID" />
</OuterReferences>
<RelOp AvgRowSize="290" EstimateCPU="5.73561E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="13.7215" LogicalOp="Inner Join" NodeId="4" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0351284">
<OutputList>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="TimelineID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="TimelineTypeID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="EmployeeID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CreateUTC" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerMessageID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="OutfitID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerSessionID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="ProductTransactionID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="NewsItemTagID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[CustomerMessage]" Alias="[CM]" Column="CustomerID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Outfit]" Alias="[O]" Column="Name" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[ProductLang]" Alias="[PT_PL]" Column="CultureID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[ProductLang]" Alias="[PT_PL]" Column="NameLocalized" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[NewsItem]" Alias="[NI]" Column="Title" />
<ColumnReference Column="Expr1023" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="33" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="false">
<OuterReferences>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerMessageID" />
</OuterReferences>
<RelOp AvgRowSize="286" EstimateCPU="5.73561E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="13.7215" LogicalOp="Inner Join" NodeId="5" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0297766">
<OutputList>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="TimelineID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="TimelineTypeID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="EmployeeID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CreateUTC" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerMessageID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="OutfitID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerSessionID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="ProductTransactionID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="NewsItemTagID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Outfit]" Alias="[O]" Column="Name" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[ProductLang]" Alias="[PT_PL]" Column="CultureID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[ProductLang]" Alias="[PT_PL]" Column="NameLocalized" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[NewsItem]" Alias="[NI]" Column="Title" />
<ColumnReference Column="Expr1023" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="33" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="false">
<OuterReferences>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="OutfitID" />
</OuterReferences>
<RelOp AvgRowSize="234" EstimateCPU="5.73561E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="13.7215" LogicalOp="Inner Join" NodeId="6" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0244249">
<OutputList>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="TimelineID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="TimelineTypeID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="EmployeeID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CreateUTC" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerMessageID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="OutfitID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerSessionID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="ProductTransactionID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="NewsItemTagID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[ProductLang]" Alias="[PT_PL]" Column="CultureID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[ProductLang]" Alias="[PT_PL]" Column="NameLocalized" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[NewsItem]" Alias="[NI]" Column="Title" />
<ColumnReference Column="Expr1023" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="33" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="false">
<OuterReferences>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[ProductTransaction]" Alias="[PT]" Column="ProductID" />
</OuterReferences>
<RelOp AvgRowSize="157" EstimateCPU="3.82374E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="9.1477" LogicalOp="Inner Join" NodeId="7" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0197913">
<OutputList>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="TimelineID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="TimelineTypeID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="EmployeeID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CreateUTC" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerMessageID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="OutfitID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerSessionID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="ProductTransactionID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="NewsItemTagID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[ProductTransaction]" Alias="[PT]" Column="ProductID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[NewsItem]" Alias="[NI]" Column="Title" />
<ColumnReference Column="Expr1023" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="11" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="false">
<OuterReferences>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="ProductTransactionID" />
</OuterReferences>
<RelOp AvgRowSize="153" EstimateCPU="3.82374E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="9.1477" LogicalOp="Inner Join" NodeId="8" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0151818">
<OutputList>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="TimelineID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="TimelineTypeID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="EmployeeID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CreateUTC" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerMessageID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="OutfitID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerSessionID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="ProductTransactionID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="NewsItemTagID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[NewsItem]" Alias="[NI]" Column="Title" />
<ColumnReference Column="Expr1023" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="11" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="false">
<OuterReferences>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[NewsItemTag]" Alias="[NIT]" Column="NewsItemID" />
</OuterReferences>
<RelOp AvgRowSize="53" EstimateCPU="3.82374E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="9.1477" LogicalOp="Inner Join" NodeId="9" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00790247">
<OutputList>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="TimelineID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="TimelineTypeID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="EmployeeID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CreateUTC" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerMessageID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="OutfitID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerSessionID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="ProductTransactionID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="NewsItemTagID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[NewsItemTag]" Alias="[NIT]" Column="NewsItemID" />
<ColumnReference Column="Expr1023" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="11" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="false">
<OuterReferences>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="NewsItemTagID" />
</OuterReferences>
<RelOp AvgRowSize="49" EstimateCPU="9.1477E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="9.1477" LogicalOp="Compute Scalar" NodeId="10" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.00329298">
<OutputList>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="TimelineID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="TimelineTypeID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="EmployeeID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CreateUTC" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerMessageID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="OutfitID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerSessionID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="ProductTransactionID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="NewsItemTagID" />
<ColumnReference Column="Expr1023" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1023" />
<ScalarOperator ScalarString="CASE WHEN [MST].[dbo].[Timeline].[CustomerMessageID] as [TM].[CustomerMessageID]&gt;(0) THEN [MST].[dbo].[Timeline].[CustomerMessageID] as [TM].[CustomerMessageID] ELSE CASE WHEN [MST].[dbo].[Timeline].[CustomerSessionID] as [TM].[CustomerSessionID]&gt;(0) THEN [MST].[dbo].[Timeline].[CustomerSessionID] as [TM].[CustomerSessionID] ELSE CASE WHEN [MST].[dbo].[Timeline].[NewsItemTagID] as [TM].[NewsItemTagID]&gt;(0) THEN [MST].[dbo].[Timeline].[NewsItemTagID] as [TM].[NewsItemTagID] ELSE CASE WHEN [MST].[dbo].[Timeline].[OutfitID] as [TM].[OutfitID]&gt;(0) THEN [MST].[dbo].[Timeline].[OutfitID] as [TM].[OutfitID] ELSE CASE WHEN [MST].[dbo].[Timeline].[ProductTransactionID] as [TM].[ProductTransactionID]&gt;(0) THEN [MST].[dbo].[Timeline].[ProductTransactionID] as [TM].[ProductTransactionID] ELSE (0) END END END END END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="GT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerMessageID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerMessageID" />
</Identifier>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="GT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerSessionID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerSessionID" />
</Identifier>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="GT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="NewsItemTagID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="NewsItemTagID" />
</Identifier>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="GT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="OutfitID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="OutfitID" />
</Identifier>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="GT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="ProductTransactionID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="ProductTransactionID" />
</Identifier>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="45" EstimateCPU="0.000167062" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="9.1477" LogicalOp="Clustered Index Seek" NodeId="11" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00329206" TableCardinality="16000">
<OutputList>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="TimelineID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="TimelineTypeID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="EmployeeID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CreateUTC" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerMessageID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="OutfitID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerSessionID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="ProductTransactionID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="NewsItemTagID" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="11" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="TimelineID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="TimelineTypeID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="EmployeeID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CreateUTC" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerMessageID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="OutfitID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerSessionID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="ProductTransactionID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="NewsItemTagID" />
</DefinedValue>
</DefinedValues>
<Object Database="[MST]" Schema="[dbo]" Table="[Timeline]" Index="[UQ_Timeline_EmployeeIDCreateUTCTimelineID]" Alias="[TM]" IndexKind="Clustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="EmployeeID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="(2)">
<Const ConstValue="(2)" />
</ScalarOperator>
</RangeExpressions>
</Prefix>
<StartRange ScanType="GT">
<RangeColumns>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CreateUTC" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="'2012-09-10 00:00:00.0000000'">
<Const ConstValue="'2012-09-10 00:00:00.0000000'" />
</ScalarOperator>
</RangeExpressions>
</StartRange>
<EndRange ScanType="LT">
<RangeColumns>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CreateUTC" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="'2012-09-11 00:00:00.0000000'">
<Const ConstValue="'2012-09-11 00:00:00.0000000'" />
</ScalarOperator>
</RangeExpressions>
</EndRange>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</ComputeScalar>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="2.94505" EstimateRewinds="5.20264" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="15" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00457125" TableCardinality="85">
<OutputList>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[NewsItemTag]" Alias="[NIT]" Column="NewsItemID" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="11" ActualEndOfScans="0" ActualExecutions="11" />
</RunTimeInformation>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[NewsItemTag]" Alias="[NIT]" Column="NewsItemID" />
</DefinedValue>
</DefinedValues>
<Object Database="[MST]" Schema="[dbo]" Table="[NewsItemTag]" Index="[PK_NewsItemTag]" Alias="[NIT]" IndexKind="NonClustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[NewsItemTag]" Alias="[NIT]" Column="NewsItemTagID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[MST].[dbo].[Timeline].[NewsItemTagID] as [TM].[NewsItemTagID]">
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="NewsItemTagID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="111" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="4.56577" EstimateRewinds="3.58193" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="16" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00724108" TableCardinality="15">
<OutputList>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[NewsItem]" Alias="[NI]" Column="Title" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="11" ActualEndOfScans="0" ActualExecutions="11" />
</RunTimeInformation>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[NewsItem]" Alias="[NI]" Column="Title" />
</DefinedValue>
</DefinedValues>
<Object Database="[MST]" Schema="[dbo]" Table="[NewsItem]" Index="[PK_NewsItem]" Alias="[NI]" IndexKind="Clustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[NewsItem]" Alias="[NI]" Column="NewsItemID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[MST].[dbo].[NewsItemTag].[NewsItemID] as [NIT].[NewsItemID]">
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[NewsItemTag]" Alias="[NIT]" Column="NewsItemID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="2.87052" EstimateRewinds="5.27717" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="17" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00457125" TableCardinality="2">
<OutputList>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[ProductTransaction]" Alias="[PT]" Column="ProductID" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="11" ActualEndOfScans="0" ActualExecutions="11" />
</RunTimeInformation>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[ProductTransaction]" Alias="[PT]" Column="ProductID" />
</DefinedValue>
</DefinedValues>
<Object Database="[MST]" Schema="[dbo]" Table="[ProductTransaction]" Index="[PK_ProductTransaction]" Alias="[PT]" IndexKind="Clustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[ProductTransaction]" Alias="[PT]" Column="ProductTransactionID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[MST].[dbo].[Timeline].[ProductTransactionID] as [TM].[ProductTransactionID]">
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="ProductTransactionID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="90" EstimateCPU="0.00015865" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="8.1477" EstimatedExecutionMode="Row" EstimateRows="1.5" LogicalOp="Clustered Index Seek" NodeId="18" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00457628" TableCardinality="18">
<OutputList>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[ProductLang]" Alias="[PT_PL]" Column="CultureID" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[ProductLang]" Alias="[PT_PL]" Column="NameLocalized" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="33" ActualEndOfScans="11" ActualExecutions="11" />
</RunTimeInformation>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[ProductLang]" Alias="[PT_PL]" Column="CultureID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[ProductLang]" Alias="[PT_PL]" Column="NameLocalized" />
</DefinedValue>
</DefinedValues>
<Object Database="[MST]" Schema="[dbo]" Table="[ProductLang]" Index="[PK_ProductLang]" Alias="[PT_PL]" IndexKind="Clustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[ProductLang]" Alias="[PT_PL]" Column="ProductID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[MST].[dbo].[ProductTransaction].[ProductID] as [PT].[ProductID]">
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[ProductTransaction]" Alias="[PT]" Column="ProductID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="61" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="4.23411" EstimateRewinds="8.48743" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="19" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00529438" TableCardinality="2">
<OutputList>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Outfit]" Alias="[O]" Column="Name" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="33" ActualEndOfScans="0" ActualExecutions="33" />
</RunTimeInformation>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Outfit]" Alias="[O]" Column="Name" />
</DefinedValue>
</DefinedValues>
<Object Database="[MST]" Schema="[dbo]" Table="[Outfit]" Index="[PK_Outfit]" Alias="[O]" IndexKind="Clustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Outfit]" Alias="[O]" Column="OutfitID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[MST].[dbo].[Timeline].[OutfitID] as [TM].[OutfitID]">
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="OutfitID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="4.4786" EstimateRewinds="8.24294" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="20" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00529438" TableCardinality="2">
<OutputList>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[CustomerMessage]" Alias="[CM]" Column="CustomerID" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="33" ActualEndOfScans="0" ActualExecutions="33" />
</RunTimeInformation>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[CustomerMessage]" Alias="[CM]" Column="CustomerID" />
</DefinedValue>
</DefinedValues>
<Object Database="[MST]" Schema="[dbo]" Table="[CustomerMessage]" Index="[PK_CustomerMessage]" Alias="[CM]" IndexKind="Clustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[CustomerMessage]" Alias="[CM]" Column="CustomerMessageID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[MST].[dbo].[Timeline].[CustomerMessageID] as [TM].[CustomerMessageID]">
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerMessageID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="4.51284" EstimateRewinds="8.2087" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="21" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00529438" TableCardinality="2">
<OutputList>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[CustomerSession]" Alias="[CS]" Column="CustomerID" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="33" ActualEndOfScans="0" ActualExecutions="33" />
</RunTimeInformation>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[CustomerSession]" Alias="[CS]" Column="CustomerID" />
</DefinedValue>
</DefinedValues>
<Object Database="[MST]" Schema="[dbo]" Table="[CustomerSession]" Index="[PK_CustomerSession]" Alias="[CS]" IndexKind="Clustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[CustomerSession]" Alias="[CS]" Column="CustomerSessionID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[MST].[dbo].[Timeline].[CustomerSessionID] as [TM].[CustomerSessionID]">
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="CustomerSessionID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="113" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="7.41376" EstimateRewinds="5.30779" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="22" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0089666" TableCardinality="1091380">
<OutputList>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Customer]" Alias="[C]" Column="FirstName" />
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Customer]" Alias="[C]" Column="LastName" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="33" ActualEndOfScans="0" ActualExecutions="33" />
</RunTimeInformation>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Customer]" Alias="[C]" Column="FirstName" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Customer]" Alias="[C]" Column="LastName" />
</DefinedValue>
</DefinedValues>
<Object Database="[MST]" Schema="[dbo]" Table="[Customer]" Index="[PK_Customer]" Alias="[C]" IndexKind="Clustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Customer]" Alias="[C]" Column="CustomerID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="CASE WHEN [MST].[dbo].[Timeline].[TimelineTypeID] as [TM].[TimelineTypeID]=(1) THEN [MST].[dbo].[CustomerMessage].[CustomerID] as [CM].[CustomerID] ELSE CASE WHEN [MST].[dbo].[Timeline].[TimelineTypeID] as [TM].[TimelineTypeID]=(5) THEN [MST].[dbo].[CustomerSession].[CustomerID] as [CS].[CustomerID] ELSE (0) END END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="TimelineTypeID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[CustomerMessage]" Alias="[CM]" Column="CustomerID" />
</Identifier>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Timeline]" Alias="[TM]" Column="TimelineTypeID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(5)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[CustomerSession]" Alias="[CS]" Column="CustomerID" />
</Identifier>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="16" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="23" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="6">
<OutputList>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Culture]" Alias="[CUL]" Column="CultureCode" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="11" ActualEndOfScans="22" ActualExecutions="33" />
</RunTimeInformation>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Culture]" Alias="[CUL]" Column="CultureCode" />
</DefinedValue>
</DefinedValues>
<Object Database="[MST]" Schema="[dbo]" Table="[Culture]" Index="[PK_CultureTest]" Alias="[CUL]" IndexKind="Clustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Culture]" Alias="[CUL]" Column="CultureID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[MST].[dbo].[ProductLang].[CultureID] as [PT_PL].[CultureID]">
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[ProductLang]" Alias="[PT_PL]" Column="CultureID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
<Predicate>
<ScalarOperator ScalarString="[MST].[dbo].[Culture].[IsActive] as [CUL].[IsActive]=(1) AND [MST].[dbo].[Culture].[CultureCode] as [CUL].[CultureCode]='en-US'">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Culture]" Alias="[CUL]" Column="IsActive" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[MST]" Schema="[dbo]" Table="[Culture]" Alias="[CUL]" Column="CultureCode" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'en-US'" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
</ComputeScalar>
</RelOp>
<ParameterList>
<ColumnReference Column="@4" ParameterCompiledValue="'9/11/2012'" ParameterRuntimeValue="'9/11/2012'" />
<ColumnReference Column="@3" ParameterCompiledValue="'9/10/2012'" ParameterRuntimeValue="'9/10/2012'" />
<ColumnReference Column="@2" ParameterCompiledValue="'en-US'" ParameterRuntimeValue="'en-US'" />
<ColumnReference Column="@1" ParameterCompiledValue="(2)" ParameterRuntimeValue="(2)" />
</ParameterList>
</QueryPlan>
</StmtSimple>
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment