Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 28 Sep 2007 @ 12:18:41 GMT


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


Subj:   Re: Insert / Select No More Spool
 
From:   Fabio de Lucca

I just would like to add one comment to the information passed by Kyle.

Although the data types CHAR and VARCHAR are similar (both can store characters and numbers) they are very different when speaking about the physical storage (Teradata V2R6.1 Database Design Manual - Chapter 15). The physical row format for tables containing VARCHAR columns is different than the physical row format for tables containing the same columns, but defined with the data type CHAR instead. That is the reason for the spool generation.


Fabio



     
  <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