<?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.0" Build="9.00.3152.00" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
  <BatchSequence>
    <Batch>
      <Statements>
        <StmtSimple StatementCompId="1" StatementEstRows="92.0925" StatementId="1" StatementOptmLevel="FULL" StatementSubTreeCost="8.9569" StatementText="SELECT TP.LocID&#xD;&#xA;      ,TP.Date&#xD;&#xA;      ,TP.Hour&#xD;&#xA;      ,TP.Rainfall&#xD;&#xA;  FROM Rainfall_con TP&#xD;&#xA; WHERE TP.Date = '20080106' AND TP.Hour = 15&#xD;&#xA; ORDER BY LocID&#xD;&#xA;" StatementType="SELECT">
          <StatementSetOptions ANSI_NULLS="false" ANSI_PADDING="false" ANSI_WARNINGS="false" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="false" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="false" />
          <QueryPlan CachedPlanSize="17" CompileTime="53" CompileCPU="5" CompileMemory="192">
            <MissingIndexes>
              <MissingIndexGroup Impact="99.5485">
                <MissingIndex Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_Con]">
                  <ColumnGroup Usage="EQUALITY">
                    <Column Name="[Date]" ColumnId="2" />
                    <Column Name="[Hour]" ColumnId="3" />
                  </ColumnGroup>
                  <ColumnGroup Usage="INCLUDE">
                    <Column Name="[LocID]" ColumnId="1" />
                    <Column Name="[Rainfall]" ColumnId="4" />
                  </ColumnGroup>
                </MissingIndex>
              </MissingIndexGroup>
            </MissingIndexes>
            <RelOp AvgRowSize="29" EstimateCPU="0.0291706" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="92.0925" LogicalOp="Gather Streams" NodeId="0" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="8.9569">
              <OutputList>
                <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_Con]" Alias="[TP]" Column="LocID" />
                <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_Con]" Alias="[TP]" Column="Date" />
                <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_Con]" Alias="[TP]" Column="Hour" />
                <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_Con]" Alias="[TP]" Column="Rainfall" />
              </OutputList>
              <Parallelism>
                <OrderBy>
                  <OrderByColumn Ascending="true">
                    <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_Con]" Alias="[TP]" Column="LocID" />
                  </OrderByColumn>
                </OrderBy>
                <RelOp AvgRowSize="29" EstimateCPU="0.000192473" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="92.0925" LogicalOp="Inner Join" NodeId="1" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="8.92773">
                  <OutputList>
                    <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_Con]" Alias="[TP]" Column="LocID" />
                    <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_Con]" Alias="[TP]" Column="Date" />
                    <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_Con]" Alias="[TP]" Column="Hour" />
                    <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_Con]" Alias="[TP]" Column="Rainfall" />
                  </OutputList>
                  <NestedLoops Optimized="false" WithOrderedPrefetch="true">
                    <OuterReferences>
                      <ColumnReference Column="Bmk1000" />
                      <ColumnReference Column="Expr1005" />
                    </OuterReferences>
                    <RelOp AvgRowSize="28" EstimateCPU="1.4468" EstimateIO="6.02535" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="92.0925" LogicalOp="Index Scan" NodeId="3" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="7.47215">
                      <OutputList>
                        <ColumnReference Column="Bmk1000" />
                        <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_Con]" Alias="[TP]" Column="LocID" />
                        <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_Con]" Alias="[TP]" Column="Date" />
                        <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_Con]" Alias="[TP]" Column="Hour" />
                      </OutputList>
                      <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                        <DefinedValues>
                          <DefinedValue>
                            <ColumnReference Column="Bmk1000" />
                          </DefinedValue>
                          <DefinedValue>
                            <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_Con]" Alias="[TP]" Column="LocID" />
                          </DefinedValue>
                          <DefinedValue>
                            <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_Con]" Alias="[TP]" Column="Date" />
                          </DefinedValue>
                          <DefinedValue>
                            <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_Con]" Alias="[TP]" Column="Hour" />
                          </DefinedValue>
                        </DefinedValues>
                        <Object Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_Con]" Index="[PK_Rainfall_Con]" Alias="[TP]" />
                        <Predicate>
                          <ScalarOperator ScalarString="[ESD_Dev].[dbo].[Rainfall_Con].[Date] as [TP].[Date]='2008-01-06 00:00:00.000' AND [ESD_Dev].[dbo].[Rainfall_Con].[Hour] as [TP].[Hour]=(15)">
                            <Logical Operation="AND">
                              <ScalarOperator>
                                <Compare CompareOp="EQ">
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_Con]" Alias="[TP]" Column="Date" />
                                    </Identifier>
                                  </ScalarOperator>
                                  <ScalarOperator>
                                    <Const ConstValue="'2008-01-06 00:00:00.000'" />
                                  </ScalarOperator>
                                </Compare>
                              </ScalarOperator>
                              <ScalarOperator>
                                <Compare CompareOp="EQ">
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_Con]" Alias="[TP]" Column="Hour" />
                                    </Identifier>
                                  </ScalarOperator>
                                  <ScalarOperator>
                                    <Const ConstValue="(15)" />
                                  </ScalarOperator>
                                </Compare>
                              </ScalarOperator>
                            </Logical>
                          </ScalarOperator>
                        </Predicate>
                      </IndexScan>
                    </RelOp>
                    <RelOp AvgRowSize="16" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="91.0925" EstimateRewinds="0" EstimateRows="1" LogicalOp="RID Lookup" NodeId="5" Parallel="true" PhysicalOp="RID Lookup" EstimatedTotalSubtreeCost="0.298013">
                      <OutputList>
                        <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_Con]" Alias="[TP]" Column="Rainfall" />
                      </OutputList>
                      <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                        <DefinedValues>
                          <DefinedValue>
                            <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_Con]" Alias="[TP]" Column="Rainfall" />
                          </DefinedValue>
                        </DefinedValues>
                        <Object Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_Con]" Alias="[TP]" TableReferenceId="-1" />
                        <SeekPredicates>
                          <SeekPredicate>
                            <Prefix ScanType="EQ">
                              <RangeColumns>
                                <ColumnReference Column="Bmk1000" />
                              </RangeColumns>
                              <RangeExpressions>
                                <ScalarOperator ScalarString="[Bmk1000]">
                                  <Identifier>
                                    <ColumnReference Column="Bmk1000" />
                                  </Identifier>
                                </ScalarOperator>
                              </RangeExpressions>
                            </Prefix>
                          </SeekPredicate>
                        </SeekPredicates>
                      </IndexScan>
                    </RelOp>
                  </NestedLoops>
                </RelOp>
              </Parallelism>
            </RelOp>
            <ParameterList>
              <ColumnReference Column="@2" ParameterCompiledValue="(15)" />
              <ColumnReference Column="@1" ParameterCompiledValue="'20080106'" />
            </ParameterList>
          </QueryPlan>
        </StmtSimple>
      </Statements>
    </Batch>
  </BatchSequence>
</ShowPlanXML>