Primary key using a local partitioned index

[pando]

this is not gonna help you but I think in DWH for easier management you should create non-unique index then add the PK constraint to enforce uniqueness