如何在高速公路上从SQL中删除数据 [英] How to delete data from SQL in fastway

问题描述

嗨


我想从一张表中删除近4个lac数据，表中有近10个lac

但是只有4个lac数据我想要删除。



但同时用户或在网站上使用sama数据库。



我试图删除但它对用户来说已经慢了



所以我删除了前1000名的记录。





如何在一次尝试中删除这4个lac而不会让用户变慢



请告诉我有什么选择吗？



谢谢

Hi
I wants to delete nearly 4 lac data from one table which has nearly 10 lac in table
But only 4 lac data i wants delete.

But same time Users or using the sama data base in website.

I tried to delete but it made dead slow for the user

So Am deleting like top 1000 record .


How can i delete this 4 lac in one attempt without making slow for user

Please tell me is there any option ?

Thanks

推荐答案

阅读以下内容： http://stackoverflow.com/questions/1522057/what-is-the-fastest-way-to -slete-massive-of-record-in-sql [ ^ ]

Read the following : http://stackoverflow.com/questions/1522057/what-is-the-fastest-way-to-delete-massive-numbers-of-records-in-sql[^]

尝试批量删除行

Try to delete rows in batch

declare @batchSize int
declare @startValue int
declare @endValue int
declare @Counter int

SET @batchSize = 100

SELECT  = MIN (stockId) from t_core_stock
SELECT @endValue = MAX (stockId) from t_core_stock
SET @Counter = @startValue

WHILE (@Counter <=@endValue)
BEGIN
  DELETE t_core_stock WHERE StockID BETWEEN @Counter AND @batchSize 
  SET @Counter = @Counter + @batchSize
END

在你的表中，任何主键都在那里首先，您需要删除主键并删除记录，然后添加主键，如下所示。

Hi,

In your table any Primary Key is there then first you need to Drop Primary Key and Delete the Records then Add Primary Key like as follows.

ALTER TABLE <tablename>
DROP CONSTRAINT <pkname>

MAKE YOUR DELETE HERE

ALTER TABLE <tablename>
ADD CONSTRAINT <pkname>
PRIMARY KEY (ColumnName>)
</pkname></tablename></pkname></tablename>

问候，

GVPrabu

Regards,
GVPrabu

这篇关于如何在高速公路上从SQL中删除数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！