Is Delete Faster With Index?
Is Delete Faster With Index? and while it seems to run slightly faster than the first, it’s still a lot slower with the indexes than without. How can I speed up delete in SQL Server? Removing all the rows fast with truncate. Using create-table-as-select to wipe a large fraction of the data. Dropping or truncating