Truncate:1)deletes all the data but the strucure of table remains 2)Faster Compared to delete.3)truncate is autocommited statment.
delete:1)deletes all data but the structure remains same.2)slow compared to truncate.3)Delete is not auto commited.
answered
10 months ago
by anonymous