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
- 9999 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
How does a database partition work?
dear sir please provide what question will be asked in bank it officer interview
How to reorder the table columns (fields)?
What is tuple and attribute?
Differentiate table scan from index scan.
What are the features of dbms?
How to use multiple database server in back end ?
What the default privileges which get assigned ?
Does youtube use a database?
Explain ddl interpreter?
What is progress open edge?
Why normalisation is required?
What you know in mapping of erd to dfd?
Explain the role of metadata for the three-layer architecture.
why an information gap exists in most organizations.
