I'm new to this forum and only using Teradata for a few months. My team has been given task to reduce the size of 40 most critical tables. The design of the tables was poor, so a lot of data types are unnecesarily big with no COMPRESS or only 1-2 values. Also indexes are poor, but I've got this part covered by another thread i found here.
Is there any trick/query to quickly review data types and check compression? I know I need to look at the frequency of the values but not sure how many to put there. Top 10? Also, when I'm getting the frequencies the query runsh awfully long time...
Glad for any help.