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
- 8673 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 is dbms used for?
What is stored procedure in database?
Mention the types of join?
What are the 5 databases?
What is cold backup and hot backup (in case of oracle)?
What is index hunting and how does it help in improving query performance?
Enlist the types of cursor?
How to stop superserver service on linux using only firebird tools?
dear all,Greetings of the day.. i have a small query plz rply if u knw.. i have done MBA Hr and B.sc microbiology. i am very much interested in it industry,so i am planing to go with oracle HRMS module,can it be work out??
Mention some advantages of using dbms.
What is the best database management system?
What is a clause in terms of sql?
What do you understand by sub-queries in sql?
What is 1nf 2nf 3nf in dbms?
Mention the differences between the clustered and non-clustered index
