Archives of the TeradataForum

Message Posted: Thu, 02 Mar 2006 @ 11:15:01 GMT

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

I guess this depends on the purpose of the calculation.

The formula above will give you an idea of the *maximum* number of bytes which may be allocated for the data in a row. If, for example, you have VARCHAR(N) columns then all of them must be filled up to their respective Ns to attain that maximum. If you use multibyte encodings you should be aware of the difference between the number of characters and the number of bytes allocated.

All of this is only data related; the formula does not take into account the space Teradata might need to allocate for internal technical purposes.

Regards,

Victor

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