Cascading Delete

[Doug Serie]

I use cascading delete on my SQL Server Database. I am experiencing a
long query time on my highest level delete, 10 minutes. If I delete
from each table manually and then delete the parent, I will usually be
done in less than a minute. Any suggestions?

[Erland Sommarskog]

Re: Cascading Delete

Doug Serie (dserie@charter .net) writes:[color=blue]
> I use cascading delete on my SQL Server Database. I am experiencing a
> long query time on my highest level delete, 10 minutes. If I delete
> from each table manually and then delete the parent, I will usually be
> done in less than a minute. Any suggestions?[/color]

Did you implement the cascading delete by triggers or by referential
integrity?

In either case, care to share the relevant code and table definitions,
including indexes?


--
Erland Sommarskog, SQL Server MVP, sommar@algonet. se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp