Adaptive Server supports unpartitioned, clustered global indexes for round-robin partitioned tables only.
If a round-robin table has more than 255 data partitions,
you cannot create a global index on that table. You must create
a local index.
An unpartitioned index allows a full table scan on all partitions. Because the leaf index page is also the data page on allpages-locked tables, this index is most useful when all data partitions reside on the same segment. You must create the index on the data-partitioning key.
For this example (Figure 10-3), we create three round-robin partitions on the publishers table from pubs2. Drop any indexes before creating the partitions.
alter table publishers partition 3
To create a clustered index on the round-robin partitioned publishers table, enter:
create clustered index publish1_idx on publishers(pub_id)
Figure 10-3: Global clustered index on a round-robin partitioned table
