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.