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
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.