Primary key using a local partitioned index

[mike9]

Originally posted by pando
· More expensive to probe than prefixed index

Pando, What do you exactly mean by "probe".

The index would be local so range partitionned the same way as the table and it would be unique. It would aslo containt the partition key but not in the first but last position of the index.


Also would you rather recommand to create 2 indexes:
a local prefixed unique (PK) index for ( time, project, customer)
and a local non-prefixed index for ( customer)

than only one index:
a local non-prefixed unique (PK) Index on ( customer, project, time )