Specifying a Compression Level

Destination tables you create with select into do not inherit any configuration from the source table. That is, if the table from which you pull data is configured for row-level compression, the table that results from the select into is not configured for compression unless you explicitly state the compression level.

  • You can indicate column-, partition-, and table-level compression for the destination table (the compression level of the partition overrides the compression level of the table).

  • When you compress the target table, the SAP ASE server selects the compression level for columns (if they qualify), regardless of the compression level of the corresponding columns in the source table.

  • The select into command can include a list of columns that are not compressed on the target table.

  • You cannot encrypt compressed columns on a target table.