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?
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
How to stop superserver service on linux using only firebird tools?
How do you set up a database?
What is the advantage of using preparedstatement?
What's the difference between star and snow flake schema?
What are the two main functions of queries in databases?
Where is database used?
What does clipper stand for?
for what purpose we use MDM(master data management)tell me plz.
What are the advantages of manual database?
What is hot backup (in case of oracle)?
What is an example of a database?
Can you explain insert, update and delete query?
What is a sequence in a database?
What is a checkpoint in dbms?
What is rdbms and its features?