处理NewID()需要很长时间

Question

我正在为一个包含200多万条记录的表执行下面的代码，但是NewID()运行起来需要很长时间。

你能推荐一种替代方法使查询速度更快吗？

DELETE FROM Table1
WHERE ID NOT IN (SELECT TOP 60000 ID FROM Table1 
WHERE flag <> '1'
ORDER BY NEWID()) 
AND
ID NOT IN(SELECT ID FROM Table1
WHERE flag = '1');

Answer 1

这个怎么样..。应该是原来的两倍

DELETE FROM Table1
WHERE ID NOT IN (SELECT TOP 60000 ID FROM Table1 
                 WHERE flag <> '1'
                 ORDER BY NEWID()) 
   AND flag != '1';