Global nonclustered index on unpartitioned table  Global clustered index on round-robin partitioned table

Chapter 10: Partitioning Tables and Indexes

Global clustered index on unpartitioned table

Figure 10-2 shows the default clustered index configuration. The table and index are unpartitioned.

To create this table on an unpartitioned publishers table, enter:

create clustered index publish4_idx 
	on publishers(pub_id)

Figure 10-2: Global clustered index on an unpartitioned table

This graphic shows a global clustered index, clustered on the pub_id column. The base table is shown as eight data pages, and it unpartitioned. The graphic shows that the index spans all data pages.


Copyright © 2005. Sybase Inc. All rights reserved. Global clustered index on round-robin partitioned table

View this book as PDF