Archives of the TeradataForum
Message Posted: Thu, 20 Jan 2005 @ 13:20:03 GMT
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."
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|