Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Antonio
Posting Yak Master
168 Posts |
Posted - 2006-03-03 : 09:58:32
|
Good afternoon all...I have a table containing 72 million records. It's taking a while to delete a set of records from the table. The WHERE clause in my delete statement is base on two columns with each having a separate index. Is there any advantage in creating a new index based on the two columns in order to speed up the delete process?Your advice would be greatly appreciated. |
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-03-03 : 10:26:17
|
No, indexes will slow your delete down, not speed it up as each index will need to be searched and updated as well as the rows being deleted.. |
|
|
Kristen
Test
22859 Posts |
|
|
|
|