Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diff between Truncate table / delete <table
name> purge
- 3 Answers
- 15717 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / d.elumalai
DELETE:
1.DML Command.
2. Can be used with WHERE clause.
3. Can be rolled back.
4. Deletes table contents row by row when executed.
5. Delete is slow
6.Doesn't frees-up the Storage Space
7.Creates the log file
8.Returns the no. of rows deleted when queried.
9. Trigger gets fired incase of Delete.
10. Date gets copied into the Rollback tablespace after
Delete is executed.
TRUNCATE:
1.A DDL Command,
2.Can't be used with WHERE clause.
3.Can't be Rolled back.
4.Drops the entire table contents when executed but not the
table. [Note:DROP commnad deletes the entire contents along
with the table]
5.Truncate is faster.
6.Frees-up the Stroage Space
7. Doesn't create a log file
8.Doesn't return the no. of rows deleted when queried.
9.Trigger doesn't get fired incase of Truncate.
10.Data gets romoved directly without copying it into the
Rollback tablespace when truncate is executed.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is sql indexing?
what are myisam tables? : Sql dba
How does cross join work?
Explain the working of foreign key?
how many ways we can we find the current date using mysql? : Sql dba
What is difference sql and mysql?
Explain polymorphism in pl/sql.
What is difference between stored function and application function?
what are all types of user defined functions? : Sql dba
What is sqlite format?
Explain constraints in sql?
What is %s in sql?
How to create an array in pl/sql?
is mysql query is case sensitive? : Sql dba
What is rownum?
