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.
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.