﻿<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.0" Build="9.0.9067.0">
  <BatchSequence>
    <Batch>
      <Statements>
        <StmtSimple StatementText="SELECT ContactName, OrderDate&#xD;&#xA;FROM Customers inner join Orders &#xD;&#xA;ON Orders.CustomerID = Customers.CustomerID&#xD;&#xA;WHERE Orders.ShipCountry = 'Canada'&#xD;&#xA;" StatementId="1" StatementCompId="1" StatementType="SELECT" StatementSubTreeCost="0.0308059" StatementEstRows="43" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound">
          <StatementSetOptions QUOTED_IDENTIFIER="false" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="false" ANSI_NULLS="false" ANSI_PADDING="false" ANSI_WARNINGS="false" NUMERIC_ROUNDABORT="false" />
          <QueryPlan CachedPlanSize="24" CompileTime="1797" CompileCPU="1756" CompileMemory="328">
            <RelOp NodeId="0" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="43" EstimateIO="0" EstimateCPU="0.00017974" AvgRowSize="34" EstimatedTotalSubtreeCost="0.0308059" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
              <OutputList>
                <ColumnReference Database="[nwind]" Schema="[dbo]" Table="[Customers]" Column="ContactName" />
                <ColumnReference Database="[nwind]" Schema="[dbo]" Table="[Orders]" Column="OrderDate" />
              </OutputList>
              <NestedLoops Optimized="0">
                <OuterReferences>
                  <ColumnReference Database="[nwind]" Schema="[dbo]" Table="[Orders]" Column="CustomerID" />
                </OuterReferences>
                <RelOp NodeId="1" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="43" EstimateIO="0.0157176" EstimateCPU="0.0013428" AvgRowSize="31" EstimatedTotalSubtreeCost="0.0170604" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                  <OutputList>
                    <ColumnReference Database="[nwind]" Schema="[dbo]" Table="[Orders]" Column="CustomerID" />
                    <ColumnReference Database="[nwind]" Schema="[dbo]" Table="[Orders]" Column="OrderDate" />
                  </OutputList>
                  <IndexScan Ordered="0" ForcedIndex="0" NoExpandHint="0">
                    <DefinedValues>
                      <DefinedValue>
                        <ColumnReference Database="[nwind]" Schema="[dbo]" Table="[Orders]" Column="CustomerID" />
                      </DefinedValue>
                      <DefinedValue>
                        <ColumnReference Database="[nwind]" Schema="[dbo]" Table="[Orders]" Column="OrderDate" />
                      </DefinedValue>
                    </DefinedValues>
                    <Object Database="[nwind]" Schema="[dbo]" Table="[Orders]" Index="[aaaaa_PrimaryKey]" />
                    <Predicate>
                      <ScalarOperator ScalarString="[nwind].[dbo].[Orders].[ShipCountry]='Canada'">
                        <Compare CompareOp="EQ">
                          <ScalarOperator>
                            <Identifier>
                              <ColumnReference Database="[nwind]" Schema="[dbo]" Table="[Orders]" Column="ShipCountry" />
                            </Identifier>
                          </ScalarOperator>
                          <ScalarOperator>
                            <Const ConstValue="'Canada'" />
                          </ScalarOperator>
                        </Compare>
                      </ScalarOperator>
                    </Predicate>
                  </IndexScan>
                </RelOp>
                <RelOp NodeId="2" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="26" EstimatedTotalSubtreeCost="0.0130483" Parallel="0" EstimateRebinds="41.7476" EstimateRewinds="0.252379">
                  <OutputList>
                    <ColumnReference Database="[nwind]" Schema="[dbo]" Table="[Customers]" Column="ContactName" />
                  </OutputList>
                  <IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" NoExpandHint="0">
                    <DefinedValues>
                      <DefinedValue>
                        <ColumnReference Database="[nwind]" Schema="[dbo]" Table="[Customers]" Column="ContactName" />
                      </DefinedValue>
                    </DefinedValues>
                    <Object Database="[nwind]" Schema="[dbo]" Table="[Customers]" Index="[aaaaa_PrimaryKey]" />
                    <SeekPredicates>
                      <SeekPredicate>
                        <Prefix ScanType="EQ">
                          <RangeColumns>
                            <ColumnReference Database="[nwind]" Schema="[dbo]" Table="[Customers]" Column="CustomerID" />
                          </RangeColumns>
                          <RangeExpressions>
                            <ScalarOperator ScalarString="[nwind].[dbo].[Orders].[CustomerID]">
                              <Identifier>
                                <ColumnReference Database="[nwind]" Schema="[dbo]" Table="[Orders]" Column="CustomerID" />
                              </Identifier>
                            </ScalarOperator>
                          </RangeExpressions>
                        </Prefix>
                      </SeekPredicate>
                    </SeekPredicates>
                  </IndexScan>
                </RelOp>
              </NestedLoops>
            </RelOp>
          </QueryPlan>
        </StmtSimple>
      </Statements>
    </Batch>
  </BatchSequence>
</ShowPlanXML>