Archives of the TeradataForum

Message Posted: Wed, 16 Jul 2003 @ 16:18:58 GMT

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

There is a potential performance issue if you add compression to a column. The "fast path" processing on insert/selects is not employed if compression is specified on a referenced column.

This is referenced in the V2R5 documentation: Teradata RDBMS SQL Reference - Data Manipulation Statements: Page 3-113

If I recall correctly, the "fast path" they are talking about is where it won't spool the select when inserting into an empty table. It will now have to spool the result set in order to de-compress and/or compress the column(s).

Robert Meunier

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