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.