Primary key using a local partitioned index

[mike9]

Abhay,

Your right my point was the order of the columns realted to their cardinality. I'm also convinced that if that unique index is used the response time should be better. What I'm worried about is that the index becomes an non-prefixed index because the range key is not the left most key of the index (select index_name, alignment from user_part_indexes).

So what I'm realy wondering is the impact of having a non-prefixed index. Until now we only used prefixed PK indexes where the partition range key was the first key of the index.