Teradata compression

Database
Enthusiast

Teradata compression

Hi,

If I want to compress columns on an table which has an associated view, will there be any impact(s) on the view after compressing the corresponding table?

Also, are there any disadvantages or performance issues that you know of regarding compression.

Thanks.
1 REPLY
Enthusiast

Re: Teradata compression

1) There would be no impact on the view.
2) Compression will improve the performance as data written/read will require less I/Os.