| Table
Compression: |
| 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 |
|||||||||||||||