All Forums General
31 Jan 2013
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?

Adeel Chaudhry 773 posts Joined 04/08
04 Feb 2013

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.

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.