>Hi,
>I have SQL Server 2008, and want to delete 200 000 records using DELETE FROM [table] WHERE [table].[manufacturer_id]=@tnManufacturerId
>And this operation is too slow!.. more then 1 minute.
>I had try to delete it partial within WHILE.. by 1000 records per transaction, but it bring me no performance.
>I had clustered unique index by ID and also my manufacturer_id I have an index.
>
>Is there way to increase performance of DELETE FROM ?
>
>Thanks
>Denis Gavrikov
Try deleting 10K records at once without a loop.
If it's not broken, fix it until it is.
My Blog