All Forums Database
shwetha 6 posts Joined 04/07
18 Apr 2007
hi

hi all,I just wanted to know the difference between DELETE and DELETE ALL. I got to know that DELETE makes an entry in the journal(transient or permanent im not sure?) and DELETE ALL doesnt make an entry. But i wanted some detailed explanation on this.Shwetha

joedsilva 505 posts Joined 07/05
18 Apr 2007

DELETE ALL is the same as a DELETE with no WHERE clause specified. Also called as an unconstrained DELETE. This is faster when it's the last statement of a transaction or is the only statement of the transaction. That's because there's no TJ. When you specify WHERE clause in your DELETE statement, there's TJ getting involved.

shwetha 6 posts Joined 04/07
24 Apr 2007

hi,Thank You for the answer.Regards,Shwetha

You must sign in to leave a comment.