Index behavior on partitioned tables
Indexes on partitioned tables operate similarly to indexes
on nonpartitioned tables. However, indexes on partitioned tables are
stored using a different storage model, depending on whether the indexes
are partitioned or nonpartitioned.
Clustering of nonpartitioned indexes on partitioned tables
Clustering indexes offer the same benefits for partitioned
tables as they do for regular tables. However, care must be taken
with the table partitioning key definitions when choosing a clustering
index.