Saturday, 22 June 2013

Truncate Vs Delete

Truncate
Delete
Truncate Table <Table Name>
Delete from <Table Name> Where <Condition>
Cannot use Where Condition
It is possible
It Removes all the data
It deletes specified data if where condition exists.
Faster in performance wise, because it doesn't keep any logs
Slower than truncate because, it keeps logs
Rollback is not possible
Rollback is possible



No comments:

Post a Comment