Let?s say you have 100,000 records and you want to delete
95,000 at a time and keep only 5 thousand. But in local
memory you don?t have enough space for 95,000 records. What
do you do in this case? How do you delete without any
problem with time and performance?
Answer Posted / java
Do the batch delete.
ie Delete the set of records in loop and commit the transaction
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Where is database stored?
What is progress open edge?
What is cold backup and hot backup (in case of oracle)?
What is an example of a database?
What are reports in a database?
Can you drop all the columns of a table ?
I want to export the data date to date from oracle database then what can i do?
Compare non-clustered and clustered index
What is database schema in dbms?
Tell me about view, sequence and index in DBMS.
What is the purpose of database management system?
What is second normal form?
What is a driver in programming?
How do I delete a database in phpmyadmin?
What are the two types of database?