 |
 |
Archives of the TeradataForum
Message Posted: Tue, 19 Mar 2002 @ 19:43:39 GMT
| 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
| |
