Archives of the TeradataForum

Message Posted: Sun, 17 Jul 2005 @ 11:38:13 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

The one other thing that I gorgot to mention was that there are some special cases when TD does minimal TJ work. These are known as 'fastpath' operations and they are:

Fastpath Delete: if you code "delete from <tablename>;" then TD will empty the table very quickly - because it only writes a single (may actually be no) TJ row. To use this you must omit the WHERE clause entirely and (I think) TD must know that this is the last request in the transaction.

Fastpath Insert: when inserting into an empty table. In this case TD writes a single TJ row so that if the transaction aborts the rollback will result in an empty table.

Note that where I say 'single TJ row' above this is a single row per amp.

Cheers,

Dave

	<Prev	Next>		<<First	<Prev	Next>	Last>>