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
- 8672 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 do you mean by entity type?
Enlist the various relationships of database.
Explain the use of assign statement in progress database?
What is 3 level architecture dbms?
How are exceptions handled in pl/sql? Give some of the internal exceptions name?
why an information gap exists in most organizations.
What is big data in database?
What is the default '-sort' order for a sql?
What do you understand by correlated subqueries in dbms?
I have a table which has lot of inserts, is it a good database design to create indexes on that table?
What do you understand by data redundancy?
What do you understand by the view and mention the steps to create, update and drop a view?
Define and explain about progress?
How do you set a primary key?
How many types of users in dbms?
