How to Reduce Table Space

Database
Enthusiast

How to Reduce Table Space

Hi Experts,

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.

Anilkumar

3 REPLIES
Junior Supporter

Re: How to Reduce Table Space

Hi.

Compression (in any of the options that Teradata allows) is your best chance.

Cheers.

Carlos.

Enthusiast

Re: How to Reduce Table Space

Hi Carlos,

Thank you for Response. Compressoin already there.

Thank you,

Anil

Enthusiast

Re: How to Reduce Table Space

Hi , 

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 .

Regards 

Kartheek Kumar Kesarla