The FP, default, indexes are partition aware and the storage mechanism for partitioned data. The other indexes are global and can only be created on the whole table, not on an individual partition.
Think of the FP index as the default data storage mechanism. This is no different than other databases that support partitioning but global indexes only. Not all RDBMS engines support partition based indexes.
I suggest you open a case and ask for a feature enhancement around this. It has been discussed for quite some time and I tell all customers the same thing. A case with a customer use case goes a lot further to getting features like this onto the radar screen of product management and into the product.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.