Global indexes span data in one or more partitions, which are not equipartitioned with the base table. Because Sybase supports only unpartitioned global indexes, a global index spans all partitions.
Indexes created on partitioned tables in versions of Adaptive Server earlier than 15.0 are all global indexes. Global indexes are supported for compatibility with earlier versions of Adaptive Server, and because they are particularly useful in OLTP environments.
Adaptive Server supports these types of global indexes:
Clustered indexes on round-robin and unpartitioned tables
Nonclustered indexes on all types of tables
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
