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
- 10158 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
What is normalization in database with example?
What is Normalization and its different forms?
What is system r?
Is database a data structure?
What is the main purpose of normalization?
Define union all operator and union.
Discuss some of the techniques that can be used to tune operational performance.
What is acid property in dbms?
Where is the data stored in a database?
What is pdo database?
I want to export the data date to date from oracle database then what can i do?
Explain types of indexing in dbms?
What is string in database?
What are the properties of a primary key in DBMS?
What entity means?
