Slow DELETE, but not SELECT

Here is one interesting issue – a developer complians the DELETE is very slow while the SELECT is faster with the same predicate. In this test case, I have explained, what is the real cause of a slow DELETE. Read more…..