Modifying Class Key which has around 1 Million instances
We have a class who key is defined as say Column A.
There are around 1 million instances of this class. Now we have to modify the key of this class and include another column, say column B, as key.
I know that we have to delete the instances, then update the class rule to add the new column as key. But the problem is updating all the 1 million records with an one time activity to open and re-save will take a lot of time.
We want to know if there is any alternate way of doing this.
Thanks for your reply.
It'll take a lot of time for this to happen(browse, Obj save, then delete) . And since it's in production, this amount of downtime is not something the clients want.
I'm looking if there is any alternative to this approach. Else we'll have to go with this.