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
- 10025 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 Relational Algebra in RDBMS
Explain about cursors?
Describe the types of keys?
What is erd?
What are database modules?
What are the steps in creating a database?
Is excel a database?
How to tell firebird to only accept conections from xyz host or network?
What are the differences between hash join, merge join and nested loops?
What is the maximum size of an access database?
Which is fastest database?
What's the difference between delete and truncate ?
What is data example?
What are reports in a database?
what is the difference between two and three-tier architectures?
