Query Plan for a slow performing confluence database query

original query_plan
<BatchSequence>
  <Batch>
    <Statements>
      <StmtSimple StatementText="(@P0 bigint,@P1 nvarchar(4000))select page0_.CONTENTID as CONTENTID, page0_.CHILD_POSITION as CHILD_P13_, page0_.PARENTID as PARENTID, page0_.SPACEID as SPACEID, page0_.TITLE as TITLE, page0_.VERSION as VERSION, page0_.CREATOR as CREATOR, page0_.CREATIONDATE as CREATION6_, page0_.LASTMODIFIER as LASTMODI7_, page0_.LASTMODDATE as LASTMODD8_, page0_.VERSIONCOMMENT as VERSIONC9_, page0_.PREVVER as PREVVER, page0_.CONTENT_STATUS as CONTENT11\_ from CONTENT page0\_ where page0_.CONTENTTYPE='PAGE' and ((page0_.SPACEID= @P0&nbsp; )and(lower(page0_.TITLE)= @P1&nbsp; )and(page0_.PREVVER is null )and(page0_.CONTENT_STATUS='current' ))" StatementId="1" StatementCompId="1" StatementType="SELECT" StatementSubTreeCost="0.334727" StatementEstRows="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound">
          <QueryPlan CachedPlanSize="31" CompileTime="5" CompileCPU="5" CompileMemory="272">
             <MissingIndexes>
                <MissingIndexGroup Impact="98.8451">
                <MissingIndex Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]">
                   <ColumnGroup Usage="EQUALITY">
                      <Column Name="\[CONTENTTYPE\]" ColumnId="2" />
                      <Column Name="\[PREVVER\]" ColumnId="10" />
                      <Column Name="\[CONTENT_STATUS\]" ColumnId="11" />
                      <Column Name="\[SPACEID\]" ColumnId="12" />
                   </ColumnGroup>
                </MissingIndex>
                </MissingIndexGroup>
             </MissingIndexes>
             <RelOp NodeId="1" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1" EstimateIO="0" EstimateCPU="2.39138e-006" AvgRowSize="412" EstimatedTotalSubtreeCost="0.334727" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                <OutputList>
                   <ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="CONTENTID" />
                   <ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="TITLE" />
                   <ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="VERSION" /><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="CREATOR" /><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="CREATIONDATE" /><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="LASTMODIFIER" /><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="LASTMODDATE" /><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="VERSIONCOMMENT" /><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="PREVVER" /><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="CONTENT_STATUS" /><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="SPACEID" /><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="CHILD_POSITION" /><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="PARENTID" /></OutputList><Filter StartupExpression="0"><RelOp NodeId="2" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1.6158" EstimateIO="0" EstimateCPU="6.75405e-006" AvgRowSize="418" EstimatedTotalSubtreeCost="0.334725" Parallel="0" EstimateRebinds="0" EstimateRewinds="0"><OutputList><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="CONTENTID" /><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="CONTENTTYPE" /><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="TITLE" /><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="VERSION" /><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="CREATOR" /><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="CREATIONDATE" /><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="LASTMODIFIER" /><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="LASTMODDATE" /><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="VERSIONCOMMENT" /><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="PREVVER" /><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="CONTENT_STATUS" /><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="SPACEID" /><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="CHILD_POSITION" /><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="PARENTID" /></OutputList>
<NestedLoops Optimized="0"><OuterReferences>
<ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="CONTENTID" /></OuterReferences><RelOp NodeId="3" PhysicalOp="Index Scan" LogicalOp="Index Scan" EstimateRows="1.6158" EstimateIO="0.255718" EstimateCPU="0.0462591" AvgRowSize="40" EstimatedTotalSubtreeCost="0.301977" Parallel="0" EstimateRebinds="0" EstimateRewinds="0"><OutputList><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="CONTENTID" /><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="TITLE" /></OutputList><IndexScan Ordered="0" ForcedIndex="0" NoExpandHint="0">
<DefinedValues>
<DefinedValue><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="CONTENTID" /></DefinedValue><DefinedValue><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="TITLE" /></DefinedValue></DefinedValues><Object Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Index="\[c_title_idx\]" Alias="\[page0_\]" /><Predicate><ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(255),lower(\[ConfluenceBobsgear\].\[dbo\].\[CONTENT\].\[TITLE\] as \[page0_\].\[TITLE\]),0)=\[@P1\]">
<Compare CompareOp="EQ"><ScalarOperator><Convert DataType="nvarchar" Length="510" Style="0" Implicit="1"><ScalarOperator><Intrinsic FunctionName="lower"><ScalarOperator><Identifier><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="TITLE" /></Identifier></ScalarOperator></Intrinsic></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@P1" /></Identifier></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="5" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="631" EstimatedTotalSubtreeCost="0.00424176" Parallel="0" EstimateRebinds="0.615801" EstimateRewinds="0"><OutputList><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="CONTENTTYPE" /><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="VERSION" />
<ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="CREATOR" />
<ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="CREATIONDATE" />
<ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="LASTMODIFIER" />
<ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="LASTMODDATE" /><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="VERSIONCOMMENT" />
<ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="PREVVER" /><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="CONTENT_STATUS" />
<ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="SPACEID" />
<ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="CHILD_POSITION" />
<ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="PARENTID" /></OutputList>
<IndexScan Lookup="1" Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" NoExpandHint="0"><DefinedValues>
<DefinedValue><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="CONTENTTYPE" /></DefinedValue>
<DefinedValue><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="VERSION" /></DefinedValue>
<DefinedValue><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="CREATOR" /></DefinedValue>
<DefinedValue><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="CREATIONDATE" /></DefinedValue>
<DefinedValue><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="LASTMODIFIER" /></DefinedValue>
<DefinedValue><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="LASTMODDATE" /></DefinedValue>
<DefinedValue><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="VERSIONCOMMENT" /></DefinedValue>
<DefinedValue><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="PREVVER" /></DefinedValue>
<DefinedValue><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="CONTENT_STATUS" /></DefinedValue>
<DefinedValue><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="SPACEID" /></DefinedValue>
<DefinedValue><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="CHILD_POSITION" /></DefinedValue><DefinedValue><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="PARENTID" /></DefinedValue></DefinedValues><Object Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Index="\[PK__CONTENT__0EA330E9\]" Alias="\[page0_\]" TableReferenceId="-1" /><SeekPredicates><SeekPredicate><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="CONTENTID" /></RangeColumns><RangeExpressions><ScalarOperator ScalarString="\[ConfluenceBobsgear\].\[dbo\].\[CONTENT\].\[CONTENTID\] as \[page0_\].\[CONTENTID\]"><Identifier><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="CONTENTID" /></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekPredicate></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp>
<Predicate><ScalarOperator ScalarString="\[ConfluenceBobsgear\].\[dbo\].\[CONTENT\].\[SPACEID\] as \[page0_\].\[SPACEID\]=CONVERT_IMPLICIT(numeric(19,0),\[@P0\],0) AND \[ConfluenceBobsgear\].\[dbo\].\[CONTENT\].\[CONTENTTYPE\] as \[page0_\].\[CONTENTTYPE\]='PAGE' AND \[ConfluenceBobsgear\].\[dbo\].\[CONTENT\].\[PREVVER\] as \[page0_\].\[PREVVER\] IS NULL AND \[ConfluenceBobsgear\].\[dbo\].\[CONTENT\].\[CONTENT_STATUS\] as \[page0_\].\[CONTENT_STATUS\]='current'">
<Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="SPACEID" /></Identifier></ScalarOperator>
<ScalarOperator><Identifier><ColumnReference Column="ConstExpr1002"><ScalarOperator>
<Convert DataType="numeric" Precision="19" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="@P0" /></Identifier></ScalarOperator></Convert></ScalarOperator></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="CONTENTTYPE" /></Identifier></ScalarOperator>
<ScalarOperator><Const ConstValue="'PAGE'" /></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS">
<ScalarOperator><Identifier><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="PREVVER" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL" /></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ">
<ScalarOperator><Identifier><ColumnReference Database="\[ConfluenceBobsgear\]" Schema="\[dbo\]" Table="\[CONTENT\]" Alias="\[page0_\]" Column="CONTENT_STATUS" /></Identifier></ScalarOperator>
<ScalarOperator><Const ConstValue="'current'" /></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp></QueryPlan></StmtSimple>
</Statements></Batch></BatchSequence></ShowPlanXML>