Archives of the TeradataForum

Message Posted: Thu, 10 Jun 2004 @ 15:55:30 GMT

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

Nazy Gholizadeh wrote:

col dec(15,0):

     NULL -> 8 bytes
     0.00 -> 8 bytes

col dec(15,0) compress:

     NULL -> 1 bit
     0.00 -> 8 bytes

col dec(15,0) compress 0:

     NULL -> 2 bits
     0.00 -> 2 bits

col dec(15,0) not null compress 0:

     NULL -> impossible
     0.00 -> 1 bit

Dieter

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