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.

TRS and BJP Friendship - MIM is silent!

Congress is the main opposition to ruling TRS in Telangana State. TRS political movements too were against to Congress in the state. Recent developments reveal that TRS is the strong political Non-NDA alliance to the BJP. TRS proves it many times during the Parliament sessions. Party stall the proceedings in Lok Sabha in the name of Muslim Reservations. TRS agitation helps BJP to avoid No-Confidence Motion. KCR raises non-Congress and Non-BJP front and met many Congress alliance parties but not NDA's. Telngana Finance Minister was not attend in any Finance Ministers meeting against to 15th Finance meeting recommendations. TRS wants for SCS to Telangana when Congress Working Committee declared it's stand on giving SCS to Andhra Pradesh. All these developments uphold the rumors of possible alliance between BJP and TRS after 2019 General Elections. As per latest political development in New Delhi, that KCR held one hour long meeting with Prime Minister Naredra Modi on variou...

A2Z

Search This Blog