Re: A delete takes too much time

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks for your reply,

when i try to delete a record in the *.sdf file
"delete from article where articleid =20019"
through Microsoft Sql Server Management Studio it runs very fast.

the same command executed through Query Analyzer 3.0 on a pocket pc
takes ca. 12 seconds

!!! It's the same sdf file !!!

here is the execution plan from Microsoft Sql Server Management Studio
delete.sqlplan

<?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="0.5"
Build="3.0.5300.0" xmlns="http://schemas.microsoft.com/sqlserver/
2004/07/showplan">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementEstRows="1" StatementId="0"
StatementSubTreeCost="0.004335" StatementText="delete from article
where articleid = 26020 " StatementType="DELETE">
<QueryPlan>
<RelOp AvgRowSize="8" EstimateCPU="3.6E-05"
EstimateIO="0.003816" EstimateRebinds="0" EstimateRewinds="0"
EstimateRows="1" LogicalOp="Delete" NodeId="2" Parallel="false"
PhysicalOp="Table Delete" EstimatedTotalSubtreeCost="0.004335">
<OutputList />
<Update>
<Object Table="article" />
<RelOp AvgRowSize="8" EstimateCPU="0" EstimateIO="0"
EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1"
LogicalOp="Compute Scalar" NodeId="1" Parallel="false"
PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.000483">
<OutputList>
<ColumnReference Table="article"
Column="#bookmark" />
</OutputList>
<ComputeScalar>
<DefinedValues />
<RelOp AvgRowSize="8" EstimateCPU="6E-06"
EstimateIO="0.000477" EstimateRebinds="0" EstimateRewinds="0"
EstimateRows="1" LogicalOp="Index Seek" NodeId="0" Parallel="false"
PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.000483">
<OutputList>
<ColumnReference Table="article"
Column="ArticleID" />
<ColumnReference Table="article"
Column="#bookmark" />
</OutputList>
<Warnings>
<ColumnsWithNoStatistics>
<ColumnReference Table="article"
Column="ArticleID" />
</ColumnsWithNoStatistics>
</Warnings>
<IndexScan Ordered="true"
ScanDirection="FORWARD" ForcedIndex="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Table="article"
Column="ArticleID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Table="article"
Column="#bookmark" />
</DefinedValue>
</DefinedValues>
<Object Table="article" Index="PK_Article" />
<SeekPredicates>
<SeekPredicate>
<StartRange ScanType="GE">
<RangeColumns>
<ColumnReference Table="article"
Column="ArticleID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator>
<Const ConstValue="26020" />
</ScalarOperator>
</RangeExpressions>
</StartRange>
<EndRange ScanType="LE">
<RangeColumns>
<ColumnReference Table="article"
Column="ArticleID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator>
<Const ConstValue="26020" />
</ScalarOperator>
</RangeExpressions>
</EndRange>
<IsNotNull>
<ColumnReference Table="article"
Column="ArticleID" />
</IsNotNull>
</SeekPredicate>
</SeekPredicates>
</IndexScan>
</RelOp>
</ComputeScalar>
</RelOp>
</Update>
</RelOp>
</QueryPlan>
</StmtSimple>
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>

.

Relevant Pages