Originally posted by pando
advantage of non-prefixed index:
· Useful when fast access needed when query column not based on table partition key
· Good for historical databases

disadvantage:
· More expensive to probe than prefixed index
· Nonunique nonprefixed must scan all partitions to get the row

Also do you know the way you create your PK, on the day you have to disable it for any reason you would lose the whole index and you have to build the index for your whole fact table...?

You are good, learning new things everyday