Archives of the TeradataForum

Message Posted: Thu, 23 Sep 2004 @ 09:44:19 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I'm considering using Cascade Delete for a number of related Order tables. What I want to do it to delete a number (probably in the low thousands) on Parent entries and for all its dependents to also get deleted - hence Cascade Delete.

My question is, has anyone experienced any significant down side to applying Cascade Delete, such as a significant slow down in Inserts, etc ?

Thanks.

Dave Clough
Database Designer
Database Design Group

	<Prev	Next>		<<First	<Prev	Next>	Last>>