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
- 10008 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
Can you have more than one cursor open at any one time in a program ?
What is field record and table in database?
What is tuple in rdbms?
What is a distributed database?
How to unzip a file in ssis?
Explain the advantages of rdbms?
Where is database used?
How do I create a database in open office?
I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?
What is the best free database?
What is a php database?
What are the database objects?
What are the advantages of rdbms?
Explain database partitioning and its importance.
What is ims software environment?
