All Forums Data Modeling
Raja_KT 1246 posts Joined 07/09
04 Oct 2013
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 ?

Raja K Thaw

My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1

Street Children suffer not by their fault. We can help them if we want.

HCDM 21 posts Joined 05/10
07 Oct 2013

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

Lee Arnett
Senior Product Manager – Healthcare Data Modeling
Monument, CO
719-351-0766
Lee.arnett@teradata.com

You must sign in to leave a comment.