Creating a Compressed Index

To designate index compression for a index or local index partition level, use the index_compression clause.

Only leaf pages are compressed. Compressed and uncompressed index rows may coexist on a single index leaf page. If compression has not been specified anywhere in the table or index DDL, then the indexes are not compressed. APL-clustered indexes are not supported by index compression. Unique indexes that have only one column are not compressed.

Specifying compression at the index level overrides index compression specified at the table level. Local index partition level specification overrides the index-level specification.

Using the create index Command

The WITH index_compression clause provides these compression options:

Related concepts
create index