SQL查询调优(SQL query tune up)

 如何优化以下查询？ 
 
DELETE FROM #Data 
WHERE ID NOT IN (SELECT MIN(ID)
                 FROM #Data 
                 GROUP BY SerialNumber, VendorName)
 
 最多需要2分钟才能执行。 
 
 这是表结构： 
 
CREATE TABLE #Data
(
    ID                 INT IDENTITY (1, 1),
    ItemSupplierKey    INT          NOT NULL,   
    SerialNumber       VARCHAR(100) NOT NULL,
    VendorName         VARCHAR(50)  NOT NULL
);
 
 它包含257316条记录。 
 
 以下是此临时表的索引： 
 
CREATE CLUSTERED INDEX PX_Data ON #Data (SerialNumber, VendorName);
CREATE INDEX IX_Data ON #Data (ID);

How can I optimize the below query?
 
DELETE FROM #Data 
WHERE ID NOT IN (SELECT MIN(ID)
                 FROM #Data 
                 GROUP BY SerialNumber, VendorName)
 
It takes like up to 2 minutes to execute.
 
Here is the table structure:
 
CREATE TABLE #Data
(
    ID                 INT IDENTITY (1, 1),
    ItemSupplierKey    INT          NOT NULL,   
    SerialNumber       VARCHAR(100) NOT NULL,
    VendorName         VARCHAR(50)  NOT NULL
);
 
It contains 257316 records.
 
Here are indexes on this temp table:
 
CREATE CLUSTERED INDEX PX_Data ON #Data (SerialNumber, VendorName);
CREATE INDEX IX_Data ON #Data (ID);

原文：https://stackoverflow.com/questions/26875362