Difference between DELETE and TRUNCATE

This is the common interview question for every SQL Developer and DBA position.

DELETE	TRUNCATE
DML (Data Manipulation Language) Command.	DDL (Data Definition Language) Command.
It can be rollback.	It can't be rollback.
Using DELETE we can remove some or all records from the table. We can use WHERE clause with it.	Using TRUNCATE we can remove all records from the table at once. We can't use WHERE clause with it.
DELETE command is slow in performance.	TRUNCATE command is super faster in performance.
All deleted Triggers fire on DELETE command.	No Trigger can be fired on TRUNCATE command.
DELETE can't reset high water mark.	TRUNCATE can reset high water mark.
DELETE can't release the space from the table.	TRUNCATE can release the space from the table.

Comments

Photo : Savitri during her last days

Even after 4 decades of her death, people are very much interested to watched her (Savitri) biopic. Mahanati turned to be stupendous success. On eve of remembering Savitri, here we posted Savitri photo. The photo seems her last days. The man stand behind Savitri is Gemini Ganeshan who married Savitri. It seems that she suffered bad days during her last days.

Jagan angry on Avanthi Srinivas on Bhimili meeting!

Avanthi Srinivas was joined in YSRCP in January this year. Avanthi joined in YSRCP seeking to contest as Bhimili Assembly segment in 2019 General Elections.

Pawan Kalyan Dual stand on Mirchi issue in Telugu States!

Power Star Pawan Kalyan said again and again that he always raised the problems that existed in Two Telugu States. People from Telugu states too approached Pawan on their issues. Jana Sena President Pawan Kalyan issued a press note on Mirchi issues. It seems that Pawan questioning AP Government but silent on Telangana on Mirchi issues. Pawan Kalyan demand AP Government 11000/- as support price for Mirchi farmers. Pawan Kalyan linked Chandra Babu USA tour to Mirchi issues. Pawan compared that going other countries for investments is not much important than settling Mirchi issues. This indicates that Jana Sena President indirectly targeted CBN US tour. AP is offering highest price for Mirchi along with support price. On one side farmers from other states like Telangana, Maharashtra, Tamilnadu and Karnataka rushed to AP Market yards for selling their product. Mirchi issue started in Khammam where farmers agitated for not getting support price. Knowing this, Pawan Kalyan questioned C...

A2Z

Search This Blog