Creating Partitioned Indexes

A local index inherits the partition strategies, partition columns, and partition bounds (for range and list partitions) of the base table.

The SAP ASE server maintains local indexes, rebuilding the local index if the base table is repartitioned with a different partition key.

The SAP ASE server supports:

Index Type

Table Type

Local clustered and nonclustered partitioned indexes

Partitioned tables

Global, clustered, unpartitioned indexes

Round-robin-partitioned tables

Global, nonclustered, unpartitioned indexes

All partitioned tables

For range-, hash-, and list-partitioned tables, clustered indexes are always local. The SAP ASE server creates a local clustered index whether or not “local index” is included in the syntax.