Skip to content

Instantly share code, notes, and snippets.

@CodingGorilla

CodingGorilla/Delete-ExecutionPlan.xml Secret

Created April 26, 2018 21:19
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 CodingGorilla/6cf7a87df9257d5f93e0d545af9839c2 to your computer and use it in GitHub Desktop.
Save CodingGorilla/6cf7a87df9257d5f93e0d545af9839c2 to your computer and use it in GitHub Desktop.
Download ZIP
Execution plan for delete query
Raw
Delete-ExecutionPlan.xml
<?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.520" Build="15.0.300.379" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementCompId="1" StatementEstRows="1" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="70" StatementSubTreeCost="0.802874" StatementText="DELETE FROM Chemical WHERE DealerID = 0" StatementType="DELETE" ParameterizedText="(@1 tinyint)DELETE [Chemical] WHERE [DealerID]=@1" QueryHash="0x12318B09292BE841" QueryPlanHash="0xBEE41F1FCA745508" RetrievedFromCache="false" SecurityPolicyApplied="false">
<StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
<QueryPlan NonParallelPlanReason="EstimatedDOPIsOne" CachedPlanSize="440" CompileTime="85" CompileCPU="84" CompileMemory="14256">
<MemoryGrantInfo SerialRequiredMemory="1024" SerialDesiredMemory="1072" />
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="17616030" EstimatedPagesCached="1101001" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="2470576" />
<RelOp AvgRowSize="9" EstimateCPU="5.12998E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Sequence" NodeId="1" Parallel="false" PhysicalOp="Sequence" EstimatedTotalSubtreeCost="0.802874">
<OutputList />
<Sequence>
<RelOp AvgRowSize="11" EstimateCPU="3.36523E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Eager Spool" NodeId="2" Parallel="false" PhysicalOp="Table Spool" EstimatedTotalSubtreeCost="0.0078618">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OutputList>
<Spool>
<RelOp AvgRowSize="11" EstimateCPU="2E-06" EstimateIO="0.02" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Delete" NodeId="3" Parallel="false" PhysicalOp="Clustered Index Delete" EstimatedTotalSubtreeCost="0.0232851">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OutputList>
<Update DMLRequestSort="false">
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Index="[PK_dbo.Chemical]" IndexKind="Clustered" Storage="RowStore" />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Index="[IX_DealerID]" IndexKind="NonClustered" Storage="RowStore" />
<RelOp AvgRowSize="11" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimatedRowsRead="1" LogicalOp="Index Seek" NodeId="4" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="138426">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</DefinedValue>
</DefinedValues>
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Index="[IX_DealerID]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="DealerID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="(0)">
<Const ConstValue="(0)" />
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</Update>
</RelOp>
</Spool>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="5.01938E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.44531" LogicalOp="Eager Spool" NodeId="5" Parallel="false" PhysicalOp="Table Spool" EstimatedTotalSubtreeCost="0.020678">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Product]" Column="ProductID" />
</OutputList>
<Spool>
<RelOp AvgRowSize="11" EstimateCPU="4.33594E-06" EstimateIO="0.03" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.44531" LogicalOp="Delete" NodeId="6" Parallel="false" PhysicalOp="Clustered Index Delete" EstimatedTotalSubtreeCost="0.0411558">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Product]" Column="ProductID" />
</OutputList>
<Update DMLRequestSort="false">
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Product]" Index="[PK_dbo.Product]" IndexKind="Clustered" Storage="RowStore" />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Product]" Index="[idx_UniqueProduct]" Filtered="true" IndexKind="NonClustered" Storage="RowStore" />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Product]" Index="[IX_ChemicalID]" IndexKind="NonClustered" Storage="RowStore" />
<RelOp AvgRowSize="11" EstimateCPU="6.04141E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.44531" LogicalOp="Inner Join" NodeId="7" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0111514">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Product]" Column="ProductID" />
</OutputList>
<NestedLoops Optimized="false">
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<RelOp AvgRowSize="11" EstimateCPU="3.36523E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Eager Spool" NodeId="8" Parallel="false" PhysicalOp="Table Spool" EstimatedTotalSubtreeCost="0.0078618">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OutputList>
<Spool PrimaryNodeId="2" />
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.00015859" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.44531" EstimatedRowsRead="1.44531" LogicalOp="Index Seek" NodeId="9" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00328359" TableCardinality="971">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Product]" Column="ProductID" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Product]" Column="ProductID" />
</DefinedValue>
</DefinedValues>
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Product]" Index="[IX_ChemicalID]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Product]" Column="ChemicalID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
</Update>
</RelOp>
</Spool>
</RelOp>
<RelOp AvgRowSize="9" EstimateCPU="1.68466E-06" EstimateIO="0.01" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.68466" LogicalOp="Delete" NodeId="10" Parallel="false" PhysicalOp="Clustered Index Delete" EstimatedTotalSubtreeCost="0.0652608">
<OutputList />
<Update DMLRequestSort="false">
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[DealerProduct]" Index="[PK_DealerProduct]" IndexKind="Clustered" Storage="RowStore" />
<RelOp AvgRowSize="15" EstimateCPU="0.0227018" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.68466" LogicalOp="Inner Join" NodeId="11" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="0.0552591">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[DealerProduct]" Column="DealerID" />
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[DealerProduct]" Column="ProductID" />
</OutputList>
<MemoryFractions Input="1" Output="1" />
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Product]" Column="ProductID" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[DealerProduct]" Column="ProductID" />
</HashKeysProbe>
<RelOp AvgRowSize="11" EstimateCPU="5.01938E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.44531" LogicalOp="Eager Spool" NodeId="12" Parallel="false" PhysicalOp="Table Spool" EstimatedTotalSubtreeCost="0.020678">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Product]" Column="ProductID" />
</OutputList>
<Spool PrimaryNodeId="5" />
</RelOp>
<RelOp AvgRowSize="15" EstimateCPU="0.0013439" EstimateIO="0.0105324" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1079" EstimatedRowsRead="1079" LogicalOp="Clustered Index Scan" NodeId="13" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0118763" TableCardinality="1079">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[DealerProduct]" Column="DealerID" />
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[DealerProduct]" Column="ProductID" />
</OutputList>
<IndexScan Ordered="true" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[DealerProduct]" Column="DealerID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[DealerProduct]" Column="ProductID" />
</DefinedValue>
</DefinedValues>
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[DealerProduct]" Index="[PK_DealerProduct]" IndexKind="Clustered" Storage="RowStore" />
</IndexScan>
</RelOp>
</Hash>
</RelOp>
</Update>
</RelOp>
<RelOp AvgRowSize="9" EstimateCPU="1.288E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Assert" NodeId="14" Parallel="false" PhysicalOp="Assert" EstimatedTotalSubtreeCost="0.709069">
<OutputList />
<Assert StartupExpression="false">
<RelOp AvgRowSize="18" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="15" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.709056">
<OutputList>
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1130" />
<ColumnReference Column="Expr1131" />
<ColumnReference Column="Expr1132" />
<ColumnReference Column="Expr1133" />
<ColumnReference Column="Expr1134" />
<ColumnReference Column="Expr1135" />
<ColumnReference Column="Expr1136" />
<ColumnReference Column="Expr1137" />
<ColumnReference Column="Expr1138" />
<ColumnReference Column="Expr1139" />
<ColumnReference Column="Expr1140" />
<ColumnReference Column="Expr1141" />
<ColumnReference Column="Expr1142" />
<ColumnReference Column="Expr1143" />
<ColumnReference Column="Expr1144" />
<ColumnReference Column="Expr1145" />
<ColumnReference Column="Expr1146" />
<ColumnReference Column="Expr1147" />
<ColumnReference Column="Expr1148" />
<ColumnReference Column="Expr1149" />
<ColumnReference Column="Expr1150" />
<ColumnReference Column="Expr1151" />
<ColumnReference Column="Expr1152" />
<ColumnReference Column="Expr1153" />
<ColumnReference Column="Expr1154" />
<ColumnReference Column="Expr1155" />
<ColumnReference Column="Expr1156" />
<ColumnReference Column="Expr1157" />
<ColumnReference Column="Expr1158" />
<ColumnReference Column="Expr1159" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1159" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1159" />
</ProbeColumn>
<RelOp AvgRowSize="22" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="16" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.681162">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1130" />
<ColumnReference Column="Expr1131" />
<ColumnReference Column="Expr1132" />
<ColumnReference Column="Expr1133" />
<ColumnReference Column="Expr1134" />
<ColumnReference Column="Expr1135" />
<ColumnReference Column="Expr1136" />
<ColumnReference Column="Expr1137" />
<ColumnReference Column="Expr1138" />
<ColumnReference Column="Expr1139" />
<ColumnReference Column="Expr1140" />
<ColumnReference Column="Expr1141" />
<ColumnReference Column="Expr1142" />
<ColumnReference Column="Expr1143" />
<ColumnReference Column="Expr1144" />
<ColumnReference Column="Expr1145" />
<ColumnReference Column="Expr1146" />
<ColumnReference Column="Expr1147" />
<ColumnReference Column="Expr1148" />
<ColumnReference Column="Expr1149" />
<ColumnReference Column="Expr1150" />
<ColumnReference Column="Expr1151" />
<ColumnReference Column="Expr1152" />
<ColumnReference Column="Expr1153" />
<ColumnReference Column="Expr1154" />
<ColumnReference Column="Expr1155" />
<ColumnReference Column="Expr1156" />
<ColumnReference Column="Expr1157" />
<ColumnReference Column="Expr1158" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1158" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1158" />
</ProbeColumn>
<RelOp AvgRowSize="21" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="17" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.65759">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1130" />
<ColumnReference Column="Expr1131" />
<ColumnReference Column="Expr1132" />
<ColumnReference Column="Expr1133" />
<ColumnReference Column="Expr1134" />
<ColumnReference Column="Expr1135" />
<ColumnReference Column="Expr1136" />
<ColumnReference Column="Expr1137" />
<ColumnReference Column="Expr1138" />
<ColumnReference Column="Expr1139" />
<ColumnReference Column="Expr1140" />
<ColumnReference Column="Expr1141" />
<ColumnReference Column="Expr1142" />
<ColumnReference Column="Expr1143" />
<ColumnReference Column="Expr1144" />
<ColumnReference Column="Expr1145" />
<ColumnReference Column="Expr1146" />
<ColumnReference Column="Expr1147" />
<ColumnReference Column="Expr1148" />
<ColumnReference Column="Expr1149" />
<ColumnReference Column="Expr1150" />
<ColumnReference Column="Expr1151" />
<ColumnReference Column="Expr1152" />
<ColumnReference Column="Expr1153" />
<ColumnReference Column="Expr1154" />
<ColumnReference Column="Expr1155" />
<ColumnReference Column="Expr1156" />
<ColumnReference Column="Expr1157" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1157" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1157" />
</ProbeColumn>
<RelOp AvgRowSize="20" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="18" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.618311">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1130" />
<ColumnReference Column="Expr1131" />
<ColumnReference Column="Expr1132" />
<ColumnReference Column="Expr1133" />
<ColumnReference Column="Expr1134" />
<ColumnReference Column="Expr1135" />
<ColumnReference Column="Expr1136" />
<ColumnReference Column="Expr1137" />
<ColumnReference Column="Expr1138" />
<ColumnReference Column="Expr1139" />
<ColumnReference Column="Expr1140" />
<ColumnReference Column="Expr1141" />
<ColumnReference Column="Expr1142" />
<ColumnReference Column="Expr1143" />
<ColumnReference Column="Expr1144" />
<ColumnReference Column="Expr1145" />
<ColumnReference Column="Expr1146" />
<ColumnReference Column="Expr1147" />
<ColumnReference Column="Expr1148" />
<ColumnReference Column="Expr1149" />
<ColumnReference Column="Expr1150" />
<ColumnReference Column="Expr1151" />
<ColumnReference Column="Expr1152" />
<ColumnReference Column="Expr1153" />
<ColumnReference Column="Expr1154" />
<ColumnReference Column="Expr1155" />
<ColumnReference Column="Expr1156" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1156" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1156" />
</ProbeColumn>
<RelOp AvgRowSize="20" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="19" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.56716">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1130" />
<ColumnReference Column="Expr1131" />
<ColumnReference Column="Expr1132" />
<ColumnReference Column="Expr1133" />
<ColumnReference Column="Expr1134" />
<ColumnReference Column="Expr1135" />
<ColumnReference Column="Expr1136" />
<ColumnReference Column="Expr1137" />
<ColumnReference Column="Expr1138" />
<ColumnReference Column="Expr1139" />
<ColumnReference Column="Expr1140" />
<ColumnReference Column="Expr1141" />
<ColumnReference Column="Expr1142" />
<ColumnReference Column="Expr1143" />
<ColumnReference Column="Expr1144" />
<ColumnReference Column="Expr1145" />
<ColumnReference Column="Expr1146" />
<ColumnReference Column="Expr1147" />
<ColumnReference Column="Expr1148" />
<ColumnReference Column="Expr1149" />
<ColumnReference Column="Expr1150" />
<ColumnReference Column="Expr1151" />
<ColumnReference Column="Expr1152" />
<ColumnReference Column="Expr1153" />
<ColumnReference Column="Expr1154" />
<ColumnReference Column="Expr1155" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1155" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1155" />
</ProbeColumn>
<RelOp AvgRowSize="20" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="20" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.563873">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1130" />
<ColumnReference Column="Expr1131" />
<ColumnReference Column="Expr1132" />
<ColumnReference Column="Expr1133" />
<ColumnReference Column="Expr1134" />
<ColumnReference Column="Expr1135" />
<ColumnReference Column="Expr1136" />
<ColumnReference Column="Expr1137" />
<ColumnReference Column="Expr1138" />
<ColumnReference Column="Expr1139" />
<ColumnReference Column="Expr1140" />
<ColumnReference Column="Expr1141" />
<ColumnReference Column="Expr1142" />
<ColumnReference Column="Expr1143" />
<ColumnReference Column="Expr1144" />
<ColumnReference Column="Expr1145" />
<ColumnReference Column="Expr1146" />
<ColumnReference Column="Expr1147" />
<ColumnReference Column="Expr1148" />
<ColumnReference Column="Expr1149" />
<ColumnReference Column="Expr1150" />
<ColumnReference Column="Expr1151" />
<ColumnReference Column="Expr1152" />
<ColumnReference Column="Expr1153" />
<ColumnReference Column="Expr1154" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1154" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1154" />
</ProbeColumn>
<RelOp AvgRowSize="20" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="21" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.536091">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1130" />
<ColumnReference Column="Expr1131" />
<ColumnReference Column="Expr1132" />
<ColumnReference Column="Expr1133" />
<ColumnReference Column="Expr1134" />
<ColumnReference Column="Expr1135" />
<ColumnReference Column="Expr1136" />
<ColumnReference Column="Expr1137" />
<ColumnReference Column="Expr1138" />
<ColumnReference Column="Expr1139" />
<ColumnReference Column="Expr1140" />
<ColumnReference Column="Expr1141" />
<ColumnReference Column="Expr1142" />
<ColumnReference Column="Expr1143" />
<ColumnReference Column="Expr1144" />
<ColumnReference Column="Expr1145" />
<ColumnReference Column="Expr1146" />
<ColumnReference Column="Expr1147" />
<ColumnReference Column="Expr1148" />
<ColumnReference Column="Expr1149" />
<ColumnReference Column="Expr1150" />
<ColumnReference Column="Expr1151" />
<ColumnReference Column="Expr1152" />
<ColumnReference Column="Expr1153" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1153" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1153" />
</ProbeColumn>
<RelOp AvgRowSize="20" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="22" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.532804">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1130" />
<ColumnReference Column="Expr1131" />
<ColumnReference Column="Expr1132" />
<ColumnReference Column="Expr1133" />
<ColumnReference Column="Expr1134" />
<ColumnReference Column="Expr1135" />
<ColumnReference Column="Expr1136" />
<ColumnReference Column="Expr1137" />
<ColumnReference Column="Expr1138" />
<ColumnReference Column="Expr1139" />
<ColumnReference Column="Expr1140" />
<ColumnReference Column="Expr1141" />
<ColumnReference Column="Expr1142" />
<ColumnReference Column="Expr1143" />
<ColumnReference Column="Expr1144" />
<ColumnReference Column="Expr1145" />
<ColumnReference Column="Expr1146" />
<ColumnReference Column="Expr1147" />
<ColumnReference Column="Expr1148" />
<ColumnReference Column="Expr1149" />
<ColumnReference Column="Expr1150" />
<ColumnReference Column="Expr1151" />
<ColumnReference Column="Expr1152" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1152" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1152" />
</ProbeColumn>
<RelOp AvgRowSize="20" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="23" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.504797">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1130" />
<ColumnReference Column="Expr1131" />
<ColumnReference Column="Expr1132" />
<ColumnReference Column="Expr1133" />
<ColumnReference Column="Expr1134" />
<ColumnReference Column="Expr1135" />
<ColumnReference Column="Expr1136" />
<ColumnReference Column="Expr1137" />
<ColumnReference Column="Expr1138" />
<ColumnReference Column="Expr1139" />
<ColumnReference Column="Expr1140" />
<ColumnReference Column="Expr1141" />
<ColumnReference Column="Expr1142" />
<ColumnReference Column="Expr1143" />
<ColumnReference Column="Expr1144" />
<ColumnReference Column="Expr1145" />
<ColumnReference Column="Expr1146" />
<ColumnReference Column="Expr1147" />
<ColumnReference Column="Expr1148" />
<ColumnReference Column="Expr1149" />
<ColumnReference Column="Expr1150" />
<ColumnReference Column="Expr1151" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1151" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1151" />
</ProbeColumn>
<RelOp AvgRowSize="20" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="24" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.50151">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1130" />
<ColumnReference Column="Expr1131" />
<ColumnReference Column="Expr1132" />
<ColumnReference Column="Expr1133" />
<ColumnReference Column="Expr1134" />
<ColumnReference Column="Expr1135" />
<ColumnReference Column="Expr1136" />
<ColumnReference Column="Expr1137" />
<ColumnReference Column="Expr1138" />
<ColumnReference Column="Expr1139" />
<ColumnReference Column="Expr1140" />
<ColumnReference Column="Expr1141" />
<ColumnReference Column="Expr1142" />
<ColumnReference Column="Expr1143" />
<ColumnReference Column="Expr1144" />
<ColumnReference Column="Expr1145" />
<ColumnReference Column="Expr1146" />
<ColumnReference Column="Expr1147" />
<ColumnReference Column="Expr1148" />
<ColumnReference Column="Expr1149" />
<ColumnReference Column="Expr1150" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1150" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1150" />
</ProbeColumn>
<RelOp AvgRowSize="19" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="25" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.468298">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1130" />
<ColumnReference Column="Expr1131" />
<ColumnReference Column="Expr1132" />
<ColumnReference Column="Expr1133" />
<ColumnReference Column="Expr1134" />
<ColumnReference Column="Expr1135" />
<ColumnReference Column="Expr1136" />
<ColumnReference Column="Expr1137" />
<ColumnReference Column="Expr1138" />
<ColumnReference Column="Expr1139" />
<ColumnReference Column="Expr1140" />
<ColumnReference Column="Expr1141" />
<ColumnReference Column="Expr1142" />
<ColumnReference Column="Expr1143" />
<ColumnReference Column="Expr1144" />
<ColumnReference Column="Expr1145" />
<ColumnReference Column="Expr1146" />
<ColumnReference Column="Expr1147" />
<ColumnReference Column="Expr1148" />
<ColumnReference Column="Expr1149" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1149" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1149" />
</ProbeColumn>
<RelOp AvgRowSize="18" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="26" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.465011">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1130" />
<ColumnReference Column="Expr1131" />
<ColumnReference Column="Expr1132" />
<ColumnReference Column="Expr1133" />
<ColumnReference Column="Expr1134" />
<ColumnReference Column="Expr1135" />
<ColumnReference Column="Expr1136" />
<ColumnReference Column="Expr1137" />
<ColumnReference Column="Expr1138" />
<ColumnReference Column="Expr1139" />
<ColumnReference Column="Expr1140" />
<ColumnReference Column="Expr1141" />
<ColumnReference Column="Expr1142" />
<ColumnReference Column="Expr1143" />
<ColumnReference Column="Expr1144" />
<ColumnReference Column="Expr1145" />
<ColumnReference Column="Expr1146" />
<ColumnReference Column="Expr1147" />
<ColumnReference Column="Expr1148" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1148" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1148" />
</ProbeColumn>
<RelOp AvgRowSize="18" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="27" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.436892">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1130" />
<ColumnReference Column="Expr1131" />
<ColumnReference Column="Expr1132" />
<ColumnReference Column="Expr1133" />
<ColumnReference Column="Expr1134" />
<ColumnReference Column="Expr1135" />
<ColumnReference Column="Expr1136" />
<ColumnReference Column="Expr1137" />
<ColumnReference Column="Expr1138" />
<ColumnReference Column="Expr1139" />
<ColumnReference Column="Expr1140" />
<ColumnReference Column="Expr1141" />
<ColumnReference Column="Expr1142" />
<ColumnReference Column="Expr1143" />
<ColumnReference Column="Expr1144" />
<ColumnReference Column="Expr1145" />
<ColumnReference Column="Expr1146" />
<ColumnReference Column="Expr1147" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1147" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1147" />
</ProbeColumn>
<RelOp AvgRowSize="18" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="28" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.433605">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1130" />
<ColumnReference Column="Expr1131" />
<ColumnReference Column="Expr1132" />
<ColumnReference Column="Expr1133" />
<ColumnReference Column="Expr1134" />
<ColumnReference Column="Expr1135" />
<ColumnReference Column="Expr1136" />
<ColumnReference Column="Expr1137" />
<ColumnReference Column="Expr1138" />
<ColumnReference Column="Expr1139" />
<ColumnReference Column="Expr1140" />
<ColumnReference Column="Expr1141" />
<ColumnReference Column="Expr1142" />
<ColumnReference Column="Expr1143" />
<ColumnReference Column="Expr1144" />
<ColumnReference Column="Expr1145" />
<ColumnReference Column="Expr1146" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1146" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1146" />
</ProbeColumn>
<RelOp AvgRowSize="18" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="29" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.405823">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1130" />
<ColumnReference Column="Expr1131" />
<ColumnReference Column="Expr1132" />
<ColumnReference Column="Expr1133" />
<ColumnReference Column="Expr1134" />
<ColumnReference Column="Expr1135" />
<ColumnReference Column="Expr1136" />
<ColumnReference Column="Expr1137" />
<ColumnReference Column="Expr1138" />
<ColumnReference Column="Expr1139" />
<ColumnReference Column="Expr1140" />
<ColumnReference Column="Expr1141" />
<ColumnReference Column="Expr1142" />
<ColumnReference Column="Expr1143" />
<ColumnReference Column="Expr1144" />
<ColumnReference Column="Expr1145" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1145" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1145" />
</ProbeColumn>
<RelOp AvgRowSize="18" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="30" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.402536">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1130" />
<ColumnReference Column="Expr1131" />
<ColumnReference Column="Expr1132" />
<ColumnReference Column="Expr1133" />
<ColumnReference Column="Expr1134" />
<ColumnReference Column="Expr1135" />
<ColumnReference Column="Expr1136" />
<ColumnReference Column="Expr1137" />
<ColumnReference Column="Expr1138" />
<ColumnReference Column="Expr1139" />
<ColumnReference Column="Expr1140" />
<ColumnReference Column="Expr1141" />
<ColumnReference Column="Expr1142" />
<ColumnReference Column="Expr1143" />
<ColumnReference Column="Expr1144" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1144" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1144" />
</ProbeColumn>
<RelOp AvgRowSize="18" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="31" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.372057">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1130" />
<ColumnReference Column="Expr1131" />
<ColumnReference Column="Expr1132" />
<ColumnReference Column="Expr1133" />
<ColumnReference Column="Expr1134" />
<ColumnReference Column="Expr1135" />
<ColumnReference Column="Expr1136" />
<ColumnReference Column="Expr1137" />
<ColumnReference Column="Expr1138" />
<ColumnReference Column="Expr1139" />
<ColumnReference Column="Expr1140" />
<ColumnReference Column="Expr1141" />
<ColumnReference Column="Expr1142" />
<ColumnReference Column="Expr1143" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1143" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1143" />
</ProbeColumn>
<RelOp AvgRowSize="18" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="32" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.36877">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1130" />
<ColumnReference Column="Expr1131" />
<ColumnReference Column="Expr1132" />
<ColumnReference Column="Expr1133" />
<ColumnReference Column="Expr1134" />
<ColumnReference Column="Expr1135" />
<ColumnReference Column="Expr1136" />
<ColumnReference Column="Expr1137" />
<ColumnReference Column="Expr1138" />
<ColumnReference Column="Expr1139" />
<ColumnReference Column="Expr1140" />
<ColumnReference Column="Expr1141" />
<ColumnReference Column="Expr1142" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1142" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1142" />
</ProbeColumn>
<RelOp AvgRowSize="17" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="33" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.341251">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1130" />
<ColumnReference Column="Expr1131" />
<ColumnReference Column="Expr1132" />
<ColumnReference Column="Expr1133" />
<ColumnReference Column="Expr1134" />
<ColumnReference Column="Expr1135" />
<ColumnReference Column="Expr1136" />
<ColumnReference Column="Expr1137" />
<ColumnReference Column="Expr1138" />
<ColumnReference Column="Expr1139" />
<ColumnReference Column="Expr1140" />
<ColumnReference Column="Expr1141" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1141" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1141" />
</ProbeColumn>
<RelOp AvgRowSize="16" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="34" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.337963">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1130" />
<ColumnReference Column="Expr1131" />
<ColumnReference Column="Expr1132" />
<ColumnReference Column="Expr1133" />
<ColumnReference Column="Expr1134" />
<ColumnReference Column="Expr1135" />
<ColumnReference Column="Expr1136" />
<ColumnReference Column="Expr1137" />
<ColumnReference Column="Expr1138" />
<ColumnReference Column="Expr1139" />
<ColumnReference Column="Expr1140" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1140" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1140" />
</ProbeColumn>
<RelOp AvgRowSize="16" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="35" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.310219">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1130" />
<ColumnReference Column="Expr1131" />
<ColumnReference Column="Expr1132" />
<ColumnReference Column="Expr1133" />
<ColumnReference Column="Expr1134" />
<ColumnReference Column="Expr1135" />
<ColumnReference Column="Expr1136" />
<ColumnReference Column="Expr1137" />
<ColumnReference Column="Expr1138" />
<ColumnReference Column="Expr1139" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1139" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1139" />
</ProbeColumn>
<RelOp AvgRowSize="16" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="36" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.306932">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1130" />
<ColumnReference Column="Expr1131" />
<ColumnReference Column="Expr1132" />
<ColumnReference Column="Expr1133" />
<ColumnReference Column="Expr1134" />
<ColumnReference Column="Expr1135" />
<ColumnReference Column="Expr1136" />
<ColumnReference Column="Expr1137" />
<ColumnReference Column="Expr1138" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1138" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1138" />
</ProbeColumn>
<RelOp AvgRowSize="16" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="37" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.279487">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1130" />
<ColumnReference Column="Expr1131" />
<ColumnReference Column="Expr1132" />
<ColumnReference Column="Expr1133" />
<ColumnReference Column="Expr1134" />
<ColumnReference Column="Expr1135" />
<ColumnReference Column="Expr1136" />
<ColumnReference Column="Expr1137" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1137" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1137" />
</ProbeColumn>
<RelOp AvgRowSize="16" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="38" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.2762">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1130" />
<ColumnReference Column="Expr1131" />
<ColumnReference Column="Expr1132" />
<ColumnReference Column="Expr1133" />
<ColumnReference Column="Expr1134" />
<ColumnReference Column="Expr1135" />
<ColumnReference Column="Expr1136" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1136" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1136" />
</ProbeColumn>
<RelOp AvgRowSize="16" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="39" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.248868">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1130" />
<ColumnReference Column="Expr1131" />
<ColumnReference Column="Expr1132" />
<ColumnReference Column="Expr1133" />
<ColumnReference Column="Expr1134" />
<ColumnReference Column="Expr1135" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1135" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1135" />
</ProbeColumn>
<RelOp AvgRowSize="16" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="40" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.24558">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1130" />
<ColumnReference Column="Expr1131" />
<ColumnReference Column="Expr1132" />
<ColumnReference Column="Expr1133" />
<ColumnReference Column="Expr1134" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1134" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1134" />
</ProbeColumn>
<RelOp AvgRowSize="15" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="41" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.21675">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1130" />
<ColumnReference Column="Expr1131" />
<ColumnReference Column="Expr1132" />
<ColumnReference Column="Expr1133" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1133" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1133" />
</ProbeColumn>
<RelOp AvgRowSize="14" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="42" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.213463">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1130" />
<ColumnReference Column="Expr1131" />
<ColumnReference Column="Expr1132" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1132" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1132" />
</ProbeColumn>
<RelOp AvgRowSize="14" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="43" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.186018">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1130" />
<ColumnReference Column="Expr1131" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1131" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1131" />
</ProbeColumn>
<RelOp AvgRowSize="14" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="44" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.155727">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1130" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1130" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1130" />
</ProbeColumn>
<RelOp AvgRowSize="14" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="45" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.15244">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1129" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1129" />
</ProbeColumn>
<RelOp AvgRowSize="14" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="46" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.124546">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
<ColumnReference Column="Expr1128" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1128" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1128" />
</ProbeColumn>
<RelOp AvgRowSize="14" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="47" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.121259">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
<ColumnReference Column="Expr1127" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1127" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1127" />
</ProbeColumn>
<RelOp AvgRowSize="14" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="48" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0885334">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1126" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1126" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1126" />
</ProbeColumn>
<RelOp AvgRowSize="13" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="49" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0852461">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1125" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1125" />
</ProbeColumn>
<RelOp AvgRowSize="12" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="50" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0819588">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
<ColumnReference Column="Expr1124" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1124" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1124" />
</ProbeColumn>
<RelOp AvgRowSize="12" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="51" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0786716">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
<ColumnReference Column="Expr1123" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1123" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1123" />
</ProbeColumn>
<RelOp AvgRowSize="12" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="52" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0753843">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1122" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1122" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1122" />
</ProbeColumn>
<RelOp AvgRowSize="12" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="53" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.072097">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
<ColumnReference Column="Expr1121" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1121" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1121" />
</ProbeColumn>
<RelOp AvgRowSize="12" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="54" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0688097">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
<ColumnReference Column="Expr1120" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1120" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1120" />
</ProbeColumn>
<RelOp AvgRowSize="12" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="55" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0655224">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1119" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1119" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1119" />
</ProbeColumn>
<RelOp AvgRowSize="12" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="56" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0352315">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
<ColumnReference Column="Expr1118" />
</OutputList>
<NestedLoops Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1118" />
</DefinedValue>
</DefinedValues>
<OuterReferences>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OuterReferences>
<ProbeColumn>
<ColumnReference Column="Expr1118" />
</ProbeColumn>
<RelOp AvgRowSize="11" EstimateCPU="3.36523E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Eager Spool" NodeId="57" Parallel="false" PhysicalOp="Table Spool" EstimatedTotalSubtreeCost="0.0078618">
<OutputList>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</OutputList>
<Spool PrimaryNodeId="2" />
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.760761" EstimateIO="23.9216" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="1037.02" EstimatedRowsRead="691458" LogicalOp="Clustered Index Scan" NodeId="58" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0270455" TableCardinality="691458">
<OutputList />
<IndexScan Ordered="false" ForcedIndex="true" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Index="[IX_CustomerID]" IndexKind="Clustered" Storage="RowStore" />
<Predicate>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Facilities].[SurfaceCleanerID]=[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Column="SurfaceCleanerID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.760761" EstimateIO="23.9216" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="924.989" EstimatedRowsRead="691458" LogicalOp="Clustered Index Scan" NodeId="59" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0299279" TableCardinality="691458">
<OutputList />
<IndexScan Ordered="false" ForcedIndex="true" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Index="[IX_CustomerID]" IndexKind="Clustered" Storage="RowStore" />
<Predicate>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Facilities].[YellowAlgID]=[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Column="YellowAlgID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="9" EstimateCPU="0.000163051" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="5.50095" EstimatedRowsRead="5.50095" LogicalOp="Index Seek" NodeId="60" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="19360">
<OutputList />
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="true" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Index="[IX_FoamyWaterID]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Column="FoamyWaterID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="9" EstimateCPU="0.000171241" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="12.9463" EstimatedRowsRead="12.9463" LogicalOp="Index Seek" NodeId="61" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="19360">
<OutputList />
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="true" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Index="[IX_StabilizerID]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Column="StabilizerID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="9" EstimateCPU="0.000163028" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="5.48004" EstimatedRowsRead="5.48004" LogicalOp="Index Seek" NodeId="62" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="19360">
<OutputList />
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="true" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Index="[IX_PhUpID]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Column="PhUpID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="9" EstimateCPU="0.000163057" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="5.50621" EstimatedRowsRead="5.50621" LogicalOp="Index Seek" NodeId="63" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="19360">
<OutputList />
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="true" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Index="[IX_EnzymeID]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Column="EnzymeID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="9" EstimateCPU="0.000163049" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="5.49921" EstimatedRowsRead="5.49921" LogicalOp="Index Seek" NodeId="64" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="19360">
<OutputList />
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="true" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Index="[IX_BorateID]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Column="BorateID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="9" EstimateCPU="0.000162814" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="5.28576" EstimatedRowsRead="5.28576" LogicalOp="Index Seek" NodeId="65" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="19360">
<OutputList />
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="true" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Index="[IX_YellowAlgID]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Column="YellowAlgID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="9" EstimateCPU="0.000158146" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="1.04187" EstimatedRowsRead="1.04187" LogicalOp="Index Seek" NodeId="66" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="19360">
<OutputList />
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="true" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Index="[IX_SanitizerID]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Column="SanitizerID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.760761" EstimateIO="23.9216" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="848.592" EstimatedRowsRead="691458" LogicalOp="Clustered Index Scan" NodeId="67" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0323299" TableCardinality="691458">
<OutputList />
<IndexScan Ordered="false" ForcedIndex="true" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Index="[IX_CustomerID]" IndexKind="Clustered" Storage="RowStore" />
<Predicate>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Facilities].[AlkalinityDownID]=[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Column="AlkalinityDownID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="9" EstimateCPU="0.000163059" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="5.50796" EstimatedRowsRead="5.50796" LogicalOp="Index Seek" NodeId="68" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="19360">
<OutputList />
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="true" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Index="[IX_CoverCleanerID]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Column="CoverCleanerID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.760761" EstimateIO="23.9216" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="1014.96" EstimatedRowsRead="691458" LogicalOp="Clustered Index Scan" NodeId="69" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0275629" TableCardinality="691458">
<OutputList />
<IndexScan Ordered="false" ForcedIndex="true" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Index="[IX_CustomerID]" IndexKind="Clustered" Storage="RowStore" />
<Predicate>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Facilities].[AlkalinityUpID]=[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Column="AlkalinityUpID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="9" EstimateCPU="0.000162827" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="5.29709" EstimatedRowsRead="5.29709" LogicalOp="Index Seek" NodeId="70" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="19360">
<OutputList />
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="true" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Index="[IX_BlackAlgID]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Column="BlackAlgID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.760761" EstimateIO="23.9216" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="924.989" EstimatedRowsRead="691458" LogicalOp="Clustered Index Scan" NodeId="71" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0299279" TableCardinality="691458">
<OutputList />
<IndexScan Ordered="false" ForcedIndex="true" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Index="[IX_CustomerID]" IndexKind="Clustered" Storage="RowStore" />
<Predicate>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Facilities].[BlackAlgID]=[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Column="BlackAlgID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.760761" EstimateIO="23.9216" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="1033.81" EstimatedRowsRead="691458" LogicalOp="Clustered Index Scan" NodeId="72" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0271194" TableCardinality="691458">
<OutputList />
<IndexScan Ordered="false" ForcedIndex="true" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Index="[IX_CustomerID]" IndexKind="Clustered" Storage="RowStore" />
<Predicate>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Facilities].[BorateID]=[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Column="BorateID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="9" EstimateCPU="0.000162664" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="5.14885" EstimatedRowsRead="5.14885" LogicalOp="Index Seek" NodeId="73" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="19360">
<OutputList />
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="true" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Index="[IX_PhDownID]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Column="PhDownID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.760761" EstimateIO="23.9216" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="977.807" EstimatedRowsRead="691458" LogicalOp="Clustered Index Scan" NodeId="74" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0284867" TableCardinality="691458">
<OutputList />
<IndexScan Ordered="false" ForcedIndex="true" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Index="[IX_CustomerID]" IndexKind="Clustered" Storage="RowStore" />
<Predicate>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Facilities].[CloudyWaterID]=[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Column="CloudyWaterID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="9" EstimateCPU="0.000163038" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="5.48873" EstimatedRowsRead="5.48873" LogicalOp="Index Seek" NodeId="75" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="19360">
<OutputList />
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="true" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Index="[IX_HardnessUpID]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Column="HardnessUpID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.760761" EstimateIO="23.9216" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="1038.63" EstimatedRowsRead="691458" LogicalOp="Clustered Index Scan" NodeId="76" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0270086" TableCardinality="691458">
<OutputList />
<IndexScan Ordered="false" ForcedIndex="true" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Index="[IX_CustomerID]" IndexKind="Clustered" Storage="RowStore" />
<Predicate>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Facilities].[CoverCleanerID]=[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Column="CoverCleanerID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="9" EstimateCPU="0.000163036" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="5.48699" EstimatedRowsRead="5.48699" LogicalOp="Index Seek" NodeId="77" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="19360">
<OutputList />
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="true" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Index="[IX_PhosphateID]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Column="PhosphateID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.760761" EstimateIO="23.9216" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="1033.81" EstimatedRowsRead="691458" LogicalOp="Clustered Index Scan" NodeId="78" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0271194" TableCardinality="691458">
<OutputList />
<IndexScan Ordered="false" ForcedIndex="true" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Index="[IX_CustomerID]" IndexKind="Clustered" Storage="RowStore" />
<Predicate>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Facilities].[EnzymeID]=[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Column="EnzymeID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="9" EstimateCPU="0.000162956" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="5.41484" EstimatedRowsRead="5.41484" LogicalOp="Index Seek" NodeId="79" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="19360">
<OutputList />
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="true" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Index="[IX_CloudyWaterID]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Column="CloudyWaterID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.760761" EstimateIO="23.9216" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="1021.17" EstimatedRowsRead="691458" LogicalOp="Clustered Index Scan" NodeId="80" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0274151" TableCardinality="691458">
<OutputList />
<IndexScan Ordered="false" ForcedIndex="true" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Index="[IX_CustomerID]" IndexKind="Clustered" Storage="RowStore" />
<Predicate>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Facilities].[FilterCleanerID]=[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Column="FilterCleanerID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="9" EstimateCPU="0.000163032" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="5.48351" EstimatedRowsRead="5.48351" LogicalOp="Index Seek" NodeId="81" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="19360">
<OutputList />
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="true" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Index="[IX_AlkalinityUpID]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Column="AlkalinityUpID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.760761" EstimateIO="23.9216" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="1030.62" EstimatedRowsRead="691458" LogicalOp="Clustered Index Scan" NodeId="82" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0271933" TableCardinality="691458">
<OutputList />
<IndexScan Ordered="false" ForcedIndex="true" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Index="[IX_CustomerID]" IndexKind="Clustered" Storage="RowStore" />
<Predicate>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Facilities].[FoamyWaterID]=[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Column="FoamyWaterID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="9" EstimateCPU="0.000163036" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="5.48699" EstimatedRowsRead="5.48699" LogicalOp="Index Seek" NodeId="83" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="19360">
<OutputList />
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="true" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Index="[IX_FilterCleanerID]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Column="FilterCleanerID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.760761" EstimateIO="23.9216" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="918.627" EstimatedRowsRead="691458" LogicalOp="Clustered Index Scan" NodeId="84" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0301127" TableCardinality="691458">
<OutputList />
<IndexScan Ordered="false" ForcedIndex="true" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Index="[IX_CustomerID]" IndexKind="Clustered" Storage="RowStore" />
<Predicate>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Facilities].[GreenAlgID]=[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Column="GreenAlgID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="9" EstimateCPU="0.000163038" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="5.48873" EstimatedRowsRead="5.48873" LogicalOp="Index Seek" NodeId="85" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="19360">
<OutputList />
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="true" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Index="[IX_StainRemoverID]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Column="StainRemoverID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.760761" EstimateIO="23.9216" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="1019.61" EstimatedRowsRead="691458" LogicalOp="Clustered Index Scan" NodeId="86" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.027452" TableCardinality="691458">
<OutputList />
<IndexScan Ordered="false" ForcedIndex="true" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Index="[IX_CustomerID]" IndexKind="Clustered" Storage="RowStore" />
<Predicate>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Facilities].[HardnessUpID]=[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Column="HardnessUpID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="9" EstimateCPU="0.000159376" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="2.16025" EstimatedRowsRead="2.16025" LogicalOp="Index Seek" NodeId="87" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="19360">
<OutputList />
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="true" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Index="[IX_ShockID]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Column="ShockID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.760761" EstimateIO="23.9216" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="1005.79" EstimatedRowsRead="691458" LogicalOp="Clustered Index Scan" NodeId="88" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0277846" TableCardinality="691458">
<OutputList />
<IndexScan Ordered="false" ForcedIndex="true" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Index="[IX_CustomerID]" IndexKind="Clustered" Storage="RowStore" />
<Predicate>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Facilities].[MetalID]=[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Column="MetalID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="9" EstimateCPU="0.000162984" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="5.44039" EstimatedRowsRead="5.44039" LogicalOp="Index Seek" NodeId="89" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="19360">
<OutputList />
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="true" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Index="[IX_MetalID]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Column="MetalID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.760761" EstimateIO="23.9216" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="834.802" EstimatedRowsRead="691458" LogicalOp="Clustered Index Scan" NodeId="90" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0328103" TableCardinality="691458">
<OutputList />
<IndexScan Ordered="false" ForcedIndex="true" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Index="[IX_CustomerID]" IndexKind="Clustered" Storage="RowStore" />
<Predicate>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Facilities].[PhDownID]=[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Column="PhDownID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="9" EstimateCPU="0.000163061" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="5.50972" EstimatedRowsRead="5.50972" LogicalOp="Index Seek" NodeId="91" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="19360">
<OutputList />
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="true" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Index="[IX_SurfaceCleanerID]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Column="SurfaceCleanerID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.760761" EstimateIO="23.9216" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="1010.35" EstimatedRowsRead="691458" LogicalOp="Clustered Index Scan" NodeId="92" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0276737" TableCardinality="691458">
<OutputList />
<IndexScan Ordered="false" ForcedIndex="true" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Index="[IX_CustomerID]" IndexKind="Clustered" Storage="RowStore" />
<Predicate>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Facilities].[PhosphateID]=[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Column="PhosphateID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="9" EstimateCPU="0.000162825" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="5.29547" EstimatedRowsRead="5.29547" LogicalOp="Index Seek" NodeId="93" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="19360">
<OutputList />
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="true" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Index="[IX_GreenAlgID]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Column="GreenAlgID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.760761" EstimateIO="23.9216" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="1019.61" EstimatedRowsRead="691458" LogicalOp="Clustered Index Scan" NodeId="94" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.027452" TableCardinality="691458">
<OutputList />
<IndexScan Ordered="false" ForcedIndex="true" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Index="[IX_CustomerID]" IndexKind="Clustered" Storage="RowStore" />
<Predicate>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Facilities].[PhUpID]=[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Column="PhUpID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="9" EstimateCPU="0.000162662" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="5.14732" EstimatedRowsRead="5.14732" LogicalOp="Index Seek" NodeId="95" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="19360">
<OutputList />
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="true" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Index="[IX_AlkalinityDownID]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Profile]" Column="AlkalinityDownID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.760761" EstimateIO="23.9216" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="522.16" EstimatedRowsRead="691458" LogicalOp="Clustered Index Scan" NodeId="96" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.050511" TableCardinality="691458">
<OutputList />
<IndexScan Ordered="false" ForcedIndex="true" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Index="[IX_CustomerID]" IndexKind="Clustered" Storage="RowStore" />
<Predicate>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Facilities].[SanitizerID]=[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Column="SanitizerID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.760761" EstimateIO="23.9216" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="694.222" EstimatedRowsRead="691458" LogicalOp="Clustered Index Scan" NodeId="97" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0387968" TableCardinality="691458">
<OutputList />
<IndexScan Ordered="false" ForcedIndex="true" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Index="[IX_CustomerID]" IndexKind="Clustered" Storage="RowStore" />
<Predicate>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Facilities].[ShockID]=[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Column="ShockID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.760761" EstimateIO="23.9216" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="1230.84" EstimatedRowsRead="691458" LogicalOp="Clustered Index Scan" NodeId="98" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0232981" TableCardinality="691458">
<OutputList />
<IndexScan Ordered="false" ForcedIndex="true" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Index="[IX_CustomerID]" IndexKind="Clustered" Storage="RowStore" />
<Predicate>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Facilities].[StabilizerID]=[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Column="StabilizerID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.760761" EstimateIO="23.9216" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimateRowsWithoutRowGoal="1014.96" EstimatedRowsRead="691458" LogicalOp="Clustered Index Scan" NodeId="99" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0275629" TableCardinality="691458">
<OutputList />
<IndexScan Ordered="false" ForcedIndex="true" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues />
<Object Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Index="[IX_CustomerID]" IndexKind="Clustered" Storage="RowStore" />
<Predicate>
<ScalarOperator ScalarString="[DataMateWeb].[dbo].[Facilities].[StainRemoverID]=[DataMateWeb].[dbo].[Chemical].[ChemicalID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Facilities]" Column="StainRemoverID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DataMateWeb]" Schema="[dbo]" Table="[Chemical]" Column="ChemicalID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="CASE WHEN NOT [Expr1118] IS NULL THEN (0) ELSE CASE WHEN NOT [Expr1119] IS NULL THEN (1) ELSE CASE WHEN NOT [Expr1120] IS NULL THEN (2) ELSE CASE WHEN NOT [Expr1121] IS NULL THEN (3) ELSE CASE WHEN NOT [Expr1122] IS NULL THEN (4) ELSE CASE WHEN NOT [Expr1123] IS NULL THEN (5) ELSE CASE WHEN NOT [Expr1124] IS NULL THEN (6) ELSE CASE WHEN NOT [Expr1125] IS NULL THEN (7) ELSE CASE WHEN NOT [Expr1126] IS NULL THEN (8) ELSE CASE WHEN NOT [Expr1127] IS NULL THEN (9) ELSE CASE WHEN NOT [Expr1128] IS NULL THEN (10) ELSE CASE WHEN NOT [Expr1129] IS NULL THEN (11) ELSE CASE WHEN NOT [Expr1130] IS NULL THEN (12) ELSE CASE WHEN NOT [Expr1131] IS NULL THEN (13) ELSE CASE WHEN NOT [Expr1132] IS NULL THEN (14) ELSE CASE WHEN NOT [Expr1133] IS NULL THEN (15) ELSE CASE WHEN NOT [Expr1134] IS NULL THEN (16) ELSE CASE WHEN NOT [Expr1135] IS NULL THEN (17) ELSE CASE WHEN NOT [Expr1136] IS NULL THEN (18) ELSE CASE WHEN NOT [Expr1137] IS NULL THEN (19) ELSE CASE WHEN NOT [Expr1138] IS NULL THEN (20) ELSE CASE WHEN NOT [Expr1139] IS NULL THEN (21) ELSE CASE WHEN NOT [Expr1140] IS NULL THEN (22) ELSE CASE WHEN NOT [Expr1141] IS NULL THEN (23) ELSE CASE WHEN NOT [Expr1142] IS NULL THEN (24) ELSE CASE WHEN NOT [Expr1143] IS NULL THEN (25) ELSE CASE WHEN NOT [Expr1144] IS NULL THEN (26) ELSE CASE WHEN NOT [Expr1145] IS NULL THEN (27) ELSE CASE WHEN NOT [Expr1146] IS NULL THEN (28) ELSE CASE WHEN NOT [Expr1147] IS NULL THEN (29) ELSE CASE WHEN NOT [Expr1148] IS NULL THEN (30) ELSE CASE WHEN NOT [Expr1149] IS NULL THEN (31) ELSE CASE WHEN NOT [Expr1150] IS NULL THEN (32) ELSE CASE WHEN NOT [Expr1151] IS NULL THEN (33) ELSE CASE WHEN NOT [Expr1152] IS NULL THEN (34) ELSE CASE WHEN NOT [Expr1153] IS NULL THEN (35) ELSE CASE WHEN NOT [Expr1154] IS NULL THEN (36) ELSE CASE WHEN NOT [Expr1155] IS NULL THEN (37) ELSE CASE WHEN NOT [Expr1156] IS NULL THEN (38) ELSE CASE WHEN NOT [Expr1157] IS NULL THEN (39) ELSE CASE WHEN NOT [Expr1158] IS NULL THEN (40) ELSE CASE WHEN NOT [Expr1159] IS NULL THEN (41) ELSE NULL END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END">
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1118" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1119" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1120" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(2)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1121" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(3)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1122" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(4)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1123" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(5)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1124" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(6)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1125" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(7)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1126" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(8)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1127" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(9)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1128" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(10)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1129" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(11)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1130" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(12)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1131" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(13)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1132" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(14)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1133" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(15)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1134" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(16)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1135" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(17)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1136" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(18)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1137" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(19)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1138" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(20)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1139" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(21)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1140" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(22)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1141" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(23)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1142" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(24)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1143" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(25)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1144" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(26)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1145" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(27)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1146" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(28)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1147" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(29)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1148" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(30)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1149" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(31)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1150" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(32)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1151" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(33)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1152" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(34)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1153" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(35)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1154" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(36)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1155" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(37)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1156" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(38)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1157" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(39)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1158" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(40)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Logical Operation="IS NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1159" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(41)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Predicate>
</Assert>
</RelOp>
</Sequence>
</RelOp>
<ParameterList>
<ColumnReference Column="@1" ParameterDataType="tinyint" ParameterCompiledValue="(0)" />
</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