I have to implement the column compression on huge table with several columns.As I read in the manuals for compression, number of compressible/compressed values for a particular table is dependent on size of table header row.
Now i have the following questions
(1) How to know the size of table header? (2)What is the maximum number of compressible columns for a table?
my idea is to reduce the number of compressible values per column per table to make them fit into the table header row perfectly.can anyone advise me on this?
1) The size of table header is variable, and can range from 512 to 130,560 bytes (1 to 255 sectors). The table header must fit at maximum a data block (V2R6.1).
2) The limits that I know are: . You can compress 255 distinct values for an individual column at maximum; . There is no number of columns limit, as far as I know, but the the amount of compression values should not exceed 8,192 bytes.
What is the maximum row length in TD 12 allowed ? & I am creating the below table, and get the error msg (Maximum Possible row length in the table is too large ) & is it due to the max limit crossed of the table header ?
create table x ( i varchar(64000) , j varchar(250) )
whereas when i create a table with j column as varchar(200) , it allows me to create the table. Please suggest.