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
- 9154 Views
- eBay, I also Faced
- E-Mail Answers
Answer Posted / manjeet
First select the 5000 records u want to keep.. put it in
memory.. then delete the entire table.. and then put this
5000 record table in place
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Explain the role of metadata for the three-layer architecture.
What are the various Database states.
Differentiate between ‘delete’, ‘truncate’ and ‘drop’ commands.
Explain dml (data manipulation language)?
Do we consider null values the same as that of blank space or zero?
Explain some of the uses of openedge architect features useful for a developer?
What are the three levels of data abstraction?
Explain 5nf?
What is a database report?
What are the different stages in 'data warehousing'?
How do I create a database?
What is big data in database?
Enlist various types of interactions created by dbms?
What is database management system with example?
What is dba in dbms?
