Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between delete and truncet ?
- 7 Answers
- 11793 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 ? | 4 Yes | 2 No |
Post New Answer View All Answers
can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?
how to configure oracle 10g in java1.5 and tell me know how to set class path in system?
What is a trace file?
What is difference between data and database?
Explain the record term used in database.
Which is the best graph database?
What are the advantages of using database?
Explain about ur projets on teradata???
Explain various types of locks in a transaction? Which is better and why?
Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?
What is the difference between specialization and generalization?
What is a reference table in database?
How to do performance tunning a database in DB2 V8.2 UDB in linux
What is dialect in database?
What is redis good for?
