Table Compression:
Performance Impact
Performance Impact
•Queries on
compressed tables may observe minor performance degradation
–Performance
impact depends upon the query
–Many queries
will be faster
–Compression
reduces IO but increases CPU utilization
–For a set of
heterogeneous queries, performance should degrade by no more than 5%
•Load and
direct-path INSERT performance will be slower
–Data must be
compressed as it is added to the table