MS SQL 2005: Why would a delete from a temp table hang forever?
- by Dr. Zim
DELETE FROM #tItem_ID
WHERE #tItem_ID.Item_ID NOT IN (
SELECT DISTINCT Item_ID
FROM Item_Keyword JOIN Keyword ON Item_Keyword.Keyword_ID = Keyword.Record_ID
WHERE Keyword LIKE @tmpKW)
The Keyword is %macaroni%. Both temp tables are 3300 items long. The inner select executes in under a second. All strings are nvarchar(249). All IDs are int.
Any ideas? I executed it (it's in a stored proc) for over 12 minutes without it finishing.
