Hi,

we have created a new Declare Index and used that in join in Report Definition.

Now we are deploying it to Production and it's not working for old cases.

What is the best way to handle it if we have 2 million cases on Production ?

Suggested approach : 

For now we run a job scheduler in which we use an activity which picks up the old cases, opens it and set the property .pzReIndex to true and then save it.

While using this approach we would acquire lock on the case and it  should not interfere with cases opened by Production users, so this should be done in offline hours 

what can be done if our application is Global application ?

( Can we handle by logging those cases on which we did not acquire lock and trying the same later ? )

 Any other approach which could be used here as an alternative