Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vikas
delete is slow because it creates log file while performing delete operations.We can recover data which is removed by using delete command by using rollback.
Truncate is fast because it does not create any log file while performing delete operation.We can not recover data which is removed by using truncate command.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to define a sub function?
How to use subqueries with the in operator using oracle?
Why does Oracle not permit the use of PCTUSED with indexes?
Explain the function of optimizer in oracle?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What is a data lock in oracle?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
How to select some rows from a table in oracle?
What is a lookup table in oracle?
What is the dynamic sql in oracle?
What suggestions do you have to reduce the network traffic?
Will you be able to store pictures in the database?
What is an oracle wallet?
What is MTTR advisor in Oracle?
