Local indexes on partitioned tables

Both clustered and nonclustered local indexes are supported on all types of partitioned tables. Each index partition spans a single data partition; that is, the index partition is “equipartitioned” with the table. On range-, list-, and hash-partitioned tables, clustered indexes are always local indexes. When you create a local index, you actually create separate index trees for each partition in the table. However, Adaptive Server does not support partial indexes, so you cannot selectively create local indexes for certain partitions.