Setting Index Compression on a Local Index Partition

Use the Create Index wizard to specify index compression on a local index partition.

1. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Tables and select the table type.
2. Click the Name field of the table, then click the drop-down arrow and select Properties.
3. In the left panel, select Indexes.
4. Click the Name field of the index, then click the drop-down arrow and select Properties.
5. In the left pane, select Index Partitions.
6. Click the Name field of the index partition, then click the drop-down arrow and select Properties.
7. In the left pane, select General.
8. From the Index compression drop-down field, select Page or None.
   The Index compression field is available when the index has been created with the local index parameter.