C
ChUIMonster
Guest
"Why" is really more of a question for Rich and company 
But, speculatively, it seems to me to have at least a little bit of something to do with "placeholders" in the index blocks. George's comments about the RM chain also seem relevant. If your cleanup is a combination of updates and deletes then chunking may still help you. But if it is pure deletes my testing has convinced me that a single thread doing one record at a time is fastest. Of course I love being wrong about these things -- it means that I have learned something and the day has not been wasted. So if you have some test data that shows otherwise please share it!
Continue reading...
But, speculatively, it seems to me to have at least a little bit of something to do with "placeholders" in the index blocks. George's comments about the RM chain also seem relevant. If your cleanup is a combination of updates and deletes then chunking may still help you. But if it is pure deletes my testing has convinced me that a single thread doing one record at a time is fastest. Of course I love being wrong about these things -- it means that I have learned something and the day has not been wasted. So if you have some test data that shows otherwise please share it!Continue reading...