Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
What is the difference between DELETE TABLE and TRUNCATE TABLE commands
What is the difference between DELETE TABLE and TRUNCATE TABLE commands?
✍: Guest
Following are difference between them
? DELETE TABLE syntax logs the deletes thus make the delete operation
slow. TRUNCATE table does not log any information but it logs information
about deallocation of data page of the table so TRUNCATE table is faster as
compared to delete table.
? DELETE table can have criteria while TRUNCATE can not.
? TRUNCATE table can not trigger.
2007-10-25, 4890👍, 0💬
Popular Posts:
Do You Know the Book "JUnit in Action"? You should know this book. It received some good reviews. Ti...
How is the MVC design pattern used in Struts framework? In the MVS design pattern, there 3 component...
What Articles Have You Read about JUnit? There are a number of JUnit articles that you should read: ...
Which one of the following statements is TRUE in regard to overloading the ++ operator? 1 You cannot...
What metrics will you look at in order to see the project is moving successfully? Most metric sets d...