A 10 GB index is to be created on the ITEM table. The index should be spread across many tablespaces, decreasing contention for index lookup, and increasing scalability and manageability. Which index would be best for this table?

A partitioned index spreads a large index across multiple tablespaces, reducing contention during index lookups and improving manageability by allowing operations on individual partitions. Bitmap indexes are for low-cardinality data, unique indexes enforce uniqueness, reverse key indexes reduce contention in sequence-based PKs, and single-column describes structure not distribution.