Re: Process of Change of PI in skewd table

Hi Omar,

To change the PI of a table you will need to recreate the table, But before making changes, make sure to analyse the demographics of the candidate PI columns. Once you have choosen a good PI, then you can recreate the table definition with new PI, and reload it, otherwise you can copy data to some temporary table, recreate the table with new PI and restore the data back to it.

If it is staging table you can create a NOPI table in TD 13.10 or later releases.

Re: Process of Change of PI in skewd table

With TD 14.., there are few enhancements.We can compress Null for data types such as array,period,distinct and structured, compression for column-partitioned tables,ALC, BLC etc.

I think below points may help you:

We can verify the table header size by creating a table with compression and without compression. Then we can subtract the currentperm to get the corresponding table header space.A table has upto 1 mb size header.