Check whether you have proper indexes for the child table.
Run a delete statement enabling execution plan and see whether the index is being used.
----------------------------------------------------------------------------------------------------------------------------------------------------
Roshan Joe
Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]