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
- 9165 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
Enlist some commands of dcl?
How big is a big database?
Why its better to use files than a DBMS when there are multiple users to access the data
Define truncate and delete commands?
Where is data stored in database?
What are records and fields in a database?
What is a deadlock and mention how it can be resolved?
What is sorting in dbms?
What do you understand by query optimization?
What is service based database?
what do u mean by implementation?
Explain the Logical Schema of Database
When does checkpoint occur?
What is database in simple language?
Who invented schema theory?
