Table Header

Database
Enthusiast

Table Header

Hi Experts,

I have a table with columns (col1,col2,col3,col4......onto col100);

Obvoiusly, the table header stores in all amp.

My question, Does this table header store all these columns? Exception : table header limit was 1mb.

Can you share your opinions.

Mack.

1 REPLY
Junior Contributor

Re: Table Header

Hi Mack,

yes, the table header is stored on each AMP, it's exactly the same for each AMP, thus the the limit is 1MB per AMP.

And yes, all column info plus PI, partitioning, compress, etc. info is also stored in the table header.

Dieter