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
- 10159 Views
- eBay, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What's the best database software for mac?
How a Store Procedure called with a cursor out parameter.?
What is the easiest database to learn?
Define truncate and delete commands?
How to load a file into database column?
What are fact tables and dimension tables ? What is dimensional modeling and star schema design
What is data model in dbms?
Describe and contrast sql and qbe.
What is a field in database?
What is dbms pdf?
Explain the Surrogate Key in DBMS.
What are the types of model?
how to solve cardinality in dbms...many to many ralationships
What is a clause in terms of sql?
Enlist the advantages of dbms.
