It would be great if the upgrade process would take care of verifying and creating pertinent database indexes.

I think that ofbiz does not allow to do that but it woud be possible to do it either in ofbiz (better I think) or Jira.

If index creation failure would be reported as warnings. There could be an option to turn off the warnings.