Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 19 Mar 2002 @ 19:43:39 GMT


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


Subj:   Re: Data Row Format
 
From:   Geoffrey Rommel

Anomy Anom wrote:

  1. Is there a particular order that the fixed length column data are stored in, i.e., integers, decimal, char, etc.?  


  2. Should a database designer group like data types in the table definition together, e.g., all integers first and varchars last?  



Dave Wellman then wrote:

  (1) The dbms will physically store the data in the order that the columns are defined.  



Just to clarify, I think Dave meant to say that the fixed-length columns will be stored in the order they're defined. As Anomy mentioned, Teradata will rearrange the columns in the physical row in this order: (1) fixed-length uncompressed columns; (2) fixed-length compressed columns, but only those that have uncompressed values will actually appear in a physical row; and (3) varchar/varbyte columns. Within each of those three groups, I believe Teradata will follow the order of the CREATE TABLE statement.


--wgr



     
  <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: 27 Dec 2016