Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 19 Mar 2002 @ 09:23:58 GMT


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


Subj:   Re: Data Row Format
 
From:   David Wellman

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

(2) One of the standard 'design things to do' in Teradata is to define all of the VARCHAR columns at the end of the table, in descending order of access frequency.


Cheers,

Dave

Ward Analytics Ltd: Information in motion (www.ward-analytics.com)



     
  <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