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 / 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's the best database software for mac?
What is rdbms and its types?
describe and contrast a trigger and a procedure.
Whats is an OLTP Database
What is data modelling explain?
Why not phenix, the zelinka/otwinoski libraries, etc?
What is data modelling concepts?
Explain 2nf?
What is bcnf?
Enlist ways to efficiently code transactions.
Explain the classification of Database Management System?
1. Difference between Lookup and join? 2. Difference between funnel and join? 3. What type of load you have used in your project? 4. What type of data warehouse schema you have fallowed in you project? 5. How many fact tables and dimension tables is their in project? 6. How do you kill the job process using windows environment? 7. Difference between sequence file and dataset? 8. What is delta load and subsequent load? 9. By using which stages you have implemented the SCD
What is database transaction?
What does fill factor concept mean with respect to indexes?
How to move a multi-file database?