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?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / java
Do the batch delete.
ie Delete the set of records in loop and commit the transaction
Is This Answer Correct ? | 1 Yes | 0 No |
Define normalization.
What is a driver in programming?
which is the best institute to learn Oracle DBA 10g/11g, please advise, someone?
What is an example of a database?
What are the five important software components of a database management system?
How many types of relationship exist in database designing?
How to find the size of database?
Oracle precompiler translates the EMBEDDED SQL statemens into ?
What do you understand by ‘atomicity’ and ‘aggregation’?
How do I create a database?
Explain the architecture of reporting services?
Explain the terms ‘attribute’ and ‘relations’