ddl_compression_def - DDL compression default configuration parameter

This parameter specifies the default value for the COMPRESS keyword of a CREATE TABLE statement.

Configuration type
Database
Parameter type
Configurable online
Propagation class
Immediate
Default [range]
No [Yes, No]

When creating a table, if ddl_compression_def is set to Yes and the COMPRESSION keyword is not specified, the default compression type is STATIC.