Does Sql have better performance if columns have COMPRESS? If so how does COMPRESS help the performance? Is it because of lesser Spool space?
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.