Archives of the TeradataForum

Message Posted: Thu, 20 Jan 2005 @ 13:20:03 GMT

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

Dave,

The following blurb from V2R5 manual indicates that the optimizer is making that choice. With that belief, I have made a enhancement request to PAC that the explain text should indicate if the fast-path was chosen by the optimizer, and my request was accepted by PAC.

Following is from the "Teradata(r) RDBMS, SQL Reference - Volume 6, Data Manipulation Statements, V2R5.0"

"Columns defined with the COMPRESS option cannot participate in fast path optimizations, so if you perform an INSERT ... SELECT operation on compressed columns, fast path optimization is not specified by the Optimizer when it creates an access plan."

Kumaran Anantaraman

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