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