Home Forums SQL Server 2008 SQL Server Newbies Delete taking time due to foreign keys RE: Delete taking time due to foreign keys
Krishna1
Hall of Fame
Points: 3666
More actions
February 20, 2013 at 3:17 am
#1589488
Created index on foreign key tables , for key column of the base table. but no luck.
Execution plan shows index seek for these tables.
After disabling the foreign keys on this table delete goes very fast