|
|
|
| Table
Compression: |
||
| What is it? |
||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| • | Tables can be
compressed |
||||||||||||
| – | Compression
can also be specified at the partition level |
||||||||||||
| – | Indexes and
index-organized tables are not compressed |
||||||||||||
| • | Typical
compression ratios are 3:1 - 5:1 |
||||||||||||
| – | Compression is
dependent upon the actual data |
||||||||||||
| – | Compression
algorithm based on removing data |
||||||||||||
| redundancy |
|||||||||||||
| • | All DDL/DML
commands are supported on compressed |
||||||||||||
| tables |
|||||||||||||