阅读背景:

SQL Server中的慢DELETE语句需要帮助阅读执行计划和修复

来源:互联网 

I have a delete statement that's going against one of my core application tables. The delete statement is using the table's primary key but is still taking around 30 seconds. As far as I can tell the execution plan needs to do about 12 checks in other tables where this table is a FK prior to doing the delete. I need help reading and understanding this execution plan to truly know what I can do to fix the slowness. I'm guessing some of the index seeks or clustered index scans need to be tweaked.I have a delete statement that's going against




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: