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
- 9823 Views
- eBay, I also Faced
- E-Mail Answers
Answer Posted / pankaj gupta
First create a table using select statement with 5000 records u want to keep.. put it in memory.. then drop/truncate (not delete, that is the basic problem) the entire table.. and then put this 5000 record table in place
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the main difference between union and union all?
What is the difference between horizontal and vertical partitioning?
What is difference between sql and rdbms?
What do you mean by index hunting?
Do I need ccp4?
What are the functions of database management system?
Can you explain fourth normal form and fifth normal form ?
What is the sql 'in' clause?
What are the limitations of using a model?
When is functional dependency said to be the fully functional dependency?
What is authorization and integrity manager?
Explain the Surrogate Key in DBMS.
How to lock records in a table?
What is a concurrency problem in dbms?
Define weak entity set.
