Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Insert into empty table with statistics
From:   Anantaraman, Kumaran (K.)


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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023