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
- 9822 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 are some of the important security features of a dbms?
What are the three levels of data abstraction?
How can I join two tables in database?
Why does reading require write privileges on database file?
What are five main functions of a database administrator?
What do you mean by starvation in dbms?
What is data sparsity and how it effect on aggregation?
What is an image database?
What do you mean by DBMS?
What do you understand by sub-queries in sql?
Explain the difference between two and three-tier architectures.
Can you explain the 'between' clause?
How to implement a database management system?
What is information schema in database?
What do you mean by entity type?
