Imagine a situation when you have a table with 2 million rows and you wanted to delete a million rows. These rows are not bunched together. I might want to delete row1, and then row5, and then may be row7. But I want to deletes rows that may have age < 23 What is the best way to go about deleting these rows?
Asked
Active
Viewed 186 times
-1
-
2How do you choose which rows to delete? – Robert Harvey Jan 29 '13 at 00:27
-
You have the information to delete the rows in the arrayList. The rest is up to you on how to use that information. – ProgrammerForNow Jan 29 '13 at 00:29
1 Answers
1
You will want to delete them in batches. This previous question provides some interesting answers.
Community
- 1
- 1
Ismael Ghalimi
- 3,515
- 2
- 22
- 25