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
What are different types of joins in the sql?
What is management system in dbms?
What is the structure of a table in database?
Is it possible to declare or create a cursor for update of table? If no tell me why?
Name the different data models that are available for database systems.
What is the main purpose of normalization?
What is use of foreign key?
What are the types of database lock?
What is pcbs (program communication blocks)?
Explain about the properties of cursors?
What is field record and table in database?
How do you copy a database?
What is cardinality in db?
Explain what are service-specific middleware?
What is data management process?