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?
- 3 Answers
- 9163 Views
- eBay, I also Faced
- E-Mail Answers
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
What are the main features of a database?
What are databases what are the uses of databases?
Define view, sequence and index in DBMS.
What is query in database?
What are the two types of database?
Explain about the case statement present in stored procedure?
What are the main components of a database in healthcare?
Define database lock and its types.
What is the difference between indexes,views,synonyms?
Why c++ used in clipper?
What is data in dbms?
What are 4 types of models?
What is cold backup and hot backup (in case of oracle)?
What are cursors and what are the situations you will use them?
What is 2nf in database?
