hi

Database
Enthusiast

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
2 REPLIES
Enthusiast

Re: hi

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.
Enthusiast

Re: hi

hi,

Thank You for the answer.

Regards,
Shwetha