![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Thu, 20 Jan 2005 @ 13:20:03 GMT
Subj: | | Re: Insert into empty table with statistics |
|
From: | | Anantaraman, Kumaran (K.) |
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
| |