Compression, Parallel Query, and Parallel DML

Compression

By using a compression algorithm specifically designed for relational data, Oracle is able to compress data much more effectively than standard compression techniques. More significantly, unlike other compression techniques, Oracle incurs virtually no performance penalty for SQL queries accessing compressed tables.

Parallel Query and Parallel DML

OADM leverages the parallel query and parallel DML feature of Oracle Database. All Base, Derived, and Aggregate tables are created with initial parallel degree.

An example of how OADM uses compression and parallel query involves the physical data model for DWB_ACCT_LVL_HIST. The code sample is:

PARALLEL (DEGREE 4)

COMPRESS

Close Window