Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rajesh
Delete is DML statement which can delete data from table
which needs to be commited afterwards. But it doesn't free
memory area occupied by the data in the table.Where clause
can be used.
Truncate is DDL statement which is auto commit. It not only
deletes all data from table, but it also frees the memory
area occupied the data in the table. where clause is not
permitted. Works faster than delete statement
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the different types of joins in sql?
how to see the create table statement of an existing table? : Sql dba
What is memory optimized table?
Why use stored procedures?
How to run pl sql program in mysql?
What is view explain with example?
What are records give examples?
How do I use google cloud in sql?
What is self-join and what is the requirement of self-join?
what are the differences between char and varchar? : Sql dba
how to drop an existing table in mysql? : Sql dba
how to fetch alternate records from a table? : Sql dba
How do you concatenate in sql?
What mean sql?
Is delete faster than truncate?
