I have a doubt about the "partitioned index" concept, please.
Until version 7, I used to believe that a partitioned index was the index that defined the partitioning of the table. The partitioned index also had to be a cluster index and there could only be one partitioned index per table. The partitioned index, just like the data area of the table, was also partitioned, and had the same number of partitions of the table.
Now, I'd like to know what is a "partitioned index" in DB2 version 8, please. Does it have the same meaning, characteristics and purpose than the one in the older versions? How many partitioned indexes are possible, for the same table, in V8? In V8, can I have a partitioned index that defines the partitioning criteria for the table and many other partitioned indexes, that are partitioned only to make the maintenance of the table faster? Until V7, a partitioned index had to be a cluster one. Is it the same in V8?