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
- 10156 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
What do you mean by denormalization?
Is there a way to detect whether fbclient.dll or fbembed.dll is loaded?
What is default value database?
What are the disadvantages of a query?
Why do not you use gnu autoconf or scons for building?
What is procedure in database?
Explain atomicity and aggregation?
Explain by listing some of dbms major advantages.
Define database.
What is dbms_output put_line?
What is father dbms?
What does you mean by s4 super key?
What is building blocks of client/server?
What are different partitioning techniques in database?
What do you know about Master Data & Transaction Info Package?
