<?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.1" Build="10.0.2531.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
  <BatchSequence>
    <Batch>
      <Statements>
        <StmtSimple StatementCompId="1" StatementEstRows="1" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" StatementSubTreeCost="0.00986896" StatementText="select T1.*, T2N.*&#xD;&#xA;from T1&#xD;&#xA;inner join (select T2.*&#xD;&#xA;            from T2&#xD;&#xA;                    inner join (select ID, MAX(DatumUnosa) as MaxDT&#xD;&#xA;                    from T2&#xD;&#xA;                    group by ID) &#xD;&#xA;                    T2L on T2L.ID = T2.ID and T2L.MaxDT = T2.DatumUnosa&#xD;&#xA;            ) T2N on T2N.ID = T1.ID&#xD;&#xA;&#xD;&#xA;&#xD;" StatementType="SELECT" QueryHash="0x48F007401DF36AAB" QueryPlanHash="0x438F4F3D7C388AB6">
          <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
          <QueryPlan DegreeOfParallelism="1" CachedPlanSize="32" CompileTime="3" CompileCPU="3" CompileMemory="336">
            <RelOp AvgRowSize="43" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Inner Join" NodeId="0" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00986896">
              <OutputList>
                <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T1]" Column="ID" />
                <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T1]" Column="Naziv" />
                <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="ID" />
                <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="Atribut" />
                <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="DatumUnosa" />
              </OutputList>
              <RunTimeInformation>
                <RunTimeCountersPerThread Thread="0" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
              </RunTimeInformation>
              <NestedLoops Optimized="false">
                <OuterReferences>
                  <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="ID" />
                </OuterReferences>
                <RelOp AvgRowSize="31" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Inner Join" NodeId="1" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00658168">
                  <OutputList>
                    <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="ID" />
                    <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="Atribut" />
                    <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="DatumUnosa" />
                    <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="ID" />
                  </OutputList>
                  <RunTimeInformation>
                    <RunTimeCountersPerThread Thread="0" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
                  </RunTimeInformation>
                  <NestedLoops Optimized="false">
                    <OuterReferences>
                      <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="ID" />
                      <ColumnReference Column="Expr1009" />
                    </OuterReferences>
                    <RelOp AvgRowSize="19" EstimateCPU="4.7E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Aggregate" NodeId="2" Parallel="false" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="0.0032944">
                      <OutputList>
                        <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="ID" />
                        <ColumnReference Column="Expr1009" />
                      </OutputList>
                      <RunTimeInformation>
                        <RunTimeCountersPerThread Thread="0" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
                      </RunTimeInformation>
                      <StreamAggregate>
                        <DefinedValues>
                          <DefinedValue>
                            <ColumnReference Column="Expr1009" />
                            <ScalarOperator ScalarString="MAX([Sample].[dbo].[T2].[DatumUnosa])">
                              <Aggregate AggType="MAX" Distinct="false">
                                <ScalarOperator>
                                  <Identifier>
                                    <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="DatumUnosa" />
                                  </Identifier>
                                </ScalarOperator>
                              </Aggregate>
                            </ScalarOperator>
                          </DefinedValue>
                        </DefinedValues>
                        <GroupBy>
                          <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="ID" />
                        </GroupBy>
                        <RelOp AvgRowSize="19" EstimateCPU="0.0001647" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="7" LogicalOp="Clustered Index Scan" NodeId="3" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0032897" TableCardinality="7">
                          <OutputList>
                            <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="ID" />
                            <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="DatumUnosa" />
                          </OutputList>
                          <RunTimeInformation>
                            <RunTimeCountersPerThread Thread="0" ActualRows="7" ActualEndOfScans="1" ActualExecutions="1" />
                          </RunTimeInformation>
                          <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
                            <DefinedValues>
                              <DefinedValue>
                                <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="ID" />
                              </DefinedValue>
                              <DefinedValue>
                                <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="DatumUnosa" />
                              </DefinedValue>
                            </DefinedValues>
                            <Object Database="[Sample]" Schema="[dbo]" Table="[T2]" Index="[PK_T2]" TableReferenceId="2" IndexKind="Clustered" />
                          </IndexScan>
                        </RelOp>
                      </StreamAggregate>
                    </RelOp>
                    <RelOp AvgRowSize="27" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="7" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="7">
                      <OutputList>
                        <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="ID" />
                        <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="Atribut" />
                        <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="DatumUnosa" />
                      </OutputList>
                      <RunTimeInformation>
                        <RunTimeCountersPerThread Thread="0" ActualRows="3" ActualEndOfScans="3" ActualExecutions="3" />
                      </RunTimeInformation>
                      <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
                        <DefinedValues>
                          <DefinedValue>
                            <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="ID" />
                          </DefinedValue>
                          <DefinedValue>
                            <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="Atribut" />
                          </DefinedValue>
                          <DefinedValue>
                            <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="DatumUnosa" />
                          </DefinedValue>
                        </DefinedValues>
                        <Object Database="[Sample]" Schema="[dbo]" Table="[T2]" Index="[IX_T2]" TableReferenceId="1" IndexKind="NonClustered" />
                        <SeekPredicates>
                          <SeekPredicateNew>
                            <SeekKeys>
                              <Prefix ScanType="EQ">
                                <RangeColumns>
                                  <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="DatumUnosa" />
                                  <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="ID" />
                                </RangeColumns>
                                <RangeExpressions>
                                  <ScalarOperator ScalarString="[Expr1009]">
                                    <Identifier>
                                      <ColumnReference Column="Expr1009" />
                                    </Identifier>
                                  </ScalarOperator>
                                  <ScalarOperator ScalarString="[Sample].[dbo].[T2].[ID]">
                                    <Identifier>
                                      <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="ID" />
                                    </Identifier>
                                  </ScalarOperator>
                                </RangeExpressions>
                              </Prefix>
                            </SeekKeys>
                          </SeekPredicateNew>
                        </SeekPredicates>
                      </IndexScan>
                    </RelOp>
                  </NestedLoops>
                </RelOp>
                <RelOp AvgRowSize="25" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="8" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="3">
                  <OutputList>
                    <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T1]" Column="ID" />
                    <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T1]" Column="Naziv" />
                  </OutputList>
                  <RunTimeInformation>
                    <RunTimeCountersPerThread Thread="0" ActualRows="3" ActualEndOfScans="0" ActualExecutions="3" />
                  </RunTimeInformation>
                  <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
                    <DefinedValues>
                      <DefinedValue>
                        <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T1]" Column="ID" />
                      </DefinedValue>
                      <DefinedValue>
                        <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T1]" Column="Naziv" />
                      </DefinedValue>
                    </DefinedValues>
                    <Object Database="[Sample]" Schema="[dbo]" Table="[T1]" Index="[PK_T1]" IndexKind="Clustered" />
                    <SeekPredicates>
                      <SeekPredicateNew>
                        <SeekKeys>
                          <Prefix ScanType="EQ">
                            <RangeColumns>
                              <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T1]" Column="ID" />
                            </RangeColumns>
                            <RangeExpressions>
                              <ScalarOperator ScalarString="[Sample].[dbo].[T2].[ID]">
                                <Identifier>
                                  <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="ID" />
                                </Identifier>
                              </ScalarOperator>
                            </RangeExpressions>
                          </Prefix>
                        </SeekKeys>
                      </SeekPredicateNew>
                    </SeekPredicates>
                  </IndexScan>
                </RelOp>
              </NestedLoops>
            </RelOp>
          </QueryPlan>
        </StmtSimple>
      </Statements>
    </Batch>
    <Batch>
      <Statements>
        <StmtSimple StatementCompId="2" StatementEstRows="3" StatementId="2" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" StatementSubTreeCost="0.00692762" StatementText="SELECT  t1.*, a.* FROM  t1 &#xD;&#xA; OUTER APPLY (SELECT TOP (1) * FROM  t2 WHERE t2.id=t1.id ORDER BY t2.DatumUnosa DESC) a" StatementType="SELECT" QueryHash="0xC979F202A6DEEC45" QueryPlanHash="0xDC1CEB5125D6D662">
          <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
          <QueryPlan DegreeOfParallelism="1" CachedPlanSize="24" CompileTime="2" CompileCPU="2" CompileMemory="200">
            <RelOp AvgRowSize="64" EstimateCPU="1.254E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="3" LogicalOp="Left Outer Join" NodeId="0" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00692762">
              <OutputList>
                <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T1]" Column="ID" />
                <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T1]" Column="Naziv" />
                <ColumnReference Column="Expr1006" />
                <ColumnReference Column="Expr1007" />
                <ColumnReference Column="Expr1008" />
              </OutputList>
              <RunTimeInformation>
                <RunTimeCountersPerThread Thread="0" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
              </RunTimeInformation>
              <NestedLoops Optimized="false">
                <OuterReferences>
                  <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T1]" Column="ID" />
                </OuterReferences>
                <RelOp AvgRowSize="25" EstimateCPU="0.0001603" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="3" LogicalOp="Clustered Index Scan" NodeId="1" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0032853" TableCardinality="3">
                  <OutputList>
                    <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T1]" Column="ID" />
                    <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T1]" Column="Naziv" />
                  </OutputList>
                  <RunTimeInformation>
                    <RunTimeCountersPerThread Thread="0" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
                  </RunTimeInformation>
                  <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
                    <DefinedValues>
                      <DefinedValue>
                        <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T1]" Column="ID" />
                      </DefinedValue>
                      <DefinedValue>
                        <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T1]" Column="Naziv" />
                      </DefinedValue>
                    </DefinedValues>
                    <Object Database="[Sample]" Schema="[dbo]" Table="[T1]" Index="[PK_T1]" IndexKind="Clustered" />
                  </IndexScan>
                </RelOp>
                <RelOp AvgRowSize="48" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="2" EstimateRows="1" LogicalOp="Top" NodeId="2" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="0.00362978">
                  <OutputList>
                    <ColumnReference Column="Expr1006" />
                    <ColumnReference Column="Expr1007" />
                    <ColumnReference Column="Expr1008" />
                  </OutputList>
                  <RunTimeInformation>
                    <RunTimeCountersPerThread Thread="0" ActualRows="3" ActualEndOfScans="0" ActualExecutions="3" />
                  </RunTimeInformation>
                  <Top RowCount="false" IsPercent="false" WithTies="false">
                    <TopExpression>
                      <ScalarOperator ScalarString="(1)">
                        <Const ConstValue="(1)" />
                      </ScalarOperator>
                    </TopExpression>
                    <RelOp AvgRowSize="56" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="2" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="3" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.00362948">
                      <OutputList>
                        <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="DatumUnosa" />
                        <ColumnReference Column="Expr1006" />
                        <ColumnReference Column="Expr1007" />
                        <ColumnReference Column="Expr1008" />
                      </OutputList>
                      <ComputeScalar>
                        <DefinedValues>
                          <DefinedValue>
                            <ColumnReference Column="Expr1006" />
                            <ScalarOperator ScalarString="[Sample].[dbo].[T2].[ID]">
                              <Identifier>
                                <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="ID" />
                              </Identifier>
                            </ScalarOperator>
                          </DefinedValue>
                          <DefinedValue>
                            <ColumnReference Column="Expr1007" />
                            <ScalarOperator ScalarString="[Sample].[dbo].[T2].[Atribut]">
                              <Identifier>
                                <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="Atribut" />
                              </Identifier>
                            </ScalarOperator>
                          </DefinedValue>
                          <DefinedValue>
                            <ColumnReference Column="Expr1008" />
                            <ScalarOperator ScalarString="[Sample].[dbo].[T2].[DatumUnosa]">
                              <Identifier>
                                <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="DatumUnosa" />
                              </Identifier>
                            </ScalarOperator>
                          </DefinedValue>
                        </DefinedValues>
                        <RelOp AvgRowSize="29" EstimateCPU="0.0001647" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="2" EstimateRows="1" LogicalOp="Index Scan" NodeId="4" Parallel="false" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="0.0036191" TableCardinality="7">
                          <OutputList>
                            <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="ID" />
                            <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="Atribut" />
                            <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="DatumUnosa" />
                          </OutputList>
                          <RunTimeInformation>
                            <RunTimeCountersPerThread Thread="0" ActualRows="3" ActualEndOfScans="0" ActualExecutions="3" />
                          </RunTimeInformation>
                          <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
                            <DefinedValues>
                              <DefinedValue>
                                <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="ID" />
                              </DefinedValue>
                              <DefinedValue>
                                <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="Atribut" />
                              </DefinedValue>
                              <DefinedValue>
                                <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="DatumUnosa" />
                              </DefinedValue>
                            </DefinedValues>
                            <Object Database="[Sample]" Schema="[dbo]" Table="[T2]" Index="[IX_T2]" IndexKind="NonClustered" />
                            <Predicate>
                              <ScalarOperator ScalarString="[Sample].[dbo].[T2].[ID]=[Sample].[dbo].[T1].[ID]">
                                <Compare CompareOp="EQ">
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T2]" Column="ID" />
                                    </Identifier>
                                  </ScalarOperator>
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Database="[Sample]" Schema="[dbo]" Table="[T1]" Column="ID" />
                                    </Identifier>
                                  </ScalarOperator>
                                </Compare>
                              </ScalarOperator>
                            </Predicate>
                          </IndexScan>
                        </RelOp>
                      </ComputeScalar>
                    </RelOp>
                  </Top>
                </RelOp>
              </NestedLoops>
            </RelOp>
          </QueryPlan>
        </StmtSimple>
      </Statements>
    </Batch>
  </BatchSequence>
</ShowPlanXML>