Row size ----columnar

Data Modeling
Enthusiast

Row size ----columnar

I am curious about the row header. I assume my understanding is right. The rowid is 128 bits.

64 bits internal partition number, 16 or 20 hash bucket and 16 or 12 bit remainder and 32 bit uniqueness value. So when I estimate my table growth, so I think I  need to take into consideration , this extra 128 bits for each and every row. Please correct me if I am wrong. Also if there is a compressible column, then I need to think of this too.

Also I am curious about the columnar. How will be the rowid be different ?

1 REPLY
Teradata Employee

Re: Row size ----columnar

Raja, A question like this is more suited to the Database forum where performance questions are commonly answered.