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