alter index

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


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.


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