Differentiate between TRUNCATE and DELETE: -------------------------------

What is Difference Between delete and Truncate?

Question Posted / shivaindu

9 Answers
11759 Views
I also Faced
E-Mail Answers

Answer Posted / shivaindu

Differentiate between TRUNCATE and DELETE:
-----------------------------------------
TRUNCATE deletes much faster than DELETE
TRUNCATE HAS NO CONDITION CLAUSE. WHERE AS DELETE HAS CONDITION.

Delete
~~~~~~
1> Executes triggers
2> DML statement
3> Roll back possible
4> Flash query can get the data
5> cannot free the table free space

Truncate
~~~~~~~~
1>No trigger Execution
2>DDL statement
3>No roll back possible
4>can’t get data from flash queries
5>Option to free table space

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what are the difference between clustered and a non-clustered index? : Sql dba

1033

What is the advantage of index in sql?

972

What is an inconsistent dependency?

1046

Do we need to rebuild index after truncate?

1035

What are the different types of functions in sql?

1055

What is the current version of sql?

1023

What are the features of pl sql?

1067

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

997

what is 'mysqlimport'? : Sql dba

1054

What is a call statement? Explain with an example.

1010

What is sharding in sql?

987

Is t sql a programming language?

1069

Are subqueries better than joins?

976

what are date and time intervals? : Sql dba

1057

What are variables in pl sql?

1167