what is difference between delete and truncet ?
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
What is the relationship that exists inside in E-R diagram?
On startup, the transaction log of a database has filled and recovery has suspended, what can I do?
What is the difference between oracle and MS Access?
What is the function of cluster index?
Is storing images in a database a good idea?
What is a database lookup?
Explain the field term used in database.
Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it
What advantages does DBMS have over traditional file systems?
How concurrency problems effect the database?
Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
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 a database example?
Which three commands cause a transaction to end?
Which database is best to store images?