alter index

Change the compression state of future index inserts or updates using the index_compression clause.

Syntax

alter index [[database.][owner].table_name.index_name
set index_compression [= {none | page} ]

Parameter Changes

index_compression – changing the local index partition's compression state affects only index rows that are newly inserted or updated in the partition.

Example

sets the compression state to on for the index idx_char:
alter index order_line. idx_char 
    set index_compression = page
Related concepts
Changing the Compression State
alter table for Index Compression