You can create global, clustered indexes only for round-robin–partitioned tables. Adaptive Server supports global, nonclustered, unpartitioned indexes for all types of partitioned tables.
You can create clustered and nonclustered global indexes on partitioned tables using syntax supported in Adaptive Server version 12.5.x and earlier.
When you create an index on a partitioned table, Adaptive Server automatically creates a global index, if you:
Create a nonclustered index on any partitioned table, and do not include the local index keywords. For example, on the hash-partitioned table mysalesdetail, described in “Creating a hash-partitioned table”, enter:
create nonclustered index ord_idx on mysalesdetail (au_id)
Create a clustered index on a round-robin–partitioned table, and do not include the local index keywords. For example, on currentpublishers table, described in “Creating a round-robin–partitioned table”, enter:
create clustered index pub_idx on currentpublishers
