dave-L (11/19/2012)
Thanks for all the comments. I have one more idea for addressing this. I'm thinking about partitioning my table. Everything that has already been created with the random UUID on one partition and all new, sequential UUIDs on a new partition.The partition with the old UUIDs will get sorted when I convert it to a CI and there will never be any inserts into it again. All new inserts will go into the new partition where I will ensure the UUIDs are sequential.
Just curious, which column(s) are you evaluating as a partition key?
You mentioned the application sometimes generates UUIDs outside the database, how would you manage that piece of it?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato