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
- 8655 Views
- eBay, I also Faced
- E-Mail Answers
Answer Posted / pankaj gupta
First create a table using select statement with 5000 records u want to keep.. put it in memory.. then drop/truncate (not delete, that is the basic problem) the entire table.. and then put this 5000 record table in place
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a string in database?
Explain the term entity type in dbms?
What is network database?
What is a distributed database system?
How do you link a spreadsheet to a website?
What is the main purpose of database?
Explain what is meant by asymmetrical protocols?
What is meant by database system?
How do I keep my database up to date?
What is foreign key in database?
How big is a big database?
What is progress actional?
What is the role of tables in database?
What is the benefit of database?
What is super key in dbms?
