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
- 10018 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 are different types of joins in sql?
What are the restrictions applicable while creating views?
What is the advantage of the database management approach
Why its better to use files than a DBMS when there are multiple users to access the data
What is sql in database management system?
Give the cobol definition of a varchar field 177 when can an insert of a new primary key value threaten referential integrity?
What is procedure in dbms?
What is network database?
What are different cursor types in dbms?
What are the different technologies used to access Database from Visual Basic?
What is built_in Subprogram ?
does pl/sql support “overloading”? Explain
what is difference between 1.append to media 2.overright the existing media when we take back up in sql server2000
What do you understand by data model?
What is sql and where is it used?
