Does COMPRESS help performance?

General

Does COMPRESS help performance?

Does Sql have better performance if columns have COMPRESS? If so how does COMPRESS help the performance? Is it because of lesser Spool space?

Tags (2)
1 REPLY
Teradata Employee

Re: Does COMPRESS help performance?

Lesser data to fetch, store, process .... meaning .... lesser bytes to read, write, access .... less I/Os which is very expensive operation. CPU time may increase but it is much efficient as compared to I/Os.