Originally posted by mike9
Pando, What do you exactly mean by "probe".
I can read pando's mind right now... "I'll show you probing..."


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 )
This is also a trade-off between performance and administrative effort. The non-prefixed index would need to be rebuilt (in one form or another) almost every time you needed to do partition maintenance on the table.