<?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.4053.00" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
  <BatchSequence>
    <Batch>
      <Statements>
        <StmtSimple StatementCompId="1" StatementEstRows="4.88868" StatementId="1" StatementOptmLevel="FULL" StatementSubTreeCost="20.3974" StatementText="delete from userplanoption where userid = 123" StatementType="DELETE">
          <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="13" CompileTime="1" CompileCPU="1" CompileMemory="136">
            <MissingIndexes>
              <MissingIndexGroup Impact="99.7274">
                <MissingIndex Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]">
                  <ColumnGroup Usage="EQUALITY">
                    <Column Name="[UserID]" ColumnId="2" />
                  </ColumnGroup>
                </MissingIndex>
              </MissingIndexGroup>
            </MissingIndexes>
            <RelOp AvgRowSize="9" EstimateCPU="4.88868E-06" EstimateIO="0.01" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="4.88868" LogicalOp="Delete" NodeId="0" Parallel="false" PhysicalOp="Clustered Index Delete" EstimatedTotalSubtreeCost="20.3974">
              <OutputList />
              <Update>
                <Object Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Index="[PK_UserPlanOption_1]" />
                <RelOp AvgRowSize="40" EstimateCPU="0.00010196" EstimateIO="0.013125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="4.88868" LogicalOp="Eager Spool" NodeId="1" Parallel="false" PhysicalOp="Table Spool" EstimatedTotalSubtreeCost="20.3874">
                  <OutputList>
                    <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Column="PlanOptionID" />
                    <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Column="UserID" />
                  </OutputList>
                  <Spool>
                    <RelOp AvgRowSize="40" EstimateCPU="4.88868E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="4.88868" LogicalOp="Top" NodeId="2" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="20.3741">
                      <OutputList>
                        <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Column="PlanOptionID" />
                        <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Column="UserID" />
                      </OutputList>
                      <Top RowCount="true" IsPercent="false" WithTies="false">
                        <TopExpression>
                          <ScalarOperator ScalarString="(0)">
                            <Const ConstValue="(0)" />
                          </ScalarOperator>
                        </TopExpression>
                        <RelOp AvgRowSize="40" EstimateCPU="0.0285107" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="4.88868" LogicalOp="Gather Streams" NodeId="3" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="20.3741">
                          <OutputList>
                            <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Column="PlanOptionID" />
                            <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Column="UserID" />
                          </OutputList>
                          <Parallelism>
                            <RelOp AvgRowSize="40" EstimateCPU="2.28222" EstimateIO="17.0676" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="4.88868" LogicalOp="Clustered Index Scan" NodeId="4" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="19.3498">
                              <OutputList>
                                <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Column="PlanOptionID" />
                                <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Column="UserID" />
                              </OutputList>
                              <IndexScan Ordered="true" ForcedIndex="false" NoExpandHint="false">
                                <DefinedValues>
                                  <DefinedValue>
                                    <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Column="PlanOptionID" />
                                  </DefinedValue>
                                  <DefinedValue>
                                    <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Column="UserID" />
                                  </DefinedValue>
                                </DefinedValues>
                                <Object Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Index="[PK_UserPlanOption_1]" />
                                <Predicate>
                                  <ScalarOperator ScalarString="[Chooser2].[dbo].[UserPlanOption].[UserID]=CONVERT_IMPLICIT(int,[@1],0)">
                                    <Compare CompareOp="EQ">
                                      <ScalarOperator>
                                        <Identifier>
                                          <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Column="UserID" />
                                        </Identifier>
                                      </ScalarOperator>
                                      <ScalarOperator>
                                        <Identifier>
                                          <ColumnReference Column="ConstExpr1006">
                                            <ScalarOperator>
                                              <Convert DataType="int" Style="0" Implicit="true">
                                                <ScalarOperator>
                                                  <Identifier>
                                                    <ColumnReference Column="@1" />
                                                  </Identifier>
                                                </ScalarOperator>
                                              </Convert>
                                            </ScalarOperator>
                                          </ColumnReference>
                                        </Identifier>
                                      </ScalarOperator>
                                    </Compare>
                                  </ScalarOperator>
                                </Predicate>
                              </IndexScan>
                            </RelOp>
                          </Parallelism>
                        </RelOp>
                      </Top>
                    </RelOp>
                  </Spool>
                </RelOp>
              </Update>
            </RelOp>
            <ParameterList>
              <ColumnReference Column="@1" ParameterCompiledValue="(123)" />
            </ParameterList>
          </QueryPlan>
        </StmtSimple>
      </Statements>
    </Batch>
  </BatchSequence>
</ShowPlanXML>