One my of Teradata table occupying 2700.25 GB of Space. I did some intial analysis on this table. I have checked everything looks good i.e Primary index (NUPI), Skew everything fine. Is there any Way to reduce the table Size with out archive/delete the data.
Thank you in Advnace.
you can decrease the length of the column incase it defined large at the time of table creation than actual data size.
In my project , we have decreased decimal data type and saved good amount of space .
Kartheek Kumar Kesarla