All Forums Database
samvs 6 posts Joined 07/09
20 Jul 2009
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.

amit_dwh 13 posts Joined 06/06
24 Jul 2009

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

You must sign in to leave a comment.