InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comSat, 21 Nov 2009 14:46:14 GMT20http://www.teradata.com/teradataforum/Topic14872-10-1.aspxFred is right! "Delete All" requires you to type 3 extra characters - that is the only difference.Under certain circumstances, Delete will use a Fastpath which avoids taking before images to the transient journal. Summary of the circumstances is:1. The statement is not running as part of an explicit or implicit transaction. So you are in Teradata mode, not running in a macro, no BT/ ET around the code. It will use Fastpath if the Delete is the last statement in a transaction (or the last statement in a multistatement request). 2. A "Where" clause will usually mean that Fastpath cannot be used. Exception is where the Where clause specifies the partitioning key on a table with a PPI. In this case Fastpath will be used.See Delete in the SQL ref manual for more info, although it is less than clear about use of the keyword all and it is easy to see why people get confused about this so often.Thu, 18 Jun 2009 13:07:26 GMTjimmhttp://www.teradata.com/teradataforum/Topic14872-10-1.aspxThere is a difference in performance between DELETE and DELETE using the ALL keyword.Using DELETE on its own causes reference to the transient journal.Using DELETE with the ALL keyword bypasses any reference to the transient journal, which will definitely impact system performance.Thu, 18 Jun 2009 12:19:41 GMTnarenderghttp://www.teradata.com/teradataforum/Topic14872-10-1.aspxNo difference, other than the noise word "ALL".Tue, 24 Mar 2009 18:32:06 GMTFred Pluebellhttp://www.teradata.com/teradataforum/Topic14872-10-1.aspxhi friends, what are the differences between delete and delete all?Tue, 24 Mar 2009 05:33:37 GMTteramurali