Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9821 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
How do you rename a database?
What is the most used database?
What are the types of database explain each of them briefly?
List few disadvantages of file processing system.
What is stored in a database?
What is difference between database and dbms?
What is dbms_output put_line?
Describe reporting lifecycle?
Why do we need to use a database?
What are reports in a database?
Differentiate between ‘cluster’ and ‘non-cluster’ index.
What are the advantages of using Query Strings?
Explain the difference between physical and logical data independence?
How to deactivate triggers?
Explain the different types of join operations?
