|
|
Archives of the TeradataForum
Message Posted: Thu, 02 Mar 2006 @ 14:27:15 GMT
Subj: | | Re: SQL for record length calculation |
|
From: | | Geoffrey Rommel |
| Is this a correct SQL statement to calculate record length? | |
Yes, but only if all your columns are fixed-length and none are compressed. Varchar or varbyte columns will, of course, vary; compression will
remove some values altogether. Tables with those sorts of columns will therefore have an average record length rather than a constant length. I
don't know of an easy way to find the average.
| |