 Меню сайта |
|
| Форма входа |
|
| Категории раздела |
|
| Поиск |
|
| Статистика |
Онлайн всего: 1 Гостей: 1 Пользователей: 0 |
|
| Приветствую Вас, Гость · RSS |
31.01.2025, 04:33 |
|
Compression in database
Compression in database may be used as an Enterprise Edition option that requires a licensing or may be used "for free" if we have Enterprise Edition".
Free compression is:
- basic compression on heap tables;
- index compression that is usable for b-tree indexted and IOTs.
Separately licensed Advanced Compression is applicable for heap tables and LOBS.
There are following restrictions for the basic compression of heap tables:
- data are compressed only during direct path inserts, that is we have to load data with SqlLoader or insert data using +APPEND hint.
Advanced Compression allows compress data in data blocks modified by any DML.
In order to switch on basic table compression it is enough to add COMPRESS keyword to the end of CREATE TABLE expression.
|
| Категория: Oracle DB administering | Добавил: basil (11.12.2013)
|
| Просмотров: 465
| Рейтинг: 0.0/0 |
|
|
