Global indexes  Global clustered index on unpartitioned table

Chapter 10: Partitioning Tables and Indexes

Global nonclustered index on unpartitioned table

The example in Figure 10-1 shows the default nonclustered index configuration, which is supported in Adaptive Server 12.5 and later.

To create this index on the unpartitioned publishers table, enter:

create nonclustered index publish5_idx on
	publishers(pub_id)

Figure 10-1: Global nonclustered index on an unpartitioned table

This figure shows a global, nonclustered index on pub_id, index pages below it, and data pages below them, with arrows connecting index and data pages.


Copyright © 2005. Sybase Inc. All rights reserved. Global clustered index on unpartitioned table

View this book as PDF