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.


  <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