Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diff between Truncate table / delete <table
name> purge
- 3 Answers
- 15827 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
how to check myisam tables for errors? : Sql dba
How do you bind variables in pl sql?
What is parameter substitution in sql?
how to check server status with 'mysqladmin'? : Sql dba
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
What are the query optimization techniques?
What is the main difference between sql and pl/sql?
Why triggers are used?
What are all types of user defined functions?
What is the usage of sql functions?
Can we create index on primary key?
what is the use of double ampersand (&&) in sql queries?
what is data control language? : Sql dba
What is count * in sql?
Can there be 2 primary keys in a table?
