You can create global, clustered indexes for round-robin–partitioned tables only. 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
Create a clustered index on a round-robin–partitioned table, and do not include the local index keywords. For example, on the round-robin–partitioned table currentpublishers, described in “Creating a round-robin–partitioned table”, enter:
create clustered index pub_idx on currentpublishers
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
