Compressed Tables Table Compression is suitable - wykład

Compressed Tables Table Compression is suitable for both OLTP applications and data
warehousing applications. Compressed tables require less disk storage and result in
improved query performance due to reduced I/O and buffer cache requirements.
Compression is transparent to applications and incurs minimal overhead during bulk
loading or regular DML operations such as INSERT, UPDATE or DELETE.
To configure table compression using SQL Developer, click the Advanced checkbox
when creating a table. Then click Table Properties and enable the Compression
option.
... zobacz całą notatkę