what is difference between delete and truncet ?
- 7 Answers
- 10052 Views
- Fidelity, I also Faced
- E-Mail Answers
Answer Posted / shivaleela
DELETE:-
1.it is a DML stmt
2.it can include WHERE condition
3.it is only delete, so it can be rolled back can be ROLL
BACK
TRUNCATE:-
1.it is a DDL stmt
2.it can not include WHERE cnd
3.it is delete+commit ,so we cant roll back can not be ROLL
BACK
Both commands accomplish identical tasks (removing all data
from a table), but TRUNCATE is much faster
Reason:When you type DELETE.all the data get copied into
the Rollback Tablespace first.then delete operation get
performed.Thatswhy when you type ROLLBACK after deleting a
table ,you can get back the data(The system get it for you
from the Rollback Tablespace).All this process take
time.But when you type TRUNCATE,it removes data directly
without copying it into the Rollback Tablespace.Thatswhy
TRUNCATE is faster.Once you Truncate you cann't get back
the data.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What is the use of graph database?
how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)
What is ole db source in ssis?
Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.
WHAT IS NEED BY METION DATFMT AND TIMFMT IN H-SEPICITION IN RPGLE?
Explain buffer manager?
How heap is implemented in database?
List the properties of a transaction.
WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?
What is odm in database?
Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.
What is database bounce?
what are wrappers and build ups and what it's use?
What is a database string?
How do you connect to a database?
