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
