• Hi opc.three. Thanks for the reply.

    Yeah, for the most part the UUIDs are generated in the app layer, though there is some default constraints in the dB.

    As luck would have it, the dB I'm referring to is running on SSS (Fusion-IO). Do you think that on SSS it's a non-issue to have non-consecutive cluster index keys? Is the only issue index fragmentation? Any performance issues with the dB trying to "rebalance" the tree or is it just doing page splits and inserting the new keys?

    Thanks!