Home Forums SQL Server 2008 SQL Server Newbies Delete taking time due to foreign keys RE: Delete taking time due to foreign keys
Ed Wagner
SSC Guru
Points: 287024
More actions
February 21, 2013 at 6:50 am
#1589931
In the original post, it's noted that there is a base table and 10 children. I'd bet there's a missing index on the foreign key of at least one of them. Have you been able to isolate the bottleneck to a single child?
Tally Tables - Performance PersonifiedString Splitting with True PerformanceBest practices on how to ask questions