NULL

UDA
Enthusiast

NULL

If I declare a NULL coulmn and don't COMPRESS that column then how much space that NULL value will take.
e.g
Address char(10) and I insert null for address field then how much space this null will occupy. thanks
1 REPLY
Teradata Employee

Re: NULL

If you don't COMPRESS, a NULL will occupy the same space on disk as blank or zero - e.g. for CHAR(10) that's 10 or 20 bytes (depends on the Character Set) plus an indicator bit in the rowheader.